on 2009 Jan 26 9:15 AM
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
The tables you are looking for would be: OPDN and PDN1 for GRPO; OPCH and PCH1 for AP Invoice.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
103 | |
10 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.