Skip to Content

Difference in QTY between report MB5B

Difference in QTY between report MB5B

The closing stock for mat 5002980 on Dec 23rd and run report QTY, valuated and with special stock, the difference between QTY Storage loc and valuated stock. QTY storage stock + special stock is not equal to the valuated stock. User is expecting that this should be match.capture1.jpgcapture2.jpgcapture3.jpg. Please let me know your views so that i can touch base with user accordingly. Thanks,

Mukunda.

capture1.jpg (47.7 kB)
capture2.jpg (45.0 kB)
capture3.jpg (48.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 15 at 09:03 PM

    The new screenshots are about a different material number. Why did you not continue with the material number from your original question?

    You find the second part of the 309 movement by going into the detail of the movement, e.g. in MIGO.

    You probably have it not in the list because it has a different material number or a different plant number, or anything else what is not matching with your entries in the selection screen.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 02 at 09:16 PM

    Please have a look into OSS note 2000331 - MB5B shows different results for the same data

    even its title does not match with your situation, the background explained in the note however might explain it.

    So try it again and run your report in a time where no movements will be posted.

    If the result is still like it is in your screenshots, then add a screenshot from material master accounting view and MB51 with all movements from today back to the December 23rd, so that we can recalculate it.

    You can also check the movements from MB5B details and compare it with your MB51 report

    Another possibility for an inconsistency is the situation explained in OSS note 2117567 - MB5B: wrong results with FI sumarization

    Add comment
    10|10000 characters needed characters exceeded

    • mb5b-stock-issue-2.jpgmb5b-stock-issue-3.jpg

      Hi Jurgen,

      Please find the three reports embedded for different dates and which is showing the Qty 600 IT difference by adding

      Slock stock + Consignment Stock ‘W’ = Valuated stock

      from screen shot 3 I suspect 309- entry the doc 4905911785 posted on 01/26/2018 as highlighted which is causing the issue.

      Question : 1. How would i prove this to my user as this is causing the issue?

      2. From where can i find 309 + entry for the same transaction?

      3. Will there by any reason other than this to cause this difference?

      Thanks,

      Mukunda.