Third Document Report - Mexico (CTBR272 - SIGACTB)

Importante

Esta funcionalidad ya no se tiene en el sistema.

Updated account balances are presented in this report, based on National Consumer Price Index (INPC), in the Income Statement.

Data of each account are presented in columns, one for each month, with updated balances.

Report details:

1. A userfunction must be created in order to get balances of ledger accounts adjusted for INPC.

See the following example.

Example of userfunction to update amounts of the Income Statement.

Local aArea:={}

Local nx:=1

Local aAreaAt:=GetArea()

aArea:= cArqTmp->(GetArea())

DbSelectArea(cArqTmp)

DbSeek(Conta) // Enter here account to be updated.

For nX:= 1 to Len(aFatorAtu)

cCampo:= "COLUNA"+Alltrim(str(nX))

cCampo := cCampo * aFatorAtu[nx][2]

RestArea(aAreaAt)

Return()

The array aFatorAtu (update factors) of this userfunction contains, in the first element, the INPC month rate; the second one contains the INPC month rate divided by the previous month rate, resulting in the INPC average of each month.

2. You must also create a Management View to update amounts monthly.

Enter the name of userfunction created in the field Formula of the accounting entity.

3. After the report "3er document" is processed, INPC indexes returned by the userfunction are applied and balances of ledger accounts in the Income Statement are updated.

Note:

Considering that a fiscal year goes from the 1st to the 12th month of the year:

In the report "3er document," with update of balances based on INPC in the Income Statement, months are presented considering the base date and also the opened fiscal year.

If the system base date is after the fiscal year final date, columns of all months of such year are presented. However, if the system base date if before the fiscal year final date, the report presents only columns up to the base date month.

Therefore, considering that base date is the 2nd month of the year, when you print this report, all income columns are presented up to the 12th month (final date of the fiscal year).

However, if all entries referring to the fiscal year 2006 were made and base date is the 8th month of the year, only columns up to the base date month are displayed.

Example of management view:

Order	Row	Management Entity	Higher Entity	Description	Normal	Class	Initial account	Final account	Identification	Formula	RdMake
0000000010	001	ING	VLHIST	INCOME	Debit	A	21001	21001	Addition
0000000020	001	EXPENSES	VLHIST	EXPENSES	Credit	A	21101	21101	Subtraction
0000000030	001	REP	VLHIST	REPOMO	Credit	A	10001	10001	Subtraction
0000000040	001	VLHIST	EFMES	HISTORY VALUE	Debit	S			Subtraction
0000000050	001	LINEA							Separator
0000000060	001	INGA	VLACT	UPDATED INCOMES	Debit	A	21001	21001	Sum	Texto=U_F272ATU("ING")	Function to update values (enter origin account)
0000000070	001	GASTOSA	VLACT	UPDATED EXPENSES	Credit	A	21101	21101	Subtraction	TEXTO=U_F272ATU ("EXPENSES")	Function to update values (enter origin account)
0000000080	001	REPA	VLACT	UPDATED REPOMO	Credit	A	10001	1001	Subtraction	TEXTO=U_F272ATU ("REP")	Function to update values (enter origin account)
0000000090	001	VLACT	EFMES	Updated value	Debit	S			Grand total	TEXTO=U_F272ATU ("VLHIST")	Function to update values (enter origin account)
0000000100	001	EFMES		EFFECT. OF THE MONTH	Debit	S			Grand total	TEXTO=U_F272ATU ("VLHIST", "VLACT")

Procedures

To print the report "3rd Document," click Parameters.
Configure them according to field help instructions.
Check configurations and confirm the report print.

See Also

Standard configuration of reports
Configuration of customized reports

Páginas filhas

Third Document Report - Mexico (CTBR272 - SIGACTB)

Example of userfunction to update amounts of the Income Statement.