Mexican Electronic Accounting Data Extraction (lpmex0400m000)

Utilizzare questa sessione per create the CSV files and query.xml files used for tax reporting in Mexico.

In Mexico, a taxpayers must submit La Contabilidad Electrónica (electronic accounting) through the Tax Mailbox portal provided by the Mexican Fiscal Authority. For this purpose LN is integrated with Local.ly eAccounting (LEA). The Local.ly eAccounting can be used to create the (final) SAT files to be sent. LN generates the different files in csv format, which must be placed outside of the ERP system. LN also generates the query mapping XML file (querys.xml), which provides the link between the file/fields in the ERP database (in the csv file) and the eAccounting database. The CSV file is generated for the following:

  • Chart of Accounts
  • Trial Balance
  • Journals

Informazioni sui campi

Chart of Accounts

Se questa casella di controllo è selezionata, LnChartOfAccounts.csv file is generated.

Trial Balance

Se questa casella di controllo è selezionata, LnTrialBalance.csv file is generated.

GL Journal Transactions

Se questa casella di controllo è selezionata, LnJournalTransactions.csv file is generated.

Società finanziaria

The code of the financial company.

Description

La descrizione o il nome del codice.

Fiscal Year

The code of the fiscal Year.

Fiscal Period

The code of the period.

Note: 

This field is disabled if only Chart of Accounts check box is selected.

Account Type

The account type for which the data must be extracted.

Accounting Scheme

The code of the accounting scheme.

Valori consentiti

Statutario

Conto contabile utilizzato per scopi contabili ufficiali in base a specifici requisiti legali.

Complementare

Conto contabile contenente gli importi complementari rispetto agli importi inclusi nei conti statutari. È possibile, ad esempio, collegare un conto statutario e un conto complementare a un conto padre. Se il report di gestione viene stampato in base ai conti padre, Infor LN aggiunge gli importi del conto complementare all'importo dei conti statutari.

Entrambi
Ledger Account

I campi Da e A consentono di definire un intervallo di ledger accounts.

Statutory Sublevel

I campi Da e A consentono di definire un intervallo di sublevels.

Complementary Sublevel

I campi Da e A consentono di definire un intervallo di complementary sublevels.

Document

I campi Da e A consentono di definire un intervallo di transaction types.

Note: 

This field is disabled if the Chart of Accounts or Trial Balance check box is selected.

Document Number

The document number of the transaction type.

Note: 

This field is disabled if the Chart of Accounts or Trial Balance check box is selected.

Home Currency

The code of the home currency.

Note: 

This field is disabled if only Chart of Accounts check box is selected.

Separator

The character to be used as column separator in the output file.

Percorso esportazione

The location where the files are exported and saved.

Valori consentiti

Sistema locale
Server
Non applicabile
Directory esportazione

The directory where the files are exported and saved.