CFP data processing - Dividends calculation

This operation activates the calculation of the dividends to be distributed to recipient entities as remuneration for the capital invested.

The events created following the dividends calculation have the origin: CFP_DIVIDENDS – CFP - Dividends.

In date order, the system performs the following operations:

calculates the dividends:
recovers the formula defined for the dividend rule associated with the entity in the execution plan
recovers, from the table of balances for the scenario prior to the selected scenario, period 12, the value attributed to the accounts indicated in the formula
applies the formula to the amount of the aforementioned accounts to obtain the value of the dividend
books, on the DISTRIBUTOR entity:
the calculated dividend, as follows:
account equal to the “dividend distribution reserve account” specified in the dividend distribution rule (debit)
account equal to the “financial debt account” specified in the dividend distribution rule (credit)
event date (i.e. the date on which the dividends are distributed) equal to the end date of the selected scenario/period and the “declaration period” specified in the dividend distribution rule
custom dimensions equal to the elements of the default custom dimensions specified for the entity
currency equal to the entity currency
currency amount equal to the calculated value
any down payments indicated in the dividend distribution table, as follows:
account equal to the “down payments distribution reserve account” specified in the dividend distribution rule (debit)
account equal to the “financial debt account” specified in the dividend distribution rule (credit)
event date equal to the “distribution date” indicated in the dividend distribution table
custom dimensions equal to the elements of the default custom dimensions specified for the entity
currency equal to the entity currency
currency amount equal to the value indicated in the dividend distribution table
any additional dividends indicated in the dividend distribution table, as follows:
account equal to the “dividend distribution reserve account” specified in the dividend distribution rule (debit)
account equal to the “financial debt account” specified in the dividend distribution rule (credit)
event date equal to the “distribution date” indicated in the dividend distribution table
custom dimensions equal to the elements of the default custom dimensions specified for the entity
currency equal to the entity currency
currency amount equal to the value indicated in the dividend distribution table
the relative payments:
account equal to the “financial debt account” specified in the dividend distribution rule (debit)
account equal to the “bank account” specified in the dividend distribution rule (credit)
custom dimensions equal to the elements of the default custom dimensions specified for the entity
currency equal to the entity currency

The event date varies depending on what is being distributed; specifically:

for the registration of the dividend payment, it is equal to the distribution date, to which the number of payment days and months specified in the dividend distribution rule are added
for the registration of interim and additional dividends it is the payment date specified in the dividend distribution table
books, on the RECIPIENT entity:
the calculated dividend, as follows:
account equal to the “dividends received account” specified in the dividend distribution rule (credit)
account equal to the “financial credit account” specified in the dividend distribution rule (debit)
event date equal to the end date of the selected scenario/period and the “deliberation period” specified in the dividend distribution rule
custom dimensions equal to the elements of the default custom dimensions specified for the entity
currency equal to the entity currency
currency amount equal to the calculated value net of any down payments already collected
the relative collection, as follows:
account equal to the “financial credit account” specified in the dividend distribution rule (credit)
account equal to the “bank account” specified in the dividend distribution rule (debit)
custom dimensions equal to the elements of the default custom dimensions specified for the entity
currency equal to the entity currency
currency amount equal to the calculated value net of any down payments already collected
event date equal to the distribution date, to which the number of payment days and months specified in the dividend distribution rule are added

if the calculated dividend value is <= 0 and there are no down payments, the system does not generate the dividend;
if the calculated dividend value is <= 0 and there are down payments, the system generates the negative dividend;
if the calculated dividend value is > 0 but the distributed down payment is greater than the value of the down payment, a negative dividend value is generated.
the value to be distributed to the individual recipient entities is calculated on the basis of the % ownership indicated in the group structure.