cancel
Showing results for 
Search instead for 
Did you mean: 

AP Invoice (PU) Updating Stock.

Former Member
0 Kudos
524

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

View Entire Topic
Former Member
0 Kudos

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

Thanks,

Gordon

Former Member
0 Kudos

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
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Nyagah,

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

Jesper