SAP Knowledge Base Article - Public

2951351 - Tax Number Does not Show in the Custom Report Created Based on Supplier Invoice Item Details Data Source

Symptom

You have created a custom report based on supplier invoice item details data source to display the tax number however the report shows # value.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Analytics work center
  2. Go to the Design Reports view 
  3. Select the custom report 
  4. Search based on Supplier and press Enter
  5. Tax number shows # value

Cause

Custom report is based on Supplier Invoice Item Details data source. When you run the report, the report is associated with supplier invoice and not based on supplier master data. Which means for those supplier invoices which does not have the tax number, it will show # value.

Resolution

You have to make sure that supplier invoices must contain tax number and then it will show in the custom report. Or else you can add data source Supplier Details to the custom report, so that tax number will be defaulted from the supplier master data.

Keywords

Tax number appears # in custom report; Supplier invoice item details data source; Tax number shows # , KBA , SRD-SRM-ANA , Analytics Content , Problem

Product

SAP Business ByDesign 2005 ; SAP Business ByDesign 2008 ; SAP Business ByDesign 2011