Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
AndrewCaus
Advisor
Advisor


Reporting Withholding Tax Amount with DIOT Report


 

¿Quiere leer este blog en español? Haga  clic aquí

 

Hello everyone,

Our blog post today is about to correctly report your Withholding Tax information using the SAP Document and Reporting Compliance DIOT Report. We will go through the following topics:

  • Background information

  • How to configure the report


 

Background Information


The DIOT Report only reflects the Withholding Tax that are being considered at payment.

While an invoice also generates a Withholding Amount, this amount is not supposed to appear on the report. Since the Mexican Tax Administration Service (SAT) only considers the paid amount.

 

How to configure it?


To report Withholding Tax Amounts with the SAP Document and Reporting Compliance DIOT Report, you must configure the withholding taxes for the supplier at payment.

 

  1.  Keep the V_T059PP view at the SM30 transaction for MX country.



For users who rely on a screen reader: The picture shows a screenshot of the SAP system in the SM30 transaction. The WTax Type "4% VAT (IVA) for Mexico Freight Vendor", in the Name column, is highlighted.

 

  1. Open the Business Partner at Supplier role.



For users who rely on a screen reader: The picture shows a screenshot of the SAP system in the SM30 transaction. The Business Partner field is blank, and the Display in BP Role filed is filled with the FLVN00 FI Vendor option.

 

  1. Set the relevant withholding tax.



For users who rely on a screen reader: The picture shows a screenshot of the Supplier: Withholding Tax tab. Below, is the Withholding Tax Types section with two items in the WTax Type column: M1 and M2. At the WTax Type Description column, appears a brief description for each: M1, ISR Withholding Tax and M2, VAT Withholding Tax. Both have the same WTax Code, A1.

 

After following the steps, run the SAP Document and Reporting Compliance DIOT Report and the correct amount for the Withholding Tax should be reported.

Now, when you post a clearing or partial payment, the payment will have the relevant Withholding Tax amount needed to report in SAP Document and Reporting Compliance DIOT Report, proportional to the paid amount. Also, there will be no Withholding amount showing in invoice.

 
More information:


Have a question or a suggestion? Please, leave a comment.

See you next time,
Andrew Caus