Symptom
- The fields Amount, Comparison Amount and Difference Amount in Transaction Currency is populated with value * in the App Trial Balance Comparison.
- The fields Amount, Comparison Amount and Difference Amount in Transaction Currency is populated with value * when excel report is extracted fom the App Trial Balance Comparison.
“Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.“
Environment
- Financial Accounting (FI)
- SAP S/4HANA Finance
- SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Go to App Trial Balance comparison.
- Provide the mandatory fields in Prompt.
- Click on OK.
Cause
It is not possible to summarize the amount when multiple currency postings are done to the G/L Account. This is the standard behavior of multidimensional grid reporting.
Resolution
As a work around follow these steps below:
- Go to the App Trial Balance Comparison.
- Choose field: Transaction Currency from the Dimensions.
- Add it to the Columns.
- App Trial Balance Comparison will display the Amount, Comparison Amount and Difference Amount in respective transaction currency.
Note: The field value for total amount in transaction currency will be populated with * because, summarization is not possible in case of multiple transaction currencies.
Keywords
S4_PC, trial, balance, comparison, transaction, currency, multiple, currency, posting, general, ledgers, *, multidimensional, grid, reporting , KBA , FI-FIO-GL , Fiori UI for General Ledger Accounting , FI-FIO-GL-2CL , Fiori UI for General Ledger Accounting (Public Cloud) , Problem