SAP Knowledge Base Article - Public

1970236 - Offset General Ledger Account Is Wrongly Picked in G/L Accounts - Line Items

Symptom

A particular general ledger account, for example Account XXXshows a journal entry transaction. When viewing  this transaction and selecting the line in which this G/L account is debited or credited you observe a G/L Account(Origin) as g/l account XXX only.

Now you are running G/L Accounts - Line items report for this g/l account XXX and you observe that against this same journa entry the offset General Ledger account is not XXX but instead account YYY.

Reproducing the Issue

  1. Go to the work center General Ledger.
  2. Go to the view Reports.
  3. Select the report G/L Accounts - Line Items.
  4. Enter the required fields and the GL Account XXX

Offset G/L Account picked is ex: YYY but if you see the journal entry it is XXX.

  1. Go to General Ledger work center view
  2. Select Journal Entries view
  3. Find the concenred Journal Entry

 You observe by selecting the G/L account XXX in this journal entry that the G/L Account(Origin) maintained as XXX  and is not the same as what is picked in the report.

 

 

Cause

The Offset G/L Account is always calculated for the entire document and sub-transactions in document. If there are journal entry items with highest Debit/Credit amount, then that will be determined as the offsetting account. This occurs mostly in more complex postings (e.g. GR/IR, Revenue Rec, journal entriess resulting from automated runs, Manual JEVs. etc.) with multiple line items in debit/credit in the journal entry.

Resolution

This is the expected system behavior. The G/L account

Keywords

KBA , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions