Skip to Content
Former Member
Jan 26, 2009 at 09:15 AM

AP Invoice (PU) Updating Stock.


Hi All,

I have noticed that when some GRPOs are copied to AP Invoices, some of the items in the AP invoice pick a different Warehouse Code and Quantity from the those in the Goods Receipt PO. This mainly occurs for cases where the Item Descriptions for the affected items have been changed after the GRPOs have been done.

To rectify this, the users are forced to input the correct Warehouse Code and Quantity for those items. This in turn updates the stocks for the affected items. Hence, a check in the Inventory Posting List for these items reveals that the PU transaction has updated stock as well.

I want to come up with a query that tracks all the PUs that have updated stock. Which tables should I use in the query to achieve this. I only want to display the affected items only and the respective quantities that has been updated/incremented.

Thanks in advance.