Stock Card Showing Negative Stock quantity Balance and Amount

[former_member746070]

Hi all,

Before posting this question, I checked for answers but could not find a suitable answer to this question:

There is an issue with the stock card showing negative stocks:

Image: stock-card-report-balance-quantity-negative.png

Users use a POS system to carry out transactions and then later updates the postings in the system (but the user ID shows that some of the transactions have been carried out manually as well - the movement types that have been used is 251 and 102).

Could someone provide feedback on this issue?

Stock Card Report T-code: S_P00_07000139

Negative stocks are not allowed in OMJ1. I don't know how to check a change log for that transaction (the change log in the transaction itself does not show changes).

Thanks

[former_member746070]

I noticed that the 'Balance Quantity' and 'Balance Amount' in the stock card report (S_P00_07000139) corresponds with the 'Closing Stock' and 'Closing Value' in MB5B. There are separate fields to add in S_P00_07000139 report to check the 'Total Stock' and 'Total Value'.

Can someone tell me the difference between the 'Balance Quantity' and 'Total Stock' in S_P00_07000139 report?

S_P00_07000139 Screenshot:

MB5B corresponding 'Closing Stock' and 'Closing Value':

Thank you

[ahmed_abdelatif]

If you totally sure that negative stock is not permitted on plant level, just you need to compare with another report with same selection criteria you can use this report for this comparison

J3RFLVMOBVEDH

Materials Management -> Inventory Management -> Environment -> Stock -> Stock Overview (New)

and see how this negative values initiated.

[former_member746070]

Hi Ahmed,

The negative values are only shown for the fields 'Balance Quantity' and 'Balance Amount' in the stock card report. The 'Total Stock' and 'Total Value' fields in the same report does not show negative values. I found out that 'Balance Quantity' and 'Balance Amount' correspond with the 'Closing Stock' and 'Closing Value' in MB5B.

I want to cross-check the 'Total Stock' in S_P00_07000139 with another report but J3RFLVMOBVEDH does not seem to have what i'm looking for.

[ahmed_abdelatif]

Hi Natasha

can you please check MB51 at this period to see what's behind this negative stock,
BTY, i face this issue before and the root cause for my case was behind (date) some movement posted in date and cancelled at another period so unfortunately you need track each movement with entry date and posting date to know the reason of this issue.

[BijayKumarBarik]

You are using best transaction code for inventory report but for your issue- Check ( transaction code-OMJ1), may be any of your plant allowed with negative posting!

[former_member746070]

Hi Bijay,

Negative stocks are not allowed. Is there a way to check a change log in OMJ1?

(there is a way to view the change log in the transaction itself but it does not display the changes done - not sure why)

[BijayKumarBarik]

This is configuration/customization element and direct change cannot be done in live system- Check development system, any transport request created in case of change on OMJ1 for plant as change on this will move by transport mechanism only to live system.

Also check in t.code OBY6 for your company code- Negative Postings Permitted check box selected!

[former_member746070]

Hi Bijay,

Negative postings have been allowed in OBY6. I noticed that it has been allowed for all company codes. Is it possible for the settings here in OBY6 to have an effect on stock quantity being negative?

Could you please elaborate on this?

Thanks!

[BijayKumarBarik]

You query on negative amount in inventory report shared with root cause. Now you need to understand logic behind(why business needed it) on OBY6 and OMJ1 primarily refer to project documents on reasons along with how MM new period opened every month ( with negative stock) ....

[former_member197616]

All are reverse movements rather in coming entris. Coupd be a reason