Skip to Content
0
Former Member
Mar 23, 2009 at 06:55 AM

A/P Invoice Query

43 Views

Hello,

I want to come up with a Query to track pricing changes done for items on the A/P Invoice before it's added.

For instance: in the GRPO, Bread = 2$

in the target A/P invoice, Bread = 3$

At times, the users have to change these prices to correct any pricing errors that might have occurred in the GRPO. I need to trace any price changes done in the A/P invoices (i.e. from price A to price B) as well as display the name of the user who did the modification. Seems a bit difficult because the changes in the A/P are done before the A/P is added.

Is there a way that the A/P prices can be compared to the GRPO prices, especially given that the prices from the 'system information' appear as variables?

Rgds,

Henry