Configuring Financial Reports for Mexico
To use the Balance para México (Mexico Balance Sheet), the Estado de Ingresos y Egresos para México (Mexico Income Statement), and the Balance de Comprobación para México (Mexico Trial Balance), an additional configuration step is required when installing the Mexico Localization SuiteApp or each time the SuiteApp is updated.
To configure the Mexico Balance Sheet report:
-
Go to Reports > Mexico Localization > Mexico Balance Sheet > Customize
-
Select Edit Columns in the Report Builder.
-
In the Report Preview pane, do the following:
-
Select the Importe Inicial (Initial Amount) column.
-
Ensure that the Cumulative Value box is checked.
-
Then, from the Alternate Period Range list, select Last Period.
-
-
Select the Importe (Débito) (Debit) column.
-
Then, from the Alternate Period Range Type list, select Relative to report date.
-
From the Alternate Period Range list, select This Period.
-
-
Select the Importe (Crédito) (Credit) column.
-
Then, from the Alternate Period Range Type list, select Relative to report date.
-
From the Alternate Period Range list, select This Period.
-
-
-
Click Save.
To configure the Mexico Income Statement report:
-
Go to Reports > Mexico Localization > Mexico Income Statement> Customize.
-
Select Edit Columns in the Report Builder.
-
In the Report Preview pane, select the Importe Inicial (Initial Amount) column.
-
Then, from the Alternate Period Range list, select Balance Forward.
-
-
Click Save.
To configure the Mexico Trial Balance report:
-
Go to Reports > Mexico Localization > Mexico Trial Balance > Customize.
-
Select Edit Columns in the Report Builder.
-
In the Report Preview pane, select the Débito/Cédito (Debit/Credit) column.
-
Then, from the Alternate Period Range Type list, select Relative to report date.
-
From the Alternate Period Range list, select This Period.
-
-
Click Save.
This table shows the parameters required to correctly generate financial reports for Mexico. Make sure your reports are configured this way before running them.
|
Report |
Column |
Alternate Period Range Type |
Cumulative Value |
Alternate Period Range |
|---|---|---|---|---|
|
Balance para México (Mexico Balance Sheet) |
Importe Inicial |
Relative to report date |
Yes |
Last Period |
|
|
Importe (débito) |
Relative to report date |
— |
This Period |
|
|
Importe (crédito) |
Relative to report date |
— |
This Period |
|
|
Importe |
None |
— |
— |
|
Estado de Ingresos y Egresos para México (Mexico Income Statement) |
Importe Inicial |
Relative to report date |
— |
Balance Forward |
|
|
Importe (débito) |
None |
— |
— |
|
|
Importe (crédito) |
None |
— |
— |
|
|
Importe |
None |
— |
— |
|
Balance de Comprobación para México (Mexico Trial Balance) |
Débito/Cédito |
Relative to report date |
— |
This Period |
|
|
Importe |
None |
— |
— |