A particular general ledger account, for example Account XXX, shows 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
- Go to the work center General Ledger.
- Go to the view Reports.
- Select the report G/L Accounts - Line Items.
- 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.
- Go to General Ledger work center view
- Select Journal Entries view
- 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.
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.
This is the expected system behavior. The G/L account
KBA , SRD-FIN-GL , General Ledger , How To