Symptom
You open Journal report and add Balance Line Item Currency key figure and see for certain G/L accounts with type fixed assets, balance shows zero.
Environment
SAP Business ByDesign
Reproducing the Issue
- Business Analytics Work Center
- Design reports view
- Search for Report name: Journal
- Open it and enter mandatory data and look for the results
- Add key figure Balance Line Item Currency once data loads on the report and you see the balance is zero for fixed assets G/L accounts
Cause
Usually the issue happens for miscellaneous account types without subledgers where the Line Item Currency will be zero. Each G/L Account type will have different behavior as per their usage in the system, and the Fixed Asset Accounts will not fill the Line Item Currency since Fixed Assets are always on Company Currency.
Resolution
Right system behaviour
Keywords
Report, Analytics, Financial , KBA , SRD-FIN-ANA , Analytics Content , SRD-FIN-ANA-GL , General Ledger (Reporting) , Problem