The advanced formula calculations process

Advanced formula calculations are defined and processed with the following steps:
  • You activate the automatic journal for the calculation of advanced formula calculations in Maintain > Configuration > Automatic Journals > Define by selecting the Active for the EAFC code.
  • You define the advanced formula calculation account in Maintain > Account Structure > Define. Here you specify such things as the account type (statistical) and extended dimensions. In Calculation Type, you must select A (for AFC account). In the Edit Formula window, you specify the functions that should be part of the advanced formula calculation account formula. For more information, see Define formulas for advanced formula calculation accounts.
  • You create jobs, consisting of one or more advanced formula calculation accounts, in Maintain > Jobs > Define. You also need to define a default advanced formula calculation job for all consolidation types in Maintain > Jobs > Mapping Table. For more information, see Jobs and mapping tables.
  • You execute the calculation, either in a consolidation with status or by steps. Note that you can schedule an advanced formula calculation job as a batch job. For more information, see Consolidate advanced formula calculations.
Note: When performing consolidation with status, the advanced formula calculations are executed as a last step in the consolidation process.