Document Series

All input data in Clausion must belong to one document series. In other words, document series are like one mandatory dimension to which each data must be allocated. Document series are used for example for keeping data relating to different origin separate and to ensure audit trail from source data to the reported totals after manual adjustments.

Document series are managed with a custom template. Task for this is included in the default admin user interface settings.

For each document series the following is needed:

• Code for the document series

• The minimum and maximum document number limits for the document series

• The document series type

Document series type defines which kind of calculations are executed or may be defined for the input data relating to the document series. The possible types are:

• 1 = Basic unit input

• 2 = Internal transactions, input

• 23 = Internal transactions, automatic adjustment for proportional consolidation

• 3 = Automatic minority (non-controlling interest) entries

• 31 = Automatic proportional consolidation entries

• 4 = Elimination of inventories internal margin

• 6 = Eliminations with basic transaction data affecting future periods

• 7 = Other entries

All Clausion installations include the following default document series, which are listed in the following table.

Default document series

For all the document series included in Clausion Package environments, refer to Clausion Package-specific documentation.

You can delete document series in Document Series Management. First, delete value from the Type column and save the template. If you try to delete a document series containing data, you get a validation message. The deletion of document series deletes also dependent data from Series Dependencies and Name of Document Series sheets. Any Automatic Counter Entry (ACE) rules created for the series are also deleted. After you have deleted a particular document series, restart the Desktop Client to get the document series deleted from ACE Management. Please note that related ACE rules are deleted as well and make sure you document the ACE rules (save to Excel) before deleting voucher series.

Document Series Dependencies

Document series dependencies can be created between document series types:

• 2 and 1: This dependency has an effect on internal accounts by creating a non-editable entry to type 1 series when a type 2 series entry to internal account is saved.

• 2 and 23: This dependency has an effect on internal transactions where either one or both unit and counter unit are set as proportionally consolidated (Consolidation method = Proportional consolidation) by creating adjustment entry for amount not to be eliminated to series type 23.

• 1 and 3: This dependency has an effect on the accounts included in NCI calculation rules according to which entries are created to type 3 series when type 1 series entries are saved, and the unit is consolidated by the full consolidation method and consolidation percentage is less than 100%.

• 1 and 31: This dependency has an effect on all the accounts. The PROC calculation rules set target accounts for accounts, that following consolidation by opening balance consolidation percentages, and for which separate target account for change due to change in the percentage must be used. The entries are created relating to only the units, that follow proportional consolidation method. If dependency between type 1 and type 31 does not exist, these entries are created to series type 3, if that dependency does exist.

Restarting the Clausion client after saving custom template for the series and dependencies is not necessary unless you added a new document series.

The custom template does not check for wrong definitions. Dependencies with wrong types can be created. However, if only the input series or the target series is given, no dependency is saved. An error is also shown if the input series and/or the target series does not exist.

Removing document series dependencies: To remove an existing dependency between document series, delete the whole row from the Series Dependencies worksheet using the DELETE or BACKSPACE key. Removing the values from the cells also deletes the dependency. If automatic entries due to dependencies have already been generated, the data is not deleted when the dependency related to them is deleted.

Note that automatic entries due to a document series dependency between type 2 and type 1series are shown as manual entries on input and report templates. This means that in input and drill-down templates it is not necessary to define an input type for definition or data columns. If it is defined, the entries will be shown in the manual entry rows/columns.

All Clausion installations include the following document series dependencies by default:

Default document series dependencies

For the dependencies included in Clausion Package environments, refer to Clausion Package-specific documentation.