cancel
Showing results for 
Search instead for 
Did you mean: 

"Ordered" Quantity Wrong in Item Master

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Brian....

Please check Inventory Status Report under Inventory reports. You get the exact status.......

Regards,

Rahul

Former Member
0 Kudos

Hi,

A possible way is to run Restore Item Balance function under SAP support guidance. Then no need to send your DB.

Thanks,

Gordon

Former Member
0 Kudos

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.

Former Member
0 Kudos

No. To run this utility need SAP support guidance. You can run it in test environment though.

Former Member
0 Kudos

Thanks Gordon. I have opened a support ticket with SAP.