Maintaining the Chart of Account Attributes

Attributes hold additional information about the elements in the CoA dimension. Some attributes are system attributes and sometimes populated or calculated by Apliqo FPM. Additional attributes can be created as needed.

System and standard attributes

• FIN PCoA ID: Will contain the mapping of the operational to the planning CoA equivalent. This will be explained in the chapter about planning setup.

• TB_Mult: The Trial Balance Multiplicator will be set on all leaf accounts by the system.

• BS_Indicator: The Balance Sheet Indicator will be set on all leaf accounts that are Balance Sheet accounts, this is mainly used to determine the correct FX rate (average vs. closing).

• Statistical Account Flag: Will be set on all leaf accounts that are statistical accounts (descendants of C3_STATISTIC) by the system.

• No FX: A standard attribute that can be maintained manually to turn of the currency conversion for an account (usually used for statistic accounts like units).

• No Scaling: A standard attribute that can be maintained manually to turn of scaling, i.e. even when other values in a report will be displayed as thousands or millions accounts with this flag we be displayed with their actual value.

• Description: The main description / name of an account, maintained by the user on screen or loaded from a source.

• Code and Description: A system calculated attribute that will concatenate the account code and the Description and cannot be set manually.

Managing attributes

To manage the operational CoA attributes, open the "Manage Attributes" dialogue. Attributes can also be created automatically when bulk loading accounts.

• The principal name cannot be changed, you will have to delete and create a new attribute

• The type can either be String (S), Alias (A) or Numeric (N)

• When an attribute is set to "Persistent" it is intended to be changed manually only, i.e. load processes will not change this attribute

• "Show Column" will show this attribute in the main screen.

• "Caption" is what will be shown in the column headers of the main screen (a friendly name)

• "Group" is for information purposes and will allow you to show and hide all attributes of a group more easily in the main screen

• To create a new attribute use the "New Attribute" button and define the name and type of the attribute, after being created you can change the other attribute properties by editing it.

• To delete an attribute, use the "Delete Attribute" button, select the attribute, and click delete . System attributes cannot be deleted.

Open

Update flag attributes

There is a process to update some of the "flag" attributes on demand and performs some additional actions at the same time. Open the process dialogue by clicking "Update Flags" in the toolbar.

• Override (Yes by default, recommended): Will overwrite existing attribute values for Statistical Account Flag, BS Indicator, TB Multiplicator as well as Mapping Level and Plan Map ID if the next option is turned on.

• Mapping Flags (Yes by default, recommended): Will include plan mapping attributes in the update process.

• Add Dummy Accounts (No by default, only turn on if needed): Additional option that will automatically create a dummy leaf element under any consolidated elements that do not have children, this will allow you to for instance enter plan data when there is no accounts for actuals (yet).

• Update Hierarchies (Yes by default, recommended): Will update the Apliqo FPM technical rollups.

Please note that this process is automatically executed before you perform a dimension synchronization to ensure that all system attributes are populated correctly. You do only have to run this process manually if you want to verify the attribute values before synchronizing the dimension.