Symptom
The Report G/L Line Items does not show the expected account in Offset G/L Account. However, if you open the Journal Entry from the Report, you see the expected Offset G/L Account.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the General Ledger work center.
- Go to the Report view.
- Open the Report G/L Line Items.
- Add in View the column Offset G/L Account.
You see for the Journal Entry concerned the Account AAA (AAA represents an Offset G/L Account) whereas you expected to see the Account BBB (BBB represents an Offset G/L Account)
Cause
The logic of this Report is that if there are 200 lines for a Journal Entry Voucher (JEV), the report finds out the highest offset Credit and Debit G/L Accounts and considered it as the Offset G/L for all the lines of the JEV.
As the Account AAA has the highest amount for this JEV, we see the Account AAA in the column Offset G/L Account of the Report G/L Line Items.
Resolution
This is the current design of the Report G/L Line Items.
Keywords
G/L Line Items, Offset G/L Account, Offset , KBA , SRD-FIN-ANA , Analytics Content , Problem