Showing results for 
Search instead for 
Did you mean: 

Creating a Query for Purchase Order Approval

Former Member
0 Kudos

I need to develop a query to check if any of the line totals in a new purchase order exceeds $500. I have to attach this query to the approval procedure (under 'Terms' in 'Define Approval templates'). When the 'Add' button on the purchase order is clicked, the values on the form are still not available in the database. This means, my query has to pick the data from the new purchase order form. Is there any way to build such a query? Thanks.

View Entire Topic
Active Contributor
0 Kudos

Hi Satish!

i hope i understand your issue properly.

now you cannot create such query.

all i can say - join our team at

Product and Topic Expert
Product and Topic Expert
0 Kudos

Satish, Alerts just notify the appropriate parties. They do not stop a document from being posted. This means, it is not capable to recognize the situation unless it's already stored in the DB.

Alexey. what about creating a Development Request about this topic?