MB58 does not match with MB51 balances

[Former Member]

Hi guys,

I need your help, experts. We are consistently using MB58 for the warehouse stock reconciliation but If we generate warehouse stocks in MB51 for the particular materials it gives us different balances as shown BELOW. This is quite confusing as to which numbers to consider. Movement types displayed in MB51 are 631, 632, 633, 634 and 702. Any help will be greatly appreciated. Thank you in advance.

[JL23]

movements in MB51 will of course be the basis for the stock that is finally shown in MB58.

If one has used standard methods to load stock into a system then it should be traceable via movements, which means on the other hand if the stock load was not done with movements  then you can't use MB51 to recalculate the stock situation.

Since your stock is always higher in MB58 than based on the calculations with MB51,  the difference could as well be caused by a wrong selection in MB51, wrong summation of movements, or even by archiving of old movements which are then not visible anymore in standard execution of MB51.

In MB58 you can select an item and choose from menu Environment > material documents to see all related material documents.

Does this show the same documents as you have in MB51?

[Former Member]

Hi Jurgen,

Thanks for the reply. The materials documents for MB51 AND MB58 has the same value but in the main screen of MB58 it shows a different value. See images below.

Note: This is a consignment warehouse

Mb58 main screen is displaying 364,000

While the (Environment > Material Documents ) material documents for both MB51 and MB58 has the same quantity (356,000) so probably has the same documents.

We are wondering why in the main screen total quantity is displaying different from the material documents total quantiy.

[JL23]

If your are not able to get to the quantity with the documents displayed, then either some documents got archived already or some stock was added with unusual ways.

Your screenshots of the total can't be used for a diligent analysis it is nothing more than a picture of a car in a parking lot and asking the question how did it get there.

Your material is batch managed, so I would start listing all movements of this batch, from its initial receipt till today. Then I would recalculate if it is possible to get to the current total stock of this batch. Total stock means anywhere, stock in your own facilities and those at the customer together. What does MMBE show you?

[Former Member]

MMBE and MB58 stocks has the same total quantity.

[JL23]

It should as they are reading the same tables for customer consignment.

Still we do not know whether the entire batch was moved to customer consignment or if you have stock of the same batch somewhere else.

Do you know whether your company does any archiving, see transaction SARA for object MM_MATBEL

And you also did not tell if you came to the total stock by calculating all movements without restriction to consignment only.

do you get to the same quantities if you use the transaction S_P00_07000139  ?

This transaction is also recalculating movements.

[Lakshmipathi]

First of all, not sure, who have recommended you wrongly to check MB58 for warehouse stock.  When MB58 is executed, system displays the consignment stocks of customer and reads the table MSKU whereas, MB51 reads MKPF and MSEG tables.  Since both the transactions reads different tables, obviously, you will have different data in system.

G. Lakshmipathi

[Former Member]

We are using the MB58 to check consignment stocksof the customer. We are comparing it to MB51 for confirmation because we don't know if there is another way to check the movement in consignment warehouse.