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
- Go to the Business Analytics work center
- Go to the Design Reports view
- Select the custom report
- Search based on Supplier and press Enter
- 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