Update
Procedures
| 1. |
Select the desired provision register |
| 2. |
In Related Features, click Update. |
| 3. |
Check the provision control data |
| 4. |
In Related Features, click Confirm them. |
| 5. |
The status is changed to Updated. |
The provision control transactions are generated for checking. The transactions of the period, their occurrences and calculation methods are:
| • |
01 - Distribution of the Planned Provision Amount: Transaction which represents the total provision current amount distributed by the criteria indicated in the calculation type field (demand curve) |
Distribution by demand curve is calculated using the following steps:
| • |
Determine the start and the end of the demand curve. |
The start of the curve is the month indicated in the Provision Start field.
The end of the curve is the month of the later end date of the register of provision items.
| • |
Determine the distribution index: |
The distribution index is calculated by the following formula:
Distribution Index = Curve of the current period / Sum of the curve amounts from start to end of the Provision.
| • |
Calculate the distribution amount of the month |
The distribution amount is the current total provision amount times the Distribution Index of the Period
| • |
02 - Provision: Transaction which represents the recognition of the provision of the period. This occurrence is calculated as follows: |
Provision = a * ( b ^ c ) where:
a = Distribution Amount of the Period
b= APV Index on Daily Basis (considering the Business Year, i.e., a 360-day year)
c= number of days between the start of provision and the current period (considering a 30-day month)
| • |
03 - Execution: Transaction which represents the executions of the period's provision. It is the amount indicated in the carry out tab of the Provision register. |
This transaction is only saved if the provision control has execution assets associated with it.
| • |
04 - Complement: Transaction which represents the complement of the provision of the period. It occurs when the execution of the period is higher than the planned provision of the period. |
This transaction is only saved if the provision control has execution assets associated to it and the sum of these executions is higher than the provision amount planned for the period (month).
| • |
05 - Rollback: Transaction which represents the rollback of the provision of the period. It occurs when the execution of the period is lower than the planned provision of the period. |
This transaction is only saved if the provision control has execution assets associated to it and the sum of these executions is lower than the provision amount planned for the period (month).
| • |
06 - APV: Transaction which represents the adjustment to current value of the provision of the period. This occurrence is calculated as follows: |
| • |
a = Distribution Amount: Transactions in the period with occurrence \"01-Distribution of the Planned Provision Amount\" |
| • |
b = Planning Present Amount: If the period for calculation is the same as a planned period, this is the present value of the stage registered in the provision control. Otherwise it is zero. |
| • |
c = Deducted Balance: calculated as follows: |
| • |
c = c(previous period) + a - b |
| • |
e = APV Correction Index of the Period: given by the formula: e = x ^ d where: |
| • |
x= APV Index on Daily Basis (considering the Business Year, i.e., a 360-day year) |
| • |
d= number of days between the start of provision and the current period (considering a 30-day month) |
| • |
With these variables, we get f = Updated Balance = c * e |
Calculating the following variables as well:
| • |
g= Start Balance: end balance of the previous period |
| • |
h=Provision of the Period: Transactions in with occurrence \"02 - Provision\" in the period. |
| • |
i = Execution of the Period: Transactions in with occurrence \"03 - Execution\" in the period. |
| • |
j = Complement of the Period: Transaction in with occurrence \"04 - Complement\" in the period. |
| • |
k =Rollback of the Period: Transaction in with occurrence \"05 - Rollback\" in the period. |
With these variables we have l = APV of the Period by the formula = f – ( g + h – i + j – k )
m = End Balance: given by the formula = m = g + h – i + j – k + l
0d48de9d-e3f5-4738-b5a5-f0309e73cf9fImportant: 11/12/13/14/15/16 – Short Term Transfer: For provision control, the MV_ATFPROV parameter was created to determine the number of days regarding the end of provision so as to determine the short-term and long-term provision.
| • |
Transactions with period before the short-term date are classified as long-term (the FNW_PRAZO field is set to 1). |
| • |
Transactions with period before the short-term date are classified as short-term (the FNW_PRAZO field is set to 2). |
|
On the short-term date the transactions of short-term transfer are generated:
| • |
11 = Transfer Distributions: Sum of the transactions of occurrence 01 until the date. |
| • |
12 = Transfer Provision: Sum of the transactions of occurrence 02 until the date. |
| • |
13 = Transfer Execution: Sum of the transactions of occurrence 03 until the date. |
| • |
14 = Transfer Complement: Sum of the transactions of occurrence 04 until the date. |
| • |
15 = Transfer Rollback: Sum of the transactions of occurrence 05 until the date. |
| • |
16 = Transfer APV: Sum of the transactions of occurrence 06 until the date. |