SAP Knowledge Base Article - Public

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

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

  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)

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

Product

SAP Business ByDesign all versions