Column Maintenance

---

Use this form to specify the report's column headings. You must define your own column format to use with each financial report, older pre-defined formats are no longer supported. On Report Maintenance if you tick Transpose this can become the row format and go down the page rather than columns across the page.

User Defined Formats

Code

Type a code which indicates what columns are in this format.

Description

Type a description which fully explains the columns in this format.

In Development

Select this option to enable you to edit a column format used on published reports, existing published reports are deleted. If you don't want to delete existing published reports, then copy the format and create a new one.

Active

Select this option to use this column format with financial reports. Deselect this option to prevent people using this format with new reports.

Select the User Defined Columns option to display the user-defined columns on the form.

Column No

Greentree will increment the column numbers by 10, enabling room to insert more columns in the future. You can change the column number to reposition or insert new columns.

Column Type

Select a pre-defined column type.

All values and calculations apply to the accounts selected in your row format. So this might be a single general ledger account for a total value of all accounts assigned to a tree branch.

• Actual Value LC - Actual value in local (system) currency for the report period
• Actual Value FC - Actual value in the account currency for the report period
• Actual Qty - Sum of the quantities entered on transactions
• Budget Value LC - Budget entered in Greentree in local (system) currency - which budget to use is specified on the report or can optionally be changed when you run the report
• Budget Value FC - Budget in the currency of the account
• Budget Qty - Budget quantity
• Calculation - Enables you to add or subtract any other columns or column/row combinations defined previously in this format
• Actual Value LC TCode - Actual values in local (system) currency for a specific TCode - transaction analysis tree branch
• Budget Value LC TCode - Budget value in local (system) currency for a specific TCode
• Account Notes - Displays any notes within Greentree of the detailed Account (drilled down level)
• Sticky Notes - Displays sticky notes of the defined type of the detailed GL Account
• Commitments - Value of any purchase orders coded to the specified general ledger account - does not work for inventory or job cost
• Blank - Leaves a empty column.
• Actual Qty TCode - Sum of quantities for the specified TCode
• Budget Qty TCode - Sum of quantities entered for the specified Budget and TCode
• Reporting Budget LC - Budget value in local (system) currency for the report period - includes budget values at more detailed level for example, includes TCode even if not specified
• Reporting Budget LC TCode - Budget value in local (system) currency for the report period - includes budget values at more detailed level for example, includes TCode sub branches
• Reporting Budget FC - Budget value in currency of the accounts for the report period - includes budget values at more detailed level for example, includes TCode even if not specified
• Reporting Budget Qty - Budget quantity for the report period - includes budget quantities at more detailed level for example, includes TCode even if not specified
• Reporting Budget Qty TCode - Budget quantity for the TCode for the report period - includes budget quantity at more detailed level for example, includes TCode sub branches
• Actual/Budget LC - Actual value in local (system) currency up to the date the report runs for then budget ( would be used for 12 month reporting)
• Actual/Budget FC - Actual value in foreign currency up to the date the report runs for then budget ( would be used for 12 month reporting)
• Actual/Budget TCode LC - Actual value in local (system) currency for a specific TCode up to the date the report runs for then budget ( would be used for 12 month reporting)
• Actual/Budget Quantity - Actual quantity up to the date the report runs for then budget ( would be used for 12 month reporting)
• Actual/Budget Qty TCode - Actual quantity up to the date the report runs for then budget for the TCode( would be used for 12 month reporting)
• Comment - Type in a comment.

Special headings are available for the Actual/Budget headings.

Heading 1 and 2 can use a special type so that they can print differently depending on whether it is an Actual or Budget that is being displayed.

Example Headings

{Actual:February,BUDGET:Budget February}

Or:

{ACTUAL:March,BUDGET:Budget March}

The part before semi colon is not case sensitive.

Or you can switch them around:

{BUDGET:Budget March, ACTUAL:March }

Or:

{ BUDGET:Budget February,Actual:February }

The syntax will be:

{ACTUAL:the heading,BUDGET:the budget heading}

Report Period Range

The figures reported in the financial reports relate to a period range. The Start Period is the first period reported and the End Period is the last period. Periods are derived from the calendar specified in General Ledger Module Control.

Select

• Opening Bal, to report YTD values.
• Date Entered, to specify a date when the report runs. The Relative field can be applied to use periods relative to a specific date.

Example

YTD

Start Period = Opening Bal, Relative is empty or 0, End Period = Date Entered, Relative is empty or 0.

Last 3 Months

Start Period = Date Entered, Relative is -3, End Period = Date Entered, Relative is empty or 0.

12 months across the page

Start Period = April, Relative is empty or 0, End Period = April, Relative is empty or 0. Here you would specify twelve columns and for each of them select the different months.

Rolling twelve months

Start Period = Date Entered, Relative is empty or 0, End Period = Date Entered, Relative is empty or 0

then

Start Period = Date Entered, Relative is -1, End Period = Date Entered, Relative is -1, and the like. up to -11.

Style

Select Decimal or Percentage as the style in which to display the values.

Captions/Headings

Type in the captions you want to display for the column on the web page and within Greentree Desktop.

Calc

Enter a calculation. This must be for a Calculation column type and relate to columns previously defined. For example look at Column 30 and 40:

It is possible for a calculation to see a specific row and column value for example C30/C20R10 - this would use the value from the specific call of row 10 and column 20. This can be useful when you are trying to display a value per quantity for example, if you have Kilometers display on one row then you want to calculate the spend per km.

You can do multiple part calculations and make the intermediate steps not Visible .

Override Company

Type in a company code if you want a specific company only to be reported in the column. this could be used where you have multiple companies and want them displayed across the page.

Account Mask

This is the equivalent of the search parameter gtGLActBal. Use it to design financial reports with departments across the page. Every row within the report is based on a Tree and Branch selected within Row Maintenance, but it can then be further filtered by the Account Mask. Enter the account masking you require into this column. for example, 10.*.* or 20.*.*

Visible

Select this option to make the column visible on the web page. You would use Invisible columns where a value is required for a calculation but doesn't actually must be displayed.

Width

Specify the width required for this column

Style

Select a style only if you want this column to display differently to the other columns on this row. Greentree uses a column style and if not found uses the row style. A column style will take precedence over a row for example, if both set background colour it uses the colour from the column.

Note Type

If this column displays Sticky Notes then select the sticky note type to display, you can only display one type per column.

Override TCode

If you want different TCode values displayed in different columns, then specify the specific TCode for this column. You can use this to report on salespeople or vehicles across the page.

Override GL Budget

If you want this column to report a specific budget which is different to other columns or the report default, then specify the budget code here.

Excel Width

Specify the width for the column when exported to Excel.

Excel Heading 1

Type the words to appear on the top row of the column headings when exported to Excel. If the same wording is placed in consecutive columns, the wording will be centered over those columns.

Excel Heading 2

Type the words to appear on the second row of the column headings when exported to Excel.

If both Excel headings are left empty the same headings is used as when displayed in Greentree Desktop.

Print Only if Budget

Select this option if you only want the column to show a value if it is a budget.

Comment

Type in the comment you want to display - per above mostly used when column will be Transposed to a Row.

• Report Maintenance

---