Purchase Approval

This question is answered

2007B

want to trigger an approval for purchase orders higher than 25000 rupees.

I need the query for this approval

Correct Answer

October 06, 2008 at 10:45 AM

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

0 Likes 0 View this answer in context

Helpful Answer