Report definitions (CS206000)

Copy report

Preview

Validate row set definition

This button opens the Account types to be included in the row set validation dialogue box. Here you can select what account types you want to control:

• Income
• Assets
• Liability
• Expense
• Check also if there is missing subaccounts

Depending on what you select and what the Row set contains of accounts, you will get a list of accounts that are missing in the row set.

Code

Description

Type

The data source of the analytical report. The selected option defines the set of parameters in the Default data source settings section.

Select one of the following options:

• General ledger:
  The General ledger workspace is used as the data source.
• Project:
  The Projects workspace is used as the data source.

Account type

Row set

Column set

Unit set

From unit

Company

The company to be used as the source.

Select the Request check box to the right of the option, to add the Company field to the report window so that the user can select a company before running the report.

If the Request check box is not selected, the Company field will not appear on the window, and you should specify a value here that will always be used for the report.

In addition, this column/check box requires that the Multi-branch support check box is selected and enabled in the Enable/disable functionalities (CS100000) window.

Ledger

The ledger to be used as the data source.

Select the Request check box to the right of the option, to add the Ledger field to the report window so that the user can select a ledger before running the report.

If the Request check box is not selected, the Ledger field will not appear on the window, and you should specify a value here that will always be used for the report.

From account

The starting account in the range of account numbers to be included in the analytical report.

Select the Request check box to the right of the option, to add the From account field to the report window so that the user can select an account number to start with before running the report.

If the Request check box is not selected, the From account field will not appear on the window, and you should specify a value here that will always be used for the report.

To account

The ending account in the range of account numbers to be included in the analytical report.

Select the Request check box to the right of the option, to add the To account field to the report window so that the user can select an account number to end with before running the report.

If the Request check box is not selected, the To account field will not appear on the window, and you should specify a value here that will always be used for the report.

From sub.

The starting subaccount in the range of subaccounts to be included in the analytical report.

Select the Request check box to the right of the option to add the From sub. field to the report window so that the user can select a subaccount number to start with before running the report.

If the check box is not selected, the From sub. field will not appear on the window, and you should specify a value here that will always be used for the report.

To sub.

The ending subaccount in the range of subaccounts to be included in the analytical report.

Select the Request check box to the right of the option, to add the To sub. field to the report window so that the user can select a subaccount number to end with before running the report.

If the check box is not selected, the To sub. field will not appear on the window, and you should specify a value here that will always be used for the report.

From branch

The starting branch in the range of branches to be included in the analytical report.

Select the Request check box to the right of the option, to add the From branch field to the report window so that the user can select a branch to start with before running the report.

If the check box is not selected, the From branch field will not appear on the window, and you should specify a value here that will always be used for the report.

In addition, this column/check box requires that the Multi-branch support check box is selected and enabled in the Enable/disable functionalities (CS100000) window.

To branch

The ending branch in the range of branches to be included in the analytical report.

Select the Request check box to the right of the option, to add the To branch field to the report window so that the user can select a branch to end with before running the report.

If the Request check box is not selected, the To branch field will not appear on the window, and you should specify a value here that will always be used for the report.

In addition, this column/check box requires that the Multi-branch support check box is selected and enabled in the Enable/disable functionalities (CS100000) window.

From period

The starting financial period in the range of periods to be used in the report.

Select the Request check box to the right of the option, to add the From period field to the report window so that the user can select a financial period to start with before running the report.

If the check box is not selected, the From period field will not appear on the window, and you should specify a value here that will always be used for the report.

To period

• Not set:
  No end period is defined for the report.
• Request:
  The end period is added to the report window so that the user can select a value in it before running the report.
• Use start:
  The report uses the same start and end period.

Account class

The account class to be used as the data source.

Select the Request check box to the right of the option, to add the Account class field to the report window so that the user can select an account class before running the report.

If the Request check box is not selected, the Account class field will not appear in the window, and you should specify a value here that will always be used for the report.

Symbol display (+/-)

• Not set:
  No symbol is defined for the report.
• Positive values
• Swap liability/expense
• Debit/credit values

Amount type

The amount type to be used to calculate the values in the report.

Select one of the following options:

• Not set:
  No specific amount type is defined for the report.

• Turnover:
  The turnover amounts are included in the report.
• Credit:
  The credit amounts are included in the report.
• Debit:
  The debit amounts are included in the report.
• Beg. balance:
  The beginning balance amounts are used in the report.
• Ending balance:
  The ending balance amounts are used in the report.
• Turnover (currency):
  The turnover amounts in a foreign currency are included (retrieved from the denominated accounts).
• Credit (currency):
  The credit amounts in a foreign currency are included (retrieved from the denominated accounts).
• Debit (currency):
  The debit amounts in a foreign currency are included (retrieved from the denominated accounts).
• Beg. balance (currency):
  The beginning balance amounts in a foreign currency are included (retrieved from the denominated accounts).
• Ending balance (currency):
  The ending balance amounts in a foreign currency are included (retrieved from the denominated accounts).

Apply restriction groups

From acc. group

The starting account group in the range of account groups to be included in the analytical report.

Select the Request check box to the right of the option to add the From acc. group field to the report window so that the user can select an account group to start with before running the report.

If the Request check box is not selected, the From acc. group field will not appear on the window, and you should specify a value here that will always be used for the report.

To acc. group

The ending account group in the range of account groups to be included in the analytical report.

Select the Request check box to the right of the option to add the To acc. group field to the report window so that the user can select an account group to end with before running the report.

If the Request check box is not selected, the To acc. group field will not appear on the window, and you should specify a value here that will always be used for the report.

From project

The starting project in the range of projects to be included in the analytical report.

Select the Request check box to the right of the option to add the From project field to the report window so that the user can select a project to start with before running the report.

If the Request check box is not selected, the From project field will not appear on the window, and you should specify a value here that will always be used for the report.

To project

The ending project in the range of projects to be included in the analytical report.

Select the Request check box to the right of the option to add the To project field to the report window so that the user can select a project to end with before running the report.

If the Request check box is not selected, the To project field will not appear on the window, and you should specify a value here that will always be used for the report.

From task

The starting task in the range of tasks to be included in the analytical report.

Select the Request check box to the right of the option to add the From task field to the report window so that the user can select a task identifier to start with before running the report.

If the Request check box is not selected, the From task field will not appear on the window, and you should specify a value here that will always be used for the report.

To task

The ending task in the range of tasks to be included in the analytical report.

Select the Request check box to the right of the option to add the To task field to the report window so that the user can select a task identifier to end with before running the report.

If the Request check box is not selected, the To task field will not appear on the window, and you should specify a value here that will always be used for the report.

From item ID

The first item ID in the range of item IDs to be included in the analytical report.

Select the Request check box to the right of the option to add the From item field to the report window so that the user can select an inventory to start with before running the report.

If the check box is not selected, the From item field will not appear in the window, and you should specify a value here that will always be used for the report.

To item ID

The last item ID in the range of item IDs to be included in the analytical report.

Select the Request check box to the right of the option to add the To item field to the report window so that the user can select an inventory to end with before running the report.

If the Request check box is not selected, the To itemfield will not appear in the window, and you should specify a value here that will always be used for the report.

From branch

The starting branch in the range of branches to be included in the analytical report.

Select the Request check box to the right of the option to add the From branch field to the report window so that the user can select a branch to start with before running the report.

If the check box is not selected, the From branch field will not appear on the window, and you should specify a value here that will always be used for the report.

In addition, this column/check box requires that the Multi-branch support check box is selected and enabled in the Enable/disable functionalities (CS100000) window.

To branch

The ending branch in the range of branches to be included in the analytical report.

Select the Request check box to the right of the option to add the To branch field to the report window so that the user can select a branch to end with before running the report.

If the Request check box is not selected, the End branch field will not appear on the window, and you should specify a value here that will always be used for the report.

In addition, this column/check box requires that the Multi-branch support check box is selected and enabled in the Enable/disable functionalities (CS100000) window.

From period

The starting financial period in the range of periods to be used in the report.

Select the Request check box to the right of the option to add the From period field to the report window so that the user can select a financial period to start with before running the report.

If the Request check box is not selected, the From period field will not appear on the window, and you should specify a value here that will always be used for the report.

To period

• Not set:
  No end period of the period is defined for the report.
• Request:
  The end period is added to the report window so that the user can select a value in it before running the report.
• Use start:
  The report uses the same start and end period.

Symbol display (+/-)

• Not set:
  No symbol is defined for the report.
• Positive values
• Swap liability/expense
• Debit/credit values

Amount type

The amount type to calculate the values in the report.

Select one of the following options:

• Not set:
  Unspecified amount type; the amount type should be taken from a set (row set or unit set) with a higher priority.
• Actual amount:
  The ending balance of the actual amount of the project budget for the specified period.
• Actual quantity:
  The ending balance of the project budget’s actual quantity for the specified period.
• Amount turnover:
  The turnover of the project budget’s actual amount for the specified period.
• Quantity turnover:
  The turnover of the actual quantity of the project budget for the specified period.
• Original budget amount:
  The original budgeted amount of the project budget.
• Original budget quantity:
  The original budgeted quantity of the project budget.
• Revised budget amount:
  The revised budgeted amount of the project budget.
• Revised budget quantity:
  The revised budgeted quantity of the project budget.
• Original committed amount:
  The original committed amount of the project budget.
• Original committed quantity:
  The original committed quantity of the project budget.
• Revised committed amount:
  The revised committed amount of the project budget.
• Revised committed quantity:
  The revised committed quantity of the project budget.
• Committed open amount:
  The open (not received yet) amount of the original committed project budget.
• Committed open quantity:
  The open (not received yet) quantity of the original committed project budget.
• Committed received quantity:
  The received quantity of the original committed project budget.
• Committed invoiced amount:
  The amount of the released invoices of the original committed project budget.
• Committed invoiced quantity:
  The quantity of the released invoices of the original committed project budget.

Apply restriction groups

Optimise unit set report

When this is selected, you will see the unit set selector in Parameters section when starting the report, and you have to select one unit set definition before running the report. The Print all functionality is now disabled in this routine.

This is only visible if Unit set is defined in the Report definition section of this report.

Location

Title

Paper kind

Landscape

A check box that indicates (if selected) that the report should have landscape orientation, with the shorter side running top to bottom so wider columns can be accommodated.

If the check box is cleared, portrait orientation is used, which means that the longer side runs top to bottom.

Top

The size of the top margin.

Enter the appropriate value in the text field, and use the drop-down field to select the unit of measure (Pixel, Point, Pica, Inch, Mm., or Cm.) for the value.

Bottom

The size of the bottom margin.

Enter the appropriate value in the text field, and use the drop-down field to select the unit of measure (Pixel, Point, Pica, Inch, Mm., or Cm.) for the value.

Left

The size of the left margin.

Enter the appropriate value in the text field, and use the drop-down field to select the unit of measure (Pixel, Point, Pica, Inch, Mm., or Cm.) for the value.

Right

The size of the right margin.

Enter the appropriate value in the text field, and use the drop-down field to select the unit of measure (Pixel, Point, Pica, Inch, Mm., or Cm.) for the value.

Width

Height

Font

Text alignment

• Not set:
  There is no specific text alignment.
• Left:
  The text is aligned to the left.
• Centre:
  The text is aligned by centre.
• Right:
  The text is aligned to the right.

Font style

The font style to be used in printed report.

The available options are Regular, Bold, Italic, Underline, and Strikeout.

Font size

The font size to be used in printed report.

Enter the appropriate value in the text field, and use the drop-down field to select the unit of measure (Pixel, Point, Pica, Inch, Mm., or Cm.) for the value.

Colour

Background colour