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
- Open any financial report, for example, the G/L accounts- Line Items report or the Accounts Receivable - Open Items report.
- The balance transaction currency/Balance Line Item Currency shows as * for some of the report line items.
- Now, add the Journal Entry ID to the report, or the Initial Journal Entry in the Accounts Receivable - Open Items report.
- 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