Skip to Content
0
Former Member
May 14, 2008 at 08:23 PM

Query for Approval - compare A/P Invoice Unit Price to PO Unit Price

655 Views

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