MB51 problem

[Former Member]

user reports that MB51 transaction figure does not report correct figures for any of the requested months ( when matched back to manual figures) for ZY05.

The problem with this transaction MB51, Until September 25th, it was balancing to my manual stock update. However, in the week of the 29th September and onwards we realised it was not balancing anymore to my manual report. and when we was trying to see if we can pick up where the difference was coming from it started to show a difference from way back. Our reports would balance everyday as bass enters invoices, transfers etc. I kept going back to different dates from as long as last year and it showing a difference now, which is not correct because we would and our external auditors would use this SAP transaction for verification as well.

And there are negative balances which should not be.

Please help me anyone how to come out from this issue.

[JL23 · Accepted solution]

what do you actually balance?

you wrote: it was balancing to my manual stock update

MB51 lists movements, not stocks.

[Former Member]

The may be multiple reasons for this difference.

1. There may not be goods receipt and you may have paid the invoices.

2. You may have issued but did not receive the goods.

3. MB51 give the documents where goods movement.

4.Your manual stock update may be wrong, you may have missed.

How were you balancing your stocks earlier. by value or by quantity and comparing with manual stock update.Check all the movements by material document.