SAP Knowledge Base Article - Public

2510961 - Relevant for Withholding Tax Key Figures are Empty in Report

Symptom

When executing the Monitoring Invoices report (Data Source SRMIV_B03), no data is displayed for Key Figures related to Withholding Taxes.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Supplier Invoicing work center.
  2. Go to Reports view.
  3. Open report Monitoring Invoices.
  4. In Selection section, in the Invoice ID field, enter ABC (ABC is the Supplier Invoice ID).
  5. Click in Go button.
  6. In View section, click in Settings - Key Figures.
  7. Add the following to the Selected column: 'Gross Amount - Relevant for Withholding Tax'; 'Gross Amount in Company Currency - Relevant for Withholding'; 'Net Amount - Relevant for Withholding Tax'; 'Net Amount in Company Currency - Relevant for Withholding Tax'; 'Tax amount - Relevant for Withholding Tax' and 'Tax amount in Company Currency - Relevant for Withholding Tax'.
  8. Click in Ok button.

No data is displayed in these Key Figure fields.

Cause

The fields marked as relevant for Withholding Tax are restricted on the field determination level. They only display data when the Supplier Invoice contains the following data for withholding tax:

  • Tax type: 1 - VAT (Value Added Tax) 
  • Tax code: 2 - Domestic Purchase - Goods

This scenario is the standard system behaviour.

Resolution

If you wish to have fields displaying Withholding tax, we recommend that you create Custom Key figures.

Also if you want to know how the system is picking the Tax information for the Supplier Invoice, please see the steps below to check the information maintained in the Supplier's master data:

  1. Go to Supplier Base work center.
  2. Go to Suppliers view. 
  3. Search for XYZ (XYZ is the Supplier's ID). 
  4. Navigate to Financial Data tab.
  5. Navigate to Tax Data subtab.

In Withholding Tax Classifications section, you can see the Tax Type maintained for this Supplier. 

Keywords

Report; Supplier Invoice; Withholding Tax; Tax Code; Tax Type; VAT; Monitoring Invoices , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , AP-SIP-SIV , Supplier Invoice , How To

Product

SAP Business ByDesign all versions