Skip to Content
0
Former Member
Mar 24, 2009 at 08:10 AM

Approval template query

51 Views

Hi,

I got a problem in creating approval template, my case is, when there is any item's line discount is greater than 15%, then the Sales Order need the sales manager to approve. I have created a approval stages and template, but for the query, I have build a query like this "SELECT 'TRUE' FROM RDR1 T0 WHERE T0.[DiscPrcnt] > 15. but the approval procedure never triggered, pls help!!

Paddy