Report definitions (CS206000)

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

The ending financial period in the range of periods to be used in the report. Use the list field to the right of To period to specify how the end period is set:

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.

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.

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

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).

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.

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.

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.

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.

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.

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.

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.

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 item field will not appear in the window, and you should specify a value here that will always be used for the report.

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.

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.

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.

The ending financial period in the range of periods to be used in the report. Use the list field to the right of To period to specify how the end period is set:

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.

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

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.

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.

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.

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.

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.

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.

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.

The text alignment of the printed report. You can select one of the following options:

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.

The font style to be used in printed report.

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

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.