Automatic Calculations > Automatic Counter Entries (ACE)

It is possible to have automatic counter entries created for transactions entered to the system. The automatic counter entries are created based on automatic counter entry definitions.

Automatic counter entries are shown on an input template if the template contains an input type column (for more information, refer to Clausion Financial Performance Management Input and Report Template Parameters).

Cells that contain automatic counter entries are marked with the icon and cannot be modified. A comment of the following format is displayed for these rows: definition ID: unit ID->counter unit ID. For example: ACE00003:1030->5070

The automatic counter entry value is created by multiplying the value by -1 and converting the resulting sum to the currency of the counter unit.

When there are dependencies between type 1 and 2 document series and there is an automatic counter entry definition for type 2 document series, automatic entries due to document series dependencies and automatic counter entries are created as follows:

•When the counter account is internal, automatic counter entries are created to the internal (counter) account for the counter unit and automatic entries due to document series dependencies to the internal accounts of both units (input account for input unit and counter account for counter unit).

•When the counter account is external, automatic counter entries are created to the external (counter) account for the counter unit and automatic entries due to document series dependencies to the internal account of the input unit.

When there is an automatic counter entry definition for type 1 document series and it has an internal account set as the account and an external account as the counter account, automatic entries are created for the unit as follows when type 2 document series data is entered to the internal account:

•Type 1 document series automatic entries due to series dependency are generated to the internal account.

•Type 1 document series automatic counter entries are generated to the external account. The source value in this case is the automatic entry due to a document series dependency.

Valid definition:

Table 12: Counter entry to the same account from different accounts in different years

ID	Account	Counter account	Start period	End period
1	20000	300000	2005-01	2005-02
2	100000	300000	2006-01	2006-12

Invalid definition:

Table 13: Counter entry to the same account from different accounts within the same year

ID	Account	Counter account	Start period	End period
1	20000	300000	2005-01	2005-02
2	100000	300000	2005-03	2005-12

Invalid definition:

Table 14: Counter entry to the same account from different accounts within overlapping years

ID	Account	Counter account	Start period	End period
1	20000	300000	2005-01	2007-12
2	100000	300000	2006-01	2006-12

Invalid definition: The following kinds of definitions are not allowed for type 1 document series when there are dependencies between series 2 and series 1.

Table 15: Internal counter account for type 1 document series when the document series is linked to type 2 document series

ID	Account	Counter account	Document series
1	internal	internal	type 1 (for example, 10000)
2	external	internal	type 1 (for example, 10000)

Note! If previously described definitions are created while there is no dependency between type 2 and type 1 document series, the definition is valid. If a dependency is then added, the definition is shown as invalid in Automatic Counter Entries (ACE). If the definition is not deleted or corrected, an automatic counter entry for type 1 is created.

Note! The users' unit rights for the counter unit are not checked. This means that automatic entries due to document series dependencies and automatic counter entries are also created for counter units for which the user who enters type 2 document series data has no rights.