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
- Go to Business Analytics work center.
- Go to Design reports view.
- Open the G/L Accounts - Line Items report.
- Give the relevant company, set of books, G/L Account for WIP and accounting period (for example 008/2021).
- Check the final balance for this period and G/L Account.
- Open report WIP Inventories - Balance Summary.
- 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).
- 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