I am trying to create a query for an Approval for the following scenario:
1. User copies a Purchase Order to an A/P Invoice
2. User changes Unit Price (copied from PO) for one or more Items in the A/P Invoice
3. User clicks Add
4. Query should check to see if any of the Unit Prices are 5% (or more) higher than the original PO Unit Price and route for Approval
I know I need to compare the Unit Prices from POR1 and PCH1 and they are joined by BaseEntry and TargetEntry fields, but not sure of much else.
Please help!
Thank you,
Antoine