Understanding the Auxiliary Ledger by Account Program

Whenever the fiscal authorities require that your company presents detailed records about your accounts, you can use JD Edwards EnterpriseOne for Mexico Localizations to generate a report that includes the information required.

The name of the report that you must submit to the government is Auxiliar de Cuentas y Subcuentas or Auxiliary Ledger by Account.

When you run the Auxiliary Ledger by Account program (R7009004), the system extracts detailed account information from the Account Master (F0901), Account Balances (F0902), Account Ledger (F0911) and the Chart of Accounts by Level (F7009001) tables, for the period and year defined in the processing options, and groups it up by account.

The output XML file includes in its heading the layout version, the taxpayer RFC number, and the month and year when the file is generated, the declaration type, and the order or request number.

In the body of the report, the system generates one record per account. The node consists of an overview section and a detailed section. In the account overview, the system displays the account number and description (as it appears in the Chart of Accounts by Level report) and the initial and ending balances for the selected period. In the account details section, the system lists the posted transactions that affect the account during the selected period. Every line describes a specific transaction, including the transaction date, the identification code of the accounting record, a description of the accounting record and the applicable debit and/or credit amounts.