SAP Knowledge Base Article - Public

3371154 - Opening/total quantity and opening/total balance is negative in report: Warehouse Book Greece 

Symptom

You check that some material for opening/total quantity and opening/total balance is negative in report: Warehouse Book Greece 

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Inventory Valuation work center.
  2. Go to Reports view.
  3. Open report: Warehouse Book Greece.
  4. Enter the mandatory input. E.g. Company ID ; Set of Books; Fiscal Year; Acc Period.
  5. Run the report, and you can find opening balance and quantity for some material is negative.

Cause

The total quantity is sum of opening quantities, purchase quantities, sales quantities.

For example, opening balance is 0 ea, third party purchase quantity is 1 ea and third-party sales quantity is -3 ea.

So, the total quantity = 0 + 1 + (-3) = -2 ea. 

This is the standard system behavior.

In the report 'View' section, third party purchase quantity and third-party sales quantity are not selected, so you may neglect these two key figures, and fail to calculate the total quantity.

Resolution

In the report 'View' section, you could add the third-party purchase quantity and third-party sales quantity in your key figures.  So, you are able to explain the opening/total quantity and opening/total balance result.

Keywords

Negative quantity, Negative balance, Warehouse Book Greece report , KBA , SRD-FIN-INV , Inventory , Problem

Product

SAP Business ByDesign all versions