Consolidate advanced formula calculations

You can use this function to consolidate advanced formula calculations as a separate step in the consolidation process.

The advanced formula calculation accounts are defined in Maintain > Account Structure > Define.

For more information about defining advanced formula calculation accounts, see Define formulas for advanced formula calculation accounts.

When you run advanced formula calculations, you select the target period, target actuality, consolidation type, group and the advanced formula calculation job to be included. Note that you can select one or more periods. The source period is defined in the advanced formula calculation account definition.

Note that as the consolidation selection is made for Groups, you may get a company selection that differs from the companies selected in Jobs - Define. For example, if an advanced formula calculation Job included companies A, B, C, D and E and the selected group only includes A, B and D, the calculations will only be performed for these companies.

For more information about defining advanced formula calculation jobs, see Define jobs.

Note: If the target period or actuality are locked, the calculation can not be executed.

When executing the job, either as a separate step in Groups > Consolidate by Steps > Advanced Formula Calculations or as part of a consolidation with status, the result is booked on automatic journal type 38 if the source contribution version includes more than Base values. If not, it will be booked on automatic journal type BASE.

When the advanced formula calculation accounts have been executed, the consolidation log report will include the following information about the advanced formula calculation:

The start and stop time for the AFC calculations.
If there are any AFC accounts that were not executed in the job due to errors in the definition.