2860983 - Report G/L Line Items does not show the expected account in Offset G/L Account

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.

SAP Business ByDesign

1. Go to the General Ledger work center.
2. Go to the Report view.
3. Open the Report G/L Line Items.
4. 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)

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.

This is the current design of the Report G/L Line Items.

G/L Line Items, Offset G/L Account, Offset , KBA , SRD-FIN-ANA , Analytics Content , Problem