Advanced column properties

1. Click the General tab.

2. Apply style changes required for the column if it has to vary from the style specified in the Format Editor.

3. Enter the formula to calculate any derived value, if required.

4. Specify heading variables.

To place restrictions on the account balances to be used in a column, click the Filtering tab. For example, you might want to create a filter that will restrict the column to accounts from a particular division.

MAS users can create filters based on Main Code, Sub Code, Division, Prefix and Level.

Accounts users can create filters based on Branch, Division, Main Code, Sub Code and Level.

• To add a new filter, click

  

  and enter the details of your filter. For example, to create a filter that will use control accounts only, you would enter C in the Level field.
• To delete a filter, click

  

  .
• Select the Include credits checkbox to use credit account balances from the client’s ledger in the column.
• Select the Include debits checkbox to use debit account balances from the client’s ledger in the column.

To set a condition that will determine whether or not a column is displayed in a report, click the Condition tab.

From the Condition tab, enter a formula in the Formula field:

• The column will not be displayed if the result of the formula is false
• The column will be displayed, if the result of the formula is true
• The column will be displayed if the formula is invalid or blank.

For example, you might set the condition PeriodNumber(CurrentPeriod)=3 for a particular column. In this case, the column would only be displayed if the current period is period 3.

The formula can be entered with or without a leading equal sign. For example, =PeriodNumber(CurrentPeriod)=3 and PeriodNumber(Current Period)=3 are both valid formulas that will return the same result.

The formula cannot contain references to cells, driver fields (e.g. AMOUNT), heading variables (e.g. %HEADING1%) or the names of other columns within the column template.

You can check the syntax of the formula in the Formula field by clicking

To create a column that displays values from a different ledger, click the Ledger tab.

The drop-down list in the Ledger column contains a list of available ledgers.

1.  Select the ledger from which you want the column to retrieve Chart Map balances and Database Map values.

2. To display the combined values from more than one ledger, add a new item to the list by clicking

   

   . To remove an item from the list, click

   

   .
   
   

   The <Current Ledger> item in the drop-down list refers to the ledger(s) specified in the Current Ledger Configuration dialog (accessed via Tools > Current Ledger Configuration).

To specify a name for the ledger in the Formula field, enter a name in the Name column. By default, ledgers will be given the names L1, L2, L3 and so on. These names can be edited, if required.

1. Launch the Ledger Properties dialog by clicking

   

   .
2. Specify the Year, Period Start, Period End and Balance Type for the account balances to be retrieved from the selected ledger in the Ledger Properties dialog.
3. Click OK to save your changes.

The settings in the Ledger Properties dialog will default from the settings in the corresponding fields in the Column Definition section of the main Column Template Editor screen.

The Formula field will be enabled when there are two or more items in the Ledger list.

Each ledger in the Ledger list is represented in the formula by the value that has been specified for it in the Name column.

A formula will be automatically generated to add the ledger values together (e.g., L1+L2). This formula can be edited, if required, to achieve a different result (e.g., (L1-L2)/L1).