2572947 - Offset G/L Account Is Incorrectly Displayed In G/L Accounts - Line Items Report

A particular G/L Account XXX (XXX is the G/L Account ID) shows a journal entry transaction. When viewing this transaction, and selecting the line in which this G/L account is debited or credited, it's observed that the G/L Account(Origin) is also XXX.

When executing the G/L Accounts - Line items report for XXX, it's observed that for the same journal entry the Offset G/L Account is not XXX but YYY instead (YYY is the Offset G/L Account displayed in the report).

SAP Business ByDesign

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

Offset G/L Account displayed is YYY but if the respective journal entry is opened, system shows XXX.

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

Observe by selecting the G/L Account XXX in this journal entry that the G/L Account(Origin) maintained is XXX, so not the same as in report (YYY).

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 amounts, then that will be determined as the offsetting account. This occurs mostly in more complex postings (for example, GR/IR, Revenue Recognition, journal entries resulting from automated runs, Manual Journal Entry Vouchers, etc.) with multiple line items in debit/credit in the journal entry.

This is the expected system behavior.

Offset account, Incorrect G/L account, Offset G/L Account , KBA , offset account, incorrect g/l account , SRD-FIN-ANA-GL , General Ledger (Reporting) , How To