Electronic Report for Accounting Identities

This document describes the process for running 'Accounting Identity. Create Electronic Report' (AAS640) in order to create the electronic report for charts of account requested by the Mexican Tax Agency (SAT).

Background

The Mexican Tax Agency (SAT) requests companies to start submitting electronic accounting information in XML format.

One of the electronic reports is the "Chart of accounts with SAT qualifier for equivalences." A full declaration is mandatory in the beginning of 2015, and afterwards a monthly one is requested for any updates, such as changed or new accounts.

Limitations

No printout is created in (AAS640).

Currently only the Mexican electronic chart of account (MX-SAT) is available as an output file format with the following limitations:

  • Accounting dimension 1 must store the legal chart of account.
  • Account group levels 2-4 must be defined as accounting dimension 1 in 'Accounting Identity. Open' (CRS630) in order to be included in the electronic report.
  • A changed accounting ID is identified by the last update date for the record (i.e., option 2 for record in 9 (CRS630) without changes will be considered as a change of account).

Before you start

The following description provides an overview of the setup for the MX-SAT format required for the FBM.

For a detailed description, see the user guide FBM for Electronic Chart of Accounts Declaration.

  • Account groups must be defined in 'Account Group. Open' (CRS633).
  • Accounting identities for dimension 1 must be defined in 'Accounting Identity. Open' (CRS630).
  • Description per language must be defined in 'Accounting ID. Enter Names/Language' (CRS632).
  • An indication of the debit/credit nature must be defined in 'Account Translation Scenario. Open' (GLS030).
  • The RCF ('Registro Federal del Contribuyentes') number must be entered in the field 'VAT registration number' of the division (MNS100/G).
  • The format 'MX-SAT' must be set up for document number 542 in 'Standard Document. Connect Media Control Object' (CRS945).

Follow These Steps

  1. Start 'Accounting Identity. Create Electronic Report' (AAS640).

  2. Select option 1=Create in (AAS640/B1).

  3. In (AAS640/E), select the 'Output file format', 'Report type' to be created (1-Full declaration or 2-Only new/changed) and enter the 'Reporting date'. Click Enter/Next.

    • For the format 'MX-SAT' the report date indicates the year and month in the electronic report file.

  4. If a warning message is shown that a report with the same selection already exists:

    • Click OK to continue with the current selection.
    • Click Cancel to go back and change the selection.

  5. Enter the additional selection fields now shown in (AAS640/E). Click Enter/Next.

    • For the format 'MX-SAT' the accounting dimension 1 must be selected.
    • If report type 2 (Only new/changed) was selected, the date range for new and changed records must be entered.

  6. After the status of the report is raised to 80, the report is sent to the Infor Enterprise Collaborator for further processing.

  7. After the status of the report is raised to 90, the creation of the report is ready.

    If the process is abnormally interrupted, the status can be changed to 99 using related option 7='Change status' and afterwards the report can be deleted if requested.

Outcome

  • The report in (AAS640/B1) will have status 80, which will initiate the Infor Enterprise Collaborator to process the Financial Business Message (FBM).
  • The report in (AAS640/B1) will have status 90 when the Infor Enterprise Collaborator has finished creating the Financial Business Message (FBM).

Settings Descriptions

The following selections must be made in (AAS640/E). When applicable, comments for the MX-SAT format are provided.

Program ID Field Heading Description
(AAS640/E) Output file format

The field indicates the format to be used when the electronic report is created and will also control the selection in (AAS640/E - Acc Identity. Create Electronic Report) required for the format.

Alternatives

MX-SAT = Electronic Chart of Account – SAT (Mexico)
(AAS640/E) Report type

The field indicates the type of electronic report that must be created.

Alternatives

1 = Full declaration including all accounting IDs selected.

2 = Only new and changed accounting IDs will be included.

When selecting report type 2, the create/change date from/to will be displayed and must be entered.
(AAS640/E) Reporting date

The field indicates the date for the electronic reporting.

For output file format 'MX-SAT', the report date will be used to indicate the year and month for the electronic report as required by the format.
Related topics