Symptom
The offsetting account for line item entries is displayed incorrectly in App Display Line Items in General Ledger (F2217). It does not correspond to the offsetting account that is posted in the journal entry. In particular, this occurs for FI documents that contain at least two debit and two credit line items respectively.
Environment
SAP S/4HANA Cloud Public Edition.
Cause
The offsetting account is determined according to the following algorithm:
The account to which the largest amount is posted on the credits side is entered as an offsetting account in all debit line items.
This algorithm is used first for the line items created manually (BSEG-XAUTO = SPACE).
If no offsetting account can be determined this way, the automatically created line items of the accounting document are also taken into account (BSEG-XAUTO = 'X')(for example, posting clearing items, tax line items, cash discount received, lost cash discount, exchange rate differences).
Note: The logic to derive the offsetting account is simple and does not depend on negative posting indictor eg. account with highest positive values is the offsetting account for all lines having a negative value and vise versa.
Resolution
Use the G/L Account and not the offsetting G/L Account in reporting.
See Also
Keywords
Offsetting account, line items, Display Line Items in General Ledger, F2217 , KBA , FI-FIO-GL-IS-2CL , Reporting Apps (Public Cloud) , Problem
SAP Knowledge Base Article - Public