Update (ATFA490 - SIGAATF)

Procedures

1. Select the desired provision record.
2. In Related Actions, click Update.
3. Check the provision control data
4. In Related Actions, click Confirm.
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: a transaction that 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 for 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: a transaction that represents the executions of the period's provision. It is the amount indicated in the carry-out tab of the Provision record.

This transaction is only saved if the provision control has execution assets associated with it.

• 04 – Complement: a transaction that 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 with it, and the sum of these executions is higher than the provision amount planned for the period (month).

• 05 – Rollback: a transaction that 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 with it and the sum of these executions is lower than the provision amount planned for the period (month).

• 06 – APV: a transaction that represents the adjustment to the current value of the provision of the period. This occurrence is calculated as follows:
• Transactions in the period with occurrence "01-Distribution of the Planned Provision Amount"
• b = Current Planning 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 following formula: e = x ^ d, where:
• x= APV Rate 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 = Initial Balance: the final 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

Prerequisites to generate transactions with occurrence: 06 - APV representing the present value adjustment of the provision of the period.
-APV Financial Index Registration - in the SIGAFIN module (FINA017):

-Update Index Registration - in the SIGAFIN module (FINA018):

-Calculated Index Registration - Curve (ATFA005):

-Calculated Index Update - Curve (ATFA006):

-Include Provision Control Record (ATFA490):

-Provision Items (Grid):

-Spreadsheet generated when confirming Other Actions/Update:

• c = Deducted Balance:  calculated as follows:
• c = c(previous period) + a - b
• where A = Distribution Value (Occurrence 01)
•           b = Present Planning Value:
• 1st Row:
• Discounted Balance = Discounted balance from the previous period + a - b
• Discounted Balance =           0                                                   + 468961.56 - 495049.5  = -26087.94
• 2a.Linha:
• Discounted Balance =           -26087.94                                                   + 468961.56 - 490148.02  = -47274.4

• f = Updated Balance = c * e

  ©	(e)	(f)
  -26087.94	1.01	-26348.8
  -47274.4	1.0201	-48224.6
  -63607.91	1.030301	-65535.3

  
  
  

• g = Initial Balance: the final balance of the previous period

  (f)	(g)
  -26348.8	0
  -48224.6	-26348.8
  -65535.3	-48224.6

• 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.

Period AVP is only calculated when field ACM TRANS.<> 1

• l = Period AVP using formula = f – ( g + h – i + j – k )

• 1st Row:  It is zero because field ACM TRANS.= 1, thus l = 0
• 2a.Linha:
• l = -48224.6 - ( -26348.8 + 478387.69 - 0 + 0 - 500000 ) = -263.49

On the short-term date the transactions of short-term transfer are generated:

• 11 = Distribution Transfer: Sum of the transactions of occurrence 01 until the date.
• 12 = Provision Transfer: Sum of the transactions of occurrence 02 until the date.
• 13 = Execution Transfer: Sum of the transactions of occurrence 03 until the date.
• 14 = Complement Transfer: Sum of the transactions of occurrence 04 until the date.
• 15 = Rollback Transfer: Sum of the transactions of occurrence 05 until the date.
• 16 = APV Transfer: Sum of the transactions of occurrence 06 until the date.