3712712 - Export discrepancy in "Recon. Account for Account Type" flag during data export in Manage G/L Account Master Data - SAP S/4HANA Cloud Public Edition

• In the Chart of Accounts view, G/L account is not configured as a reconciliation account, and its "Recon. Account for Account Type" field is empty.
• However, when data is exported to an Excel file, the G/L account incorrectly appears as a reconciliation account for certain company codes, showing a value of "D" or "K" in the "Recon. Account for Account Type" field.

1. Open the "Manage G/L Account Master Data" app.
2. Navigate to the Company Code View.
3. Search for G/L Account.
4. Observe that the "Recon. Account for Account Type" field is not visible or is empty.
5. Export the data to a spreadsheet.
6. In the exported file, observe that the "Recon. Account for Account Type" field for some company codes has the value "D" or "K".

• The visibility of the "Reconciliation account for account type" field at the company code level is controlled by the G/L account’s assigned account group.
• Initially, the G/L Account used an account group (e.g., ABST) that made this field visible.
• The issue was triggered when the account group was changed to a different group that hides this field from the user interface.
• Standard system behavior is to automatically clear the value of a field that becomes hidden upon saving. In this specific case, this automated clearing process failed to execute, leaving the old value ("D" or "K") in the database.

1. Create a custom account group: In the Configuration Activity 103508 - "Define Account Group", copy the existing account group to a new custom account group.
2. Adjust field status: For the newly created account group, change the field status for "Reconciliation account for account type" to "Optional".
3. Update the G/L account: In the "Manage G/L Account Master Data" app, change the account group for G/L Account to the new custom account group.
4. Clear the field: After a UI refresh, the "Reconciliation account for account type" field will be visible. The value in the field can now be manually cleared, and the account can be saved successfully.

SAP Help Portal: Manage G/L Account Master Data

export discrepancy, reconciliation account flag, s/4hana, gl account, reconciliation account, data export error, chart of accounts, account group, field visibility, manage gl account master data, reconciliation account for account type, sscui define account group, optional field status, clear reconciliation account field , KBA , FI-GL-GL-N-2CL , Master Data (Public Cloud) , Problem