SAP Knowledge Base Article - Public

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


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


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


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.


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.


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


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