Define Automatic Journals - the Calculation Methods Tab

On this tab you can see the calculation methods, which are the product of an amount type and a rate type. A combination of calculation methods forms a rule. Each automatic journal uses a rule.

There are a number of pre-defined calculation methods that are used by the pre-defined automatic journals. These have the code Cx, where x denotes a figure. You cannot modify or remove these calculation methods, but you can copy them.

The GM indicator in an automatic journal determines the value to be calculated.

  • Amount type is the value that will be calculated if the GM Indicator is blank.
  • Amount type is multiplied by rate type if you have defined the GM Indicator with "G".
  • Amount type is multiplied by (1-rate type) if you have defined the GM Indicator with "M".

For more information about amount type codes, see Amount Type Codes.

For more information about rate type codes, see Rate Type Codes.

Procedure

  1. On the Maintain menu, click Configuration/Automatic Journals/Define. The Define Automatic Journals window opens.
  2. On the Calculation Methods tab, click the New button. All fields are cleared for entry.
  3. In the Code text box, enter the new calculation method code. In the Name text box, enter a description of what the method performs.
  4. In the Amount Type drop down list box, select the relevant amount type code to be multiplied by the rate type.

    Depending on the contents of the GM Indicator column in the automatic journal control table, the value is calculated differently. The GM Indicator can be: Blank - The amount type itself is used. G - The amount type is multiplied by the rate type. M - The amount type is multiplied by (1-rate type).

  5. In the Rate Type drop down list box, select the relevant rate type code to multiply the amount by if a GM indicator is defined for the automatic journal.
  6. Click Save.

Results

  • Amount types and rate types are predefined in the system.
  • The calculation methods used by the predefined automatic journals are also regarded as predefined and cannot be changed or deleted. The predefined calculation methods begin with "C".