SAP Knowledge Base Article - Public

2768069 - Line Item Currency Not Assigned in Trial Balance Report

Symptom

In the Trial Balance Report for some G/L-Accounts the Line Item Currency is not assigned.

Environment

SAP Business ByDesign

Reproducing the Issue

  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.

Cause

For Miscellaneous balance sheet accounts without subledger, the line item currency is not populated.

As a result the Journal entries for these postings have no debit- and credit- line item currency. This behavior is displayed in the G/L-Account Line items report.

The same information is being pulled in to the trial balance report and therefore displays the line item currency as not assigned.

Resolution

In terms of the report, the report can only show what is present in the Journal Entry.

The Journal Entry does not have line item currency or amount for Balance Sheet Miscellaneous G/L-Accounts (without subledger), so it's essentially initial and shown as not assigned.

Keywords

Trial Balance report; not assigned; line item currency; G/L-Account , KBA , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions