DIOT reporting

Requirement

In Mexico, a periodic report must be issued for all expenses and purchases paid within the period.

The report consists of 24 columns and is reported using a TXT file.

The Declaración Informativa de Operaciones con Terceros (DIOT) report must include VAT information with the amount paid. In addition, some supplier related information must be included in the report.

M3 solution

In M3, the solution to create the DIOT report is to use the withholding tax for the suppliers for whom DIOT reporting is applicable. In addition, some fields related to the supplier information required for the report are added through custom fields. An extract of the generated data for withholding tax can be retrieved in TXT format in accordance with the local requirements. For this purpose, the M3 Ad Hoc Reporting tool from the Ad Hoc Reporting module and Excel in M3 can be used. The report, 'MX_DIOT' can be imported and then run from 'Ad Hoc Report. Open' (AHS110).

Before users can generate the report, you must import the report template. See Importing M3 Ad Hoc Reporting templates.

In 'Ad Hoc Report. Open' (AHS110) specify this information:

Program ID Field Value
AHS110/B Ad hoc report group MX_DIOT
AHS110/B Ad hoc report MX_DIOT
AHS110/E Report text DIOT Reporting
AHS110/E Locked report Not selected
AHS110/E File type 3 - Both
AHS110/E Ad hoc e-mail 1 - No e-mail
AHS110/E Save report run 3 - Yes, to next run
AHS110/E Save rep lines 3 - Yes, to next run
  1. In Ad hoc report designer, which you access from (AHS110), select MX_DIOT reporting and verify the report.
  2. Set the following to run the report:

    No. filters to '1-Division'

    Aggregation to '0-No aggregation'

    You can use the 'Selection field' to select specific records.

    For example, set 'Selection Field' to:

    'Payment Status' (SRPYST): (0 - 9)

    'Accounting Date' (SRACDT): (Date From - Date To)

    'Payment Order' (SRPYON): (1-1)

  3. To save variants of the report, click Save as.

    An XML output can also be generated in 'Ad Hoc Report Run. Open' (AHS160).

Limitations

The default values for the DIOT Ad Hoc report provided are used to 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: 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.

Importing M3 Ad Hoc Reporting templates

To complete this task, you must have the IFS security role M3BE-ConfigUser or M3BE-ConfigAdmin.

  1. In Infor M3, click Administration Tools and select Business Engine Configuration Data.
  2. On the Content tab, click the country-specific ZIP file and click the Import icon.
  3. Specify the country-specific company and division for which to import the templates, then click Import.

Open 'Ad Hoc Report. Open' (AHS110) and verify that the MX_DIOT report group is available, as per the country-specific input.

Configuration guidelines

Program ID Program name Description or comment
CRS063 Supplier Service Code. Open

For the applicable suppliers, define service codes for the calculation of the withholding tax. The service codes that you define in (CRS063) are used to identify the supplier type (Tipo de proveedor) and the operation type (Tipo de operación) in the DIOT report.

We recommend that you define these service codes for supplier types in the DIOT report:

  • 4 for domestic suppliers
  • 5 for foreign suppliers
  • 1 for both domestic and foreign suppliers

We recommend that you define these service codes for operation types in the DIOT report:

  • 3 for services
  • 6 for the national rent of building
  • 8 for operations of other types, such as operations of types 43, 46, 48, and 53.
CRS620/E Supplier. Open The VAT registration number must be specified. This is later stored when the withholding tax is created.
CRS624/F Supplier. Define Purchase & Financial

For the applicable suppliers, specify this information:

Tax withholding method

1 - Create base amount at payment.

No withheld transaction created.

2 - Create base amount at payment. Withheld transaction created upon payment.

3 - Create base amount at payment.

Withheld transaction created at invoice entry.

Service code

Specify the default service code. See the settings for (CRS063).

APS905 Settings - Accounts Payable Clear this check box: 260 Withholding tax using flexible service codes.
APS035 Settings - Supplier Tax To print invoices that have been paid during the period, set the Report method field to 1.
CMS470 Custom Field. Open

The following fields must be added:

DIOT1

DIOT2

DIOT3

See Configuration guidelines for 'Custom Field. Open' (CMS470).
CMS471/B Custom Field Group Add custom field group DIOT.
CMS472/B Sequence number

In this program it is required to specify the following fields as fields connected to custom field group DIOT.

Add the following sequence numbers

1 - Connect to custom field DIOT01

2 - Connect to custom field DIOT02

3 - Connect to custom field DIOT03
CRS150 Supplier Group. Open The supplier group is connected to the custom field group by using related option 11 - 'Connect user-defined field group'. This directs you to 'Connect Custom Field Group. Open' (CMS473). See the setup to be defined on (CMS473/B).
CMS473/B Sequence number

Add the following sequence number

1 - Connect to custom field group DIOT
AHS010 Ad Hoc Report Location. Open

When the import of configuration data is completed, the initial setup of location must strictly follow the setup below.

On panel B, specify MX-LOC in the Report loc, then click Create.

Specify the Description.

Specify the Name.

Set the File name mtd to 05-Report + Job number.

Set the Service ID to M3_IDM_CSV

Select the Save file check box.

Select the Transfer files check box

If the initial setup above is completed, the preferred Report Location can be selected afterward. However, the setup for the fields 'File name mtd', 'Service ID', 'Save file' and 'Transfer files' must follow the above setup.

Configuration guidelines for 'Custom Field. Open' (CMS470)

Program ID Field Heading Description
(CMS470/B) Custom field

The following fields must be added:

DIOT01

DIOT02

DIOT03

(CMS470/E) Description

For DIOT01, set field to Nationality

For DIOT02, set field to Operation Type

For DIOT03, set field to Supplier Type

(CMS470/E) Name

For DIOT01, set field to Nationality

For DIOT02, set field to Operation Type

For DIOT03, set field to Supplier Type

(CMS470/E) Heading

For DIOT01, set field to Nationality

For DIOT02, set field to Operation Type

For DIOT03, set field to Supplier Type

(CMS470/E) Field type

For DIOT01, set field to Alphanumeric

For DIOT02, set field to Alphanumeric

For DIOT03, set field to Alphanumeric

(CMS470/E) Field length

For DIOT01, set field to 20 positions

For DIOT02, set field to 2 positions

For DIOT03, set field to 2 positions