SAP Knowledge Base Article - Public

3427742 - Financial Report Displays  "*" as Balance Line Item/ Transaction Currency Result Instead of a Numeric Value in the Report Line Items

Symptom

When running a financial report, such as the Accounts Receivable - Line Items report, the total balance line item or balance transaction currency result shows '*' instead of a numeric value.  

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Open any financial report, for example, the G/L accounts- Line Items report or the Accounts Receivable - Open Items report. 
  2. The balance transaction currency/Balance Line Item Currency shows as * for some of the report line items.
  3. Now, add the Journal Entry ID to the report, or the Initial Journal Entry in the Accounts Receivable - Open Items report. 
  4. This time, the posting lines show values with different currencies in the Balance Transaction/ Line Item Currency column. 

Cause

For the respective report selection, transactions are created with different currencies, such as USD as well as EUR.

Resolution

  • To see the the different values with the different currencies for the report line items, granulate the report further, for example,
    • add the journal entry ID to the G/L accounts - Line Items report or 
    • add the Initial Journal Entry attribute to the Accounts Receivable - Open Items report. 
  • The report will then show the results per journal entry

However, the total Balance Line Item Currency/Balance Transaction Currency result value will again show '*' as the report cannot accumulate all the values with different currencies. 

Keywords

Transaction Currency Amount, Line Item Currency Amount, Local Currency Amount, G/L Accounts Line Items report, star, asterix, result, * , KBA , SRD-FIN-GL , General Ledger , Problem

Product

SAP Business ByDesign all versions