3804297 - Customer/Supplier Tax ID shows '#' in All VAT / Sales Tax Items report

Customer/Supplier Tax ID field shows “#” (unassigned) in the All VAT / Sales Tax Items report.

SAP Business ByDesign

1. Go to Business Analytics Workcenter.
2. Choose Design Reports
3. Search for “All VAT / Sales Tax Items”.
4. Add the field “Customer/Supplier Tax ID” to the row fields.
5. Select an affected customer or supplier in the report filter.
6. Observe that the “Customer/Supplier Tax ID” column shows “#” (unassigned).

• Clearing is performed against a G/L account (for example, via Payment Allocation or Receivables/Payables clearing) rather than against a specific customer/supplier, so the report cannot derive a business partner Tax ID.
• The relevant customer/supplier does not have complete tax registration data maintained (for example, country/region, tax number type, tax number), or the underlying invoice lacks tax registration information, resulting in the Tax ID appearing as “#”.

1. Identify affected report rows where Customer/Supplier Tax ID is “#”.
2. Check the originating document type and how clearing was performed.
     - If clearing was posted against a G/L account (not against a customer/supplier), be aware the system cannot derive a business partner Tax ID.
     - If the Tax ID is required in the report, perform clearing against the correct customer/supplier instead of a G/L account.
3. Verify the business partner master data.
4. Maintain complete tax registration in the customer/supplier record (country/region, tax number type, tax number).
5. Ensure that future invoices and documents for this partner carry the correct tax registration information.
6. Re-run the “All VAT / Sales Tax Items” report and confirm that the Customer/Supplier Tax ID is populated for items cleared against a customer/supplier with maintained tax registration.

All VAT / Sales Tax Items, VAT report, Customer Tax ID, Supplier Tax ID, tax id shows #, unassigned, payment allocation, clearing against GL, GL account clearing, tax registration, tax number type, payer tax id, VAT items, sales tax details, reporting tax id , KBA , SRD-FIN-ACC , Financial Accounting , Problem