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