SAP Knowledge Base Article - Public

2606258 - In the Report Cash - Trial Balance Your Selection Shows Bank Account/Petty Cash with # (Hash) Sign

Symptom

In the Report Cash - Trial Balance your selection is showing information in Bank Account/Petty Cash with # (Hash) sign instead of the correct amount.

Environment

SAP Business ByDesign 1802.

SAP Business ByDesign 1805.

Reproducing the Issue

On Silverlight User Interface:

  1. Go to the Business Analytics work center.
  2. Go to the Design Reports view.
  3. Search Cash - Trial Balance.
  4. Click Cash - Trial Balance.
  5. Click Go.
  6. Information on Bank Account/Petty Cash is showing.
  7. On Rows, move fields G/L Account; My Bank; Cash Location Type to Move to Not Currently Shown.
  8. On Not Currently Shown move field Line Item Currency to Move to Rows.
  9. Click Go.

Once the Report runs again, Bank Account/Petty Cash shows all information with #.

On HTML5 User Interface:

  1. Go to the Business Analytics work center.
  2. Go to the Design Reports view.
  3. Search Cash - Trial Balance.
  4. Click Cash - Trial Balance.
  5. Click Apply.
  6. Information on Bank Account/Petty Cash is showing.
  7. Go to View tab.
  8. On Row Fields, remove G/L Account; My Bank; Cash Location Type.
  9. Click Row Fields Add Fields to Row.
  10. Select Line Item Currency.
  11. Click OK.
  12. Click Go.

Once the Report runs again, Bank Account/Petty Cash shows all information with #.

Cause

The Bank Account/Petty Cash ID is in combination with Cash Location Type. So, if Cash Location Type is removed, the value of Bank Account/Petty Cash ID changes to # as the report is no longer able to fetch its value.

Resolution

Don't remove Cash Location Type while doing your field selection for the Report, this way the information will be fetched correctly.

Keywords

Cash Location Type, Bank Account/Petty Cash, Cash - Trial Balance, amount not showing, Hash Sign, Sharp Sign , KBA , sharp sign , cash - trial balance , cash location type , bank account/petty cash , amount not showing , hash sign , SRD-FIN-ANA , Analytics Content , How To

Product

SAP Business ByDesign 1802 ; SAP Business ByDesign 1805