Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • FIN PCoA ID: Used for the mapping of the account from the Operational CoA to the Planning CoA.

  • TB_Mult:Is the value use to transform the Accounting Trial Balance to a Management Trial Balance. The account movements in the General Ledger are changed from the accounting Debit (+) and Credit (-) signage used for the Accounting Trial Balance, to a signage that is used for management reporting. In the General Ledger, Assets, Liabilities and Equities are all reported as positive numbers. A negative weight in the ManagementTrial Balance rollup is added so that Total Assets = Total Liabilities + Equity = 0. When building the Balance Sheet rollup, you must include this negative weight for the proper reporting of the financial results in the General Ledger. For profit and loss accounts, Revenues are shown as positive numbers and Expenses are shown as negative numbers. This is opposite to the accounting sign but is more intuitive management reporting. The reversal of the sign from the Trail Balance to the Management Trial Balance is dependent on the Total Assets on the C3_TOTASSETS fixed account.

  • Statistical Account Flag: Is set on all metrics that are under the C3_STATISTIC Fixed Account.

  • Code and Description: The concatenation of the account code and the Description.

Managing Attributes

Click on the Manage Attributes button to open the Manage Attributes popup.

...

Group: Collect like attributes into a group.

Add a new attribute.

To create a new attribute, click on the New Attribute button. In the new line, define the name and the type of the attribute to be added. Click on the tick to create the attribute. Click on the cross to cancel. Other properties of the attribute can be edited, see below.

...

Edit an attribute.

For the attribute you want to change, click on edit. The Persistent, Caption and Group columns can now be changed. Click on OK to commit the change.

Delete an attribute.

For the attribute you want to delete, click on the vertical ellipse and select delete. You cannot delete Persistent attributes.