Income by Monetary Position - Mexico (CTBR273 - SIGACTB)

This report presents the Income Statement updated by the National Consumer Price Index (INPC).

Data are presented in columns, one for each month of the fiscal year. Both update factor and month factor can be viewed in this report.

Report details:

1. A userfunction must be created to get the income updated. 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]

Next

cArqTmp->(RestArea(aArea))

RestArea(aAreaAt)

Return()

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

     Enter the name of userfunction created in the field Formula.

This function accesses the temporary file generated by the report routine. Indexes available in array aFatorAtu (update factors) are applied to such values; the first element is INPC rate of the month, and second element is INPC rate of the month divided by the previous month rate, resulting in the average of rates.

• Column 1 must be informed in the management view in order to create the total row. In this case, the complete row is printed and total row values are summed.
• For the row of previous month monetary position, create an entity informing 2 in the column. To attribute values you can:

a) Create a function like the correction function.

b) Use function SALDO= and enter value of previous period.

The row Net Assets of the Month is automatically created when the report is finished. Thus, you do not have to include it in the management view.

Example of management view:

Procedures

1. To issue the report Monetary Position Income, click Parameters.
2. Configure them according to field help instructions.
3. Check configurations and confirm the report print.

See Also

• Standard configuration of reports
• Configuration of customized reports