Mexico: Ad hoc report template for DIOT updated to version 1.2.1 with 24 columns

Description

Existing Ad hoc report template for Mexico DIOT has been updated to align with DIOT reporting version 1.2.1. This has 24 columns which allow Tax Withheld Method 1, 2, and 3 for the supplier and handling of VAT retention as combined negative VAT 2. This enables the base amount and withheld VAT to be populated in the report.

Limitations

The defaults for the DIOT ad hoc report provided populate the first seven columns based on data from the withholding tax transaction, and the custom fields connected to the supplier. The value columns are populated based on the accounting lines from the supplier invoice. Note that not all value columns are populated by default. The columns populated by the template are 8, 16, 20 , 21, 22, and 23. The remaining values must be populated by configuring the respective column. Configuration of the ad hoc report is done by using (AHS110) related option 11='Design Ad Hoc Report'.

KB Article

2239791