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.

...

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

...

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.

...

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