on 10-19-2011 9:16 PM
I have a client that found the "ordered" quantity in the item master is incorrect for a specific item. After some research, I have found that this is the scenario that caused it:
1.) Production Order created with planned quantity of 1.
2.) Reported completion for quantity of 1.
3.) Again reported completion for quantity of 1 (in error).
4.) To avoid variances, the client physically manufactured another item and changed the planned quantity to 2.
5.) Production Order closed.
When looking at the item master for this item, it thinks there is still 1 on order (even though the production order is closed, there were 2 planned, and 2 completed). I have replicated this is a demo system. Is there any known way to fix this without sending the database to SAP? Is there any available query to run to find discrepancies in the "ordered" quantity? Thanks for the help.
Hi Brian....
Please check Inventory Status Report under Inventory reports. You get the exact status.......
Regards,
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
A possible way is to run Restore Item Balance function under SAP support guidance. Then no need to send your DB.
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,
Can we simply run the Restore Item Balances function for all items? Should users be out of the system while this is run?
Is this considered a bug on SAP's side? Closed production orders should not affect the "ordered" balance for an item.
Hi Rahul,
In this example, the inventory status report with show a balance of 1 for the ordered quantity, but the detail will show zero documents.
User | Count |
---|---|
99 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
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.