want to trigger an approval for purchase orders higher than 25000 rupees.
I need the query for this approval
Suda Sampath replied
You could click on the Document Total check box in the Terms tab and enter your Total numbers.
When you have these range scenario's you will need 3 seperate Approval templates
The amount can also be embedded into your Query..like this
For using the Amount shown on Total Before Discount you will use
SELECT 'TRUE' WHERE $[$88.0.0] = 12 AND $[$22.0.Number] <= 25000
For checking the DocTotal
SELECT 'TRUE' WHERE $[$88.0.0] = 12 AND $[$29.0.Number] <= 25000
You will need 3 queries for each of the Amount ranges which will be linked to 3 seperate Approval Templates