SAP Knowledge Base Article - Public

3112139 - Different WIP Values are Shown When Comparing WIP Inventories Against G/L Accounts - Line Items Report

Symptom

You are trying to reconcile the WIP Balances report with the G/L Account - Line Items for a specific accounting period. However, you note that the amounts are different in each report.

Environment

SAP Business ByDesign.

Reproducing the Issue

  1. Go to Business Analytics work center.
  2. Go to Design reports view.
  3. Open the G/L Accounts - Line Items report.
  4. Give the relevant company, set of books, G/L Account for WIP and accounting period (for example 008/2021).
  5. Check the final balance for this period and G/L Account.
  6. Open report WIP Inventories - Balance Summary.
  7. Give the relevant company, set of books, G/L Account for WIP as in step 4. and Key Date as 31.08.2021 (last day of the selected period).
  8. Execute the report and refer to the total WIP Value.

The WIP Value shown in the WIP Balance Summary report differs from the balance shown in the G/L Accounts - Line Items report.

Cause

This happens due to the current design of each report. The Balance Summary cannot be fully compared with reports where you enter a specific period, since a Key Date is used as selection instead of the period itself, which may not result is a precise match.

Resolution

In this case, you can refer to the Production Lots - Line Items report, which has a period-specific selection and can be compared with the G/L Accounts - Line Items report.

Keywords

WIP Clearing. G/L Account. Production Lot. Balance Summary. , KBA , SRD-FIN-ANA-INV , Inventory Accounting (Reporting) , How To

Product

SAP Business ByDesign all versions