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 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.

-XXX means a negative Ending Amount for one or more materials.

Environment

SAP Business ByDesign

Reproducing the Issue

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

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

  1. Go to the 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 behavior.

The configuration in field Negative Stock Allowed only applies to stock quantity of inventory management in Logistics.
The Inventory Valuation work center, 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

negative stock allowed; material inventories; ending amount; negative amount; , KBA , SRD-FIN-ACP , Payables , How To

Product

SAP Business ByDesign all versions