Negative Balance Quantity in report S_P00_07000139

[Former Member]

Hello All,

In S_P00_07000139  Stock Card report for one of client the balance Quantity is showing as negative

Can you please let me know the logic of this column,  and how it arrives at that Quantity, as for this material negative stock is not

allowed. Also I dont get the logic of showing negative stock before the initial sotck upload, also checked MB51 and not able to find

any movement before initial stock entry which was on 31st March.

Also when the 561 movement is posted for for inital stock, the balance Quantity is shown as negative which is not same as quantity

entered. Please find the screen shot and advise

I am using option Display Stock movement by Plant while executing this report.

[Former Member]

Hi,

We have similar issues. Did you found any solution.

[Former Member]

Hi Jurgen,

If I am getting you correct, is it total of all materials in that plant on particular date

Still I am not clear how it is negative, and is there any way to match the balance qty. from any other report.

[JL23]

when did you start with your SAP system?

Run the report with the start date and compare.

[ajitkumar]

you may check what is the value coming in MRN9. for all material selection give *. it will give the value and quanitty as of the end of the period of key date. ( if key date is 12.05.12 the values will be as of closing of 310512 assuming periodic value is month)

[Former Member]

Hi Priti,

I checked that post earlier, still Unable to get the logic about balance Qty.  The reply in above post says

current stock balance (both quantity and value) of each material at plant level is equal to material master data when you enter selection date as a today.

But I am entering past dates while executing this report and not current date, also it does not talk about balance qty. being negative.

[JL23]

Please put the cursor onto the value (not onto the header) and then press F1, SAP explains what each value is.

the 561 movement may be the first movement for the entered material number, but not the first movement for all your materials in that company.

[Former Member]

Hello Chintan,

Please find the below blog, in this ,it is clearly explained the login of this report..

https://scn.sap.com/thread/2150915

Hope this will help you to understand your doubts...

Regards,

Priti.

[Former Member]

is Nagetive Stocks maintained for these MAterials Check once in MB51 Report with 501 Movement type for the material and Clarify.

Thanks,

Shiva

[Former Member]

Hi,

No neagtive stock is maintained for this material.

Also checked MB51 not found any relevant entry.

[MahmoudNabeh]

• you need to understand the logic of the report S_P00_07000139:

At first from MBEW table the valuation data for the material is taken. From these values the closing and opening balances are back calculated. You can access MBEW table using T-code SE16N. The stock value and stock quantity are fetched from the MSEG table which are updated during the transactions which you have carried out. In that, the debit and credit entries('S' & 'H') values are taken and subtracted/added to achieve the opening and closing balance and quantity. So the system carries out in such a way that it takes the current stock and value and back tracks to get the opening balance and the closing balance. Please note that MBEW table holds the current valuation data and there is no way to find out valuation data at a given date in the past. Because of this current value is taken and then back-calculation happens using all the goods movement data to arrive at the opening balance.

Check sap note : https://me.sap.com/notes/2967942/E