SAP Knowledge Base Article - Public

2035733 - Report Material Inventories - Balance History Shows Negative Amounts Though Negative Inventory Is Not Allowed

Symptom

You run the Report Report Material Inventories - Balance History and for one or more materials the value is -XXX.
Since you did not change the standard settings of the system to allow negative stock you expect that no negative amounts are shown in the report.

Reproducing the Issue

  1. Go to the Supply Chain Design Master Data Work Center
  2. Navigate to Locations
  3. Select a Site/Location ID
  4. Click on the Hyperlink of the Site/Location ID

You see that the box Negative Stock Allowed has not been flagged.

  1. Go to Inventory Valuation Work Center
  2. Run the Report Material Inventories - Balance History

You see that the result for one or more materials is -XXX

Cause

This is the standard system behaviour.

The configuration in field Negative Stock Allowed only applies to stock quantity of inventory management in Logistics.
The Inventory Valuation workcenter, however,  is related to financial accounting.

In some specific cases there can be negative stock quantities and values in financial accounting.

One example is, that you create a goods receipt and a goods issue.
This increases and then decreases the quantity of a material on the logistic stock side.

For various reasons it could happen that there is a delay in the posting of the goods receipt into financial accounting while the goods issue could be posted first.
This would create a negative amount in financial accounting.

Resolution

The only way to avoid negative amounts in this context is to check immediately after the creation of documents in connection with goods movements if a Journal Entry has been created.

Keywords

KBA , SRD-FIN-ACP , Payables , How To

Product

SAP Business ByDesign all versions