AP Invoice (PU) Updating Stock.

[Former Member]

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.

Rgds,

Henry

[Former Member · Accepted solution]

The tables you are looking for would be: OPDN and PDN1 for GRPO; OPCH and PCH1 for AP Invoice.

Thanks,

Gordon

[Former Member · Accepted solution]

Hi Gordon,

Sure, you got the tables right. But I want a table or tables that can get me the information that is displayed by the Inventory Posting List. i.e. a transaction type (PU) and its resultant effect on Inventory and the Inventory Accounts. Can OINM achieve this?? Too bad I cannot query the Inventory Posting List because itself is a report. Thanks.

Rgds,

Henry

[JesperB1 · Accepted solution]

Hi Nyagah,

Indeed the OINM is the correct table. All relevant data you need for this query can be found in OINM.

Jesper

[Former Member]

All those info are in the OINM table. You need to select the object codes (18 for AP Invoice for example) to filter the records. It is a huge table.

Thanks,

Gordon