3418923 - Line Item Currency Not Assigned in Trial Balance Report

In the Trial Balance Report for some G/L Accounts, the Line Item Currency is displayed as 'Not assigned'. Some G/L accounts have multi currency transactions. You wonder how to check the total amount for each currency.

SAP Business ByDesign

1. Go to the General Ledger work center.
2. Go to the Lists subview in the Reports view.
3. Search for the report Trial Balance and select it.
4. Run the report for Company ABC (ABC stands for the company ID) and Set of Books XYZ (XYZ stands for the Set of Books).
5. To the row fields add the field Line Item Currency. 

For certain G/L Accounts, the Line Item Currency is Not Assigned.

Trial Balance is a standard report and it is built on a standard data source which is of type Combined. 

This is the expected behaviour for Combined data sources and all reports based on them. 

When the fields in the report view come from different basic data source, this will result in 2 lines, where one shows the data available in the first data source, and the other line shows the data from the second data source.

In order to check the sum data of line currency, you can click 'Show Result Row' in the report column to add the summary figure.

In this way, you are able to see the sum of amount for each currency under each G/L Account.

2488796 - Multiple Lines in Combined Data Sources

Trial Balance report, not assigned, line item currency, G/L-Account , KBA , SRD-FIN-ANA , Analytics Content , Problem