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.
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()
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
See Also