A subaccount or a group of subaccounts.

If the field is left blank, all the transactions for the selected account in the specified period will be listed. If the values for only some segments are specified, this defines a group of subaccounts with the specified values as well as all the different values in the segments that were left blank.

The branch of the company whose data you want to view. You can select a required branch, or clear this field. With the empty field, information on all branches is shown.

This field is available only if the Multi-branch support functionality is enabled in your system in the Enable/disable functionalities (CS100000) window.

The subaccount or mask for a group of subaccounts.

If you leave the field blank, all transactions for the selected account in the specified period will be listed. If values are specified for only some segments, this defines a group of subaccounts with the specified values as well as all the different values in the segments that were left blank.

A description of the account class. An alphanumeric string of up to 30 characters may be used.

> [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support

Opens the Reclassify transactions (GL506000) window, where you can proceed with the reclassification of the selected transactions.

You select the check boxes next to the required transactions in the table before clicking Reclassify.

Opens the Reclassification history (GL405000) window for the selected transaction.

This button is available only if the reclassified transaction is selected in the table.

The company whose data you want to view.

This field is available only if the Multi-branch support check box is selected and enabled in the Enable/disable functionalities (CS100000) window.

The branch of the company whose data you want to view. You can select a required branch, or clear this field. With the empty field, information on all branches is shown.

This field is available only if the Multi-branch support check box is selected and enabled in the Enable/disable functionalities (CS100000) window.

The ledger in which you want to view the account balances.

You can select a ledger of the Actual, reporting, or Statistical type.

A ledger of the Budget type is not available for selection.

The subaccount or mask for a group of subaccounts.

If the field is left blank, all the transactions for the selected account in the specified period will be listed. If values are specified for only some segments, this defines a group of subaccounts with the specified values, as well as all the different values in the segments that were left blank.

When you have a large number of transactions that you want to view, you can select the Manually started search check box to avoid that the system starts searching every time you change your search criteria, and to faster see your search results.

By clicking the Manually started search, a Search button appears. Select your search criteria and then click the Search button. Each time you click the Search button, a new set of transactions matching your search criteria will appear in the search result list.

The ending balance of the account calculated based on the transactions shown in the table.

When a filter is applied to the records in the table, the ending balance of the account is calculated as the beginning balance of the account in the period selected in the From period field plus the turnover amount calculated based on the records shown in the table.

The workspace where the transaction originated.

This column appears if, for the selected range of days or periods, there are transactions originating in other workspaces that updated the balance of the selected account.

The reference number of the batch (generated for the transaction) that updated the balance of the selected account.

Click the link to navigate to the Journal transactions (GL301000) window so you can view batch details.

The branch of the company, that the entry was posted in.

This field is available only if the Multi-branch support check box is selected and enabled in the Enable/disable functionalities (CS100000) window.

The ID of the customer or the supplier account.

It is defined by the BIZACCT segmented key or by the CUSTOMER or the SUPPLIER segmented key (which inherits its structure from the BIZACCT key) when you are creating a new customer or a supplier in the Customers (AR303000) or the Suppliers (AP303000) window.

You can later change the customer or supplier no. by selecting Change ID from the Actions menu in the toolbar in the same window.

The name of the customer or the supplier, that appear in the system, which may be a trading name or a doing-business-as (DBA) name.

The name is created in the Customers (AR303000) or the Suppliers (AP303000) window.

Optional.

The account class for which you want to display summaries. For the selected class, all the account activities matching the selected subaccount or subaccount group will be displayed in the table. If this element is left blank, accounts of all classes will be displayed. The available account classes are defined in the Account classes (GL202000) window.

A subaccount or a mask for a group of subaccounts.

If the field is left blank, all the transactions for the selected account or accounts in the specified period will be listed. If values only for some segments are specified, this defines a group of subaccounts with the specified segment values and various values in any segments that you left blank.

Selecting this check box will display a list of accounts with only a debit or credit transaction in the specified period.

Accounts with only Beginning balance / Ending balance but with no debit or credit values will be excluded from the list.

The unique ID of the allocation.

The system generates IDs in accordance with the numbering series selected for allocations on the General ledger preferences (GL102000) window.

A detailed description of the allocation.

The alphanumeric string may contain as many as 30 characters.

The way the allocation amount should be collected from the source accounts. Select one of the following options:

By account PTD

The period-to-date amount should be collected from the source accounts.

From prev. allocation

The amount accumulated since the last allocation should be collected from the source accounts.

The way the allocated amount is distributed over the destination accounts. The following options are available:

By percent

The source amount is distributed among destination accounts by percentages, which are set in the Destination accounts tab of this window. The total is 100 percent.

By weight

The amount is distributed between destination accounts by user-defined coefficients, which are set on the Destination accounts tab of this window. The total is not defined.

By destination account PTD

The amount is distributed between the destination branches proportionally to period-to-date balances of the destination accounts in the allocation ledger or proportionally to PTD balances of the base accounts of the base branches in the base ledger if it is specified or in the allocation ledger if the base ledger is not specified.

By destination account YTD

The amount is distributed between the destination branches proportionally to year-to-date balances of the destination accounts in the allocation ledger or proportionally to YTD balances of the base accounts of the base branches in the base ledger if it is specified or in the allocation ledger if the base ledger is not specified.

Required.

The ledger to which journal entries generated for the allocation are posted. You can select a ledger of the following types: Actual, Statistical, Budget, or Reporting types.

Required.

The specified ledger is used to calculate an amount to be allocated.

The account or accounts (if you use a grouping mask) that will be the source of the allocation amount. To use a grouping mask, specify characters common for all account identifiers and use ? as a wildcard character to designate varying characters in the accounts.

If you want to specify common characters only at the beginning of the segment, you may leave the rest of segment blank. You need not type ? in every position, but if you want to specify characters at the beginning and at the end of the same segment, type ? in the positions between them.

For example: The mask 110____ selects all the accounts in which identifiers start with 110. The mask 310???5 selects the accounts in which identifiers start with 310 and end in 5: 3100005, 3100015, 3100195, and so on.

The subaccount for the accounts that will be the source of the allocation amount. You can use a grouping mask to specify a group of subaccounts. Select a segment and press F3 to select a value common to all subaccounts you want to view; leave the segments blank if they can have varying values in the subaccounts.

If you want to specify only several characters in a specific segment, type ? in other positions of the segment.

For example: You could use the mask Dept1/Product2//orDept?/Product?//, where**/** is a segment separator character.

Optional.

The account from which the allocated amount will be actually deducted. You may not use a grouping mask here.

Optional.

The subaccount for the specified contra account. You may not use a grouping mask here.

The percentage of the balance that may be allocated from each account grouped by the account and subaccount masks.

The default is 100 percent.

(Optional and available only if Distribution method is set to By destination account PTD or By destination account YTD.)

The base branch, whose account balances should be used to calculate a proportion for distributing the allocation amount between the destination accounts of the destination branches. For this, the system uses the base branch’s account balances in the ledger specified in the Base ledger field on the Allocations tab.

If no base ledger is specified, the system uses the allocation ledger.

If no base branches are specified in this column, no base accounts and base subaccounts are specified in the respective columns, the system distributes the allocation amount between the destination branches proportionally to YTD or PTD balances of the destination accounts (with corresponding subaccounts). If only the base branches are not specified, the system uses the destination branches for calculate proportions based on the balances of base accounts.

(Optional and available only if Distribution method is set to By destination account PTD or By destination account YTD.)

The base account for the allocation. The allocation amount will be distributed between the destination branches according to the current PTD or YTD balances of the base accounts for the base branches. For this calculation, the system uses the account balances of the branches (for the base subaccounts) in the base ledger (specified in the Base ledger field on the Allocations tab).

If no base branch is specified, the system uses the destination branch.

If no base ledger is specified, the system uses the balances of the base accounts in the allocation ledger.

(Optional and available only if Distribution method is set to By destination account PTD or By destination account YTD.)

The base subaccount for the allocation. The allocated amount will be distributed according to the current PTD or YTD balances of the base accounts under the specified base subaccounts in the base ledger for the base branch.

If no base branch is specified, the system uses the destination branch. If the Base ledger is not specified on the Allocations tab, the proportion is calculated based on the balances in the allocation ledger.

(Available only if Distribution method is set to By percent or By weight and required.)

A value that defines the weight of the account. The allocation amount will be distributed among the destination accounts proportionally to their respective weights or according to the specified percentages. If the Distribution method is By percent, the sum of values in this column must be equal to 100 percent.

Navigates to the Restriction groups by budget article (GL105020) window so you can review and edit the restriction groups related to budget articles.

This button is available only if the Row-level security check box is selected and enabled in the Enable/disable functionalities (CS100000) window.

The account mask. The mask specified for the node will provide the default values for the account range in the Preload accounts dialog box when you populate this node.

If the mask is specified for a leaf article, then, on data loading for a new budget, amounts can be aggregated over all the account-subaccount pairs selected by this mask and the mask for subaccounts.

The subaccount mask. This mask, if specified for a node, provides the default subaccount mask in the Preload accounts dialog box when you populate this node.

This mask, if specified for a leaf article, on data loading for a new budget, amounts can be aggregated over all the account-subaccount pairs selected by the mask for accounts and this mask.

(This column appears only if the Subaccounts functionality is activated in your system.)

Required.

The branch whose budget you create or view. By default, it is the branch to which you have signed in.

This field appears only if the Multi-branch check box is selected and enabled the Enable/disable functionalities (CS100000) window.

Required.

The ledger of the Budget or Statistical type that stores the budget.

Required.

The financial year of the budget.

The multiplier, expressed as a percent, to be used to calculate the amounts for the budget.

By default, the multiplier is 100.

Optional.

The account that starts the range of accounts you want to load. If any value appears by default, it is based on the account mask specified for the node.

If you leave the field blank, the system will use the first account listed the Chart of accounts (GL202500) window.

Optional.

The account that ends the range of accounts you want to load. If any value appears by default, it is based on the account mask specified for the node.

If you leave the field blank, the system will use the last account listed in the Chart of accounts (GL202500) window.

Optional.

The account mask that selects the accounts to be loaded. Use ? as a wildcard character.

If both the range and the mask are specified, the accounts selected both by the mask and by the range will be loaded.

Optional.

The subaccount mask that defines the subaccounts to be loaded. You can specify a value of a particular segment or just a few characters of the segment value to select the subaccounts for loading. Use ? as a wildcard character.

This field appears only if the Subaccounts check box is selected and enabled the Enable/disable functionalities (CS100000) window.

Determines the action to be taken if you click OK:

Roll back to released values

Cancels the changes made to the budget after it has been released, and restores the released values.

Convert budget using current budget configuration

Transforms the current budget into a budget tree, which you can view and edit in the Budget configuration (GL205000) window. We recommend that you fill in the Account mask and Subaccount mask columns for the nodes in the configured budget tree. The account and subaccount masks define the group of articles that can be added to each node during the conversion. If the account and subaccount masks are not specified for the nodes and if a leaf is not defined for each required article of the node, the appropriate articles will not be added to the required nodes. As a result, the conversion will be completed improperly.

The branch of the organization whose budget is being created or selected for viewing.

This field appears only if the Multi-branch check box is selected and enabled the Enable/disable functionalities (CS100000) window.

The budget ledger.

If you are going to create a new budget from scratch, you should first create a budget ledger by using the Ledgers (GL201500) window.

The financial year of the budget.

If the budget ledger does not contain data for the selected year, the system prompts you to agree to load the budget tree structure.

Optional.

This field appears only if the Multi-branch check box is selected and enabled the Enable/disable functionalities (CS100000) window.

The branch whose budget or ledger data will be used for comparison.

Optional.

The ledger to be used for comparison. The amounts from the selected ledger for the selected year will be displayed in the Budget articles pane in a separate line under each budget article for comparison.

Optional.

The financial year to be used for comparison.

Optional.

This field appears only if the Subaccounts functionality is activated in your system. Specify the segment values to display in the right table only the budget articles with specific segment values in their subaccounts.

Optional.

This field can be used only if the Tree view check box is selected.

Specify the characters in node names to display only the specific nodes of the budget tree in the Budget tree pane.

The method of distribution, which is one of the following options:

Evenly

To distribute the year amount over the financial periods evenly, excluding the adjustment period if this period has been configured in your system.

Proportionally to the previous year

To distribute the year amount over the financial periods proportionally to amounts of the previous year’s periods, including the adjustment period. (This option is available only if budget articles were loaded with the amounts from one of the previous years.)

Proportionally to compared values

To distribute the year amount over the financial periods proportionally to the amounts selected for comparison. (This option is available only if budget articles were loaded with the amounts.)

The subaccount of the budget article if the article is a leaf on the budget tree.

This column appears only if the Subaccounts check box is selected and enabled the Enable/disable functionalities (CS100000) window.

The article amount, which is one of the following:

• A manually entered amount if the article is a leaf
• A read-only amount, automatically aggregated over the subarticles, if the article is a node
• An editable amount, initially automatically aggregated for a leaf article over the subarticles specified by an account mask and subaccount mask

This button appears if the Webhook notifications check box in the General ledger preferences (GL102000) window is selected.

If you click this button, the Webhook notification for account (GL407000) window opens where you can view the notifications regarding changes done on accounts and view the notification feedbacks.

The unique identifier of the general ledger account in the system.

While specifying the values in segments, you can use the validation function, which allows you to select a value for each segment from the list of existing ones. For details, see the Segment keys (CS202000) window. For details about validation, see: About account IDs.

An alphanumeric string of up to 30 characters that describes the account.

> [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support

An option that defines how transactions created in other workspaces are posted to this account. Two options are available:

• Summary (default): Indicates that transaction amounts can be summarised for posting to the account (subaccount, if any).
• Detail: Indicates that each transaction will be posted to a selected account (subaccount) separately. If you select this option, the Post summary on updating general ledger option specified on the preferences forms of other workspaces will be overwritten. The Detail option is specified by default and not available for editing for the accounts, for which the Cash account check box is selected.

If the Post summary on updating general ledger check box is cleared on the preferences window of a particular workspace, the transactions will be posted separately to account (subaccount) regardless of which option is specified for an account in the current window.

The summarised transaction amounts will be posted to an account (subaccount) only if both the Summary option is specified for an account and the Post summary on updating general ledger check box is selected on the preferences window of the corresponding workspace.

Optional. This column is used only if the company is a consolidation unit in a parent company.

The external general ledger account from the parent company’s chart of accounts to which the balance of the account will be exported in the process of consolidation. Select the account in this column only if the synchronization of the parent company with the current company has been performed in the Consolidation (GL103000) window for the parent company.

This column is available only if the General ledger consolidation functionality is enabled in the Enable/disable functionalities (CS100000) window.

Optional: This column appears only if support for multiple currencies has been activated for the system.

The currency of denomination used for the account. If the field is blank, the account uses the base currency. Denominated general ledger accounts cannot be used as source or destination accounts for general ledger allocations. You can always cancel currency denomination by clearing this field.

A control account is a general ledger account that aggregates the balances of entities in a subledger; it can be used for analytical purposes as well as for the reconciliation of balances between subledgers and the general ledger.

You indicate that an account is to be used as a control account for a particular subledger by selecting the subledger.

The alternatives are:

• Supplier ledger
• Customer ledger
• Supplier ledger and Customer ledger

A VAT category that you define for the selected account. When you create a journal transaction manually in the Journal transactions (GL301000) window, based on this VAT category, the taxable amount will be calculated for the journal entry. The category selected here will be used as the default on the invoice lines with this account.

The type of the account must correspond to the type of the tax specified in the VAT category. For example: A VAT category representing a sales tax could not be associated with an expense account, and a VAT category representing value-added tax (VAT) accumulated on purchases could not be associated with an income account.

It is used as the standard account code in the SAF-T report for Norway ( SAF-T report (TX50600S) ) and the FIA report ( FIA report (GL40500S) for Finland.

There is no lookup here, so you have to know what code to enter.

This column is filled out based on the Account type and are used in some reports and inquiries to sort and group the accounts. The values are as following: 1 = Assets, 2 = Liability, 3 = Income and 4 = Expense.

In the General ledger preferences (GL102000) window you can select the sort order for this code.

Initiates the process of closing the selected financial periods.

A read-only check box that, if selected, indicates that the financial period is closed in the Supplier ledger workspace; if the check box is cleared, it indicates that the period is active in the Supplier ledger workspace.

To close a period in the Close financial periods (AP506000) window. For details see: About period-end closing procedures.

A read-only check box that, if selected, indicates that the financial period is closed in the Customer ledger workspace; if the check box is cleared, it indicates that the period is active in the workspace.

To close a period in the Customer ledger workspace, use the Close financial periods (AP506000) window.

A read-only check box that, if selected, indicates that the financial period is closed in the Inventory workspace; if the check box is cleared, it indicates that the period is active in the Inventory workspace.

To close a period in the Inventory workspace, use the Close financial periods (AP506000) window.

A read-only check box that, if selected, indicates that the financial period is closed in the Cash management workspace; if the check box is cleared, it indicates that the period is active in the Cash management workspace.

To close a period in the Cash management workspace, use the Close financial periods (AP506000) window.

A read-only check box that, if selected, indicates that the financial period is closed in the Fixed assets workspace; if the check box is cleared, it indicates that the period is active in the Fixed assets workspace.

To close a period in the Fixed assets workspace, use the Close financial periods (AP506000) window.

Initiates the copying of the selected column set configuration.

If you click this button, you type the new column set code in the New column set code dialogue box that opens.

The data source of the column set. 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 formula that defines the header name and printing style selected for the range of columns. To specify the header name, you can use text or formulas.

You click the selector in this field to view the Formula dialog box. To specify a formula, enter it in this field. For more information about formulas, see: About formulas.

> [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support

The alignment of the text to be displayed for the range of columns. You can select one of the following options:

Not set

There is no specific text alignment.

Left

The text is left-aligned.

Centre

The text is centred.

Right

The text is right-aligned.

The descriptive name of the column.

> [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support

The value to be displayed in the column. You can create a formula to define the value.

> [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support

The rounding rule, which the system uses to round the values in the corresponding columns of the report. Select one of the following values:

No rounding

The value is not rounded in the report.

Whole currency unit

The system rounds the value to an integer. (€1,117,559,400.58 is rounded to €1,117,559,400.)

Thousands

The system truncates the last three digits of the value (before the decimal point) and rounds the number to an integer portion and one decimal place. (€1,117,559,400.58 is rounded to €1,117,559.4.) Thus, the values in the selected column of the report will be considered thousands.

Whole thousands

The system truncates the last three digits of the value (before the decimal point) and rounds the number to an integer value. ( €1,117,559,400.58 is rounded to €1,117,559.) Thus, the values in the selected column of the report will be considered thousands.

Millions

The system truncates the last six digits of the value (before the decimal point) and rounds the number to an integer portion and one decimal place. (€1,117,559,400.58 is rounded to €1,117.6.) Thus, the values in the selected column of the report will be considered millions.

Whole millions

The system truncates the last six digits of the value (before the decimal point) and rounds the number to an integer value. ( €1,117,559,400.58 is rounded to €1,118.) Thus, the values in the selected column of the report will be considered millions.

Billions

The system truncates the last nine digits of the value (before the decimal point) and rounds the number to an integer portion and one decimal place. (€1,117,559,400.58 is rounded to €1.1.) Thus, the values in the selected column of the report will be considered billions.

Whole billions

The system truncates the last nine digits of the value (before the decimal point) and rounds the number to an integer value. ( €1,117,559,400.58 is rounded to €1.) Thus, the values in the selected column of the report will be considered billions.

The selected rounding rule is applied to all column cells except those whose rows contain the RoundingDiff() function in the formulas. The values of such cells will be rounded by the rows’ formulas.

The format used to convert the data selected from the data source to the string value used in the printed report. You can use C# data conversion functions to convert data to string values.

• #,##0.00 format an amount column with 2 decimals
• #,##0% format for a calculation and add % in the end

The printing group to include the column.

If you specify a printing group, the data from these columns will be printed only in the rows that have the same Column group value as the value defined here.

The way the column will be printed, which is one of the following:

Print

The column will be printed in the report.

Hidden

The column will be hidden from the report and used only to store some values.

Merge next

The column will be merged with the next one in the report.

The formula that defines the conditions of visibility of a column in the generated report.

For details, see: Column attributes.

The printing style to be used for this data row. The printing style parameters are defined in the Style dialog box, which you invoke by clicking the selector in this field.

For this lookup description, see the Style parameters section of Printing styles.

The source of the data to be displayed in the column.

Used to limit content based on Ledger, Account, Subaccount, Period, Offset period, Unit set, Amount type.

Mostly used for offset periods and budget columns.

The ID of a segment in the subaccount segmented key of the parent company.

You reserve this subaccount segment for identifying a subsidiary once the consolidation process is performed. The system inserts a specified subaccount segment value of a subsidiary to this segment.

The appropriate segment values are specified for each required subsidiary in the Consolidation segment value column of the current window.

Note that the consolidation segment is not involved in mapping because the subsidiary does not contain such a segment in its subaccounts.

The ledger of the consolidation unit that should be used as a data source for consolidation.

The list of ledgers appears after you click Synchronise on the window toolbar.

A read-only value that displays the financial period of the last consolidation.

The value is updated each time a consolidation has been performed.

The account type you want to change to. There are four account types to choose from:

• Asset
• Liability
• Income
• Expense

Select the VAT reporting scenario you want to use for export/import of VAT.

It is mandatory to enter a value. Use the default Export VAT Scenario.

Select the governmental general ledger reporting scenario you want to use.

It is mandatory to have a value, so use the default FIA Reporting Export Scenario. Others will affect the output of the file created.

It is used in the FIA report (GL40500S) window. On the export, this value which is selected here is used as a scenario name in the exported report.

Open a dialog where you can select what workspace you want to reopen. The General ledger will always be reopened if it is closed when you select another workspace.

The dialog:

This will open the general ledger and other selected workspaces for the chosen and subsequent periods.

Reopen from period PP-YYYY

• General ledger
• Supplier ledger
• Customer ledger
• Cash management
• Inventory management
• Fixed assets

If you try to reopen a period in which all workspaces are open, you will get the message Financial Period ‘09-2024’ is already opened.

A check box that you select to enable modification of the periods of the current year.

You can edit the end dates of periods; the start dates of the periods will adjust automatically. If, after modification of the periods, the last period ends on a different date than the financial year does, when you save your changes, the system opens the Update financial year dialog box where you can select a method to update the end of the year.

You can select one of the following options:

Modify start date of the next year:

To move the start date of the next financial year to the end of the last period.

Modify financial year settings:

To modify the settings of the financial year to make the last period end when the year ends.

Extend the last period:

To extend the last period so that it will include the end of the year.

Also, you can select whether to move the start date of a financial period to another day of the week.

The description of the financial period (such as the name of the month or the number of the quarter). This value is set in the Financial year (GL101000) window but can be overwritten.

> [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support

A check box that indicates (if selected) that the adjustment period is active and available for posting adjustment transactions.

This column is available only if the User defined periods check box is selected.

Generates a period template based on which you generate the financial periods for a financial year in the Financial periods (GL201000) window.

A periods template can be generated for the periods of the Month, Two months, and Quarter types (specified in the Period type field), and for the custom periods (the Custom number of periods option specified in the Period type field).

The system does not support automatic period generation for periods based on weeks.

Shifts the company’s first year to one year earlier.

After clicking this button, you can add a new financial year and generate periods for it by using the Financial periods (GL201000) window.

The type of financial periods that make up the year. The following options are available:

Month

Each of the financial periods lasts one month (12 periods per year).

Two months

Each of the financial periods has a duration of two months (six periods per year).

Quarter

Each of the financial periods lasts a quarter-year, or three months (four periods per year).

Week

Each of the financial periods lasts one week (52 or 53 periods per year). For instructions, see: Configure week-based financial periods.

Two weeks

Each of the financial periods lasts two weeks (26 or 27 periods per year).

Four weeks

Each of the financial periods has a duration of four weeks (13 or 14 periods per year).

4-4-5 weeks

The financial year is divided into four quarters, and each quarter includes two four-week periods and a five-week period.

4-5-4 weeks

The financial year is divided into four quarters, and each quarter includes a four-week period, a five-week period, and a four-week period.

5-4-4 weeks

The financial year is divided into four quarters, and each quarter includes the following periods: a five-week period and two four-week periods.

Custom number of periods

The financial year is divided into a user-defined number of financial periods. Once you specify the number in the Number of financial periods field, the system generates the periods, and you will be able to adjust the their lengths.

The day of the week when each period starts.

Note: This setting is available only for period types based on weeks.

A check box that you select to align the start and end dates of financial periods with the start and end dates of the corresponding calendar period.

This option is enabled for the following period types:

• Month
• Two months
• Quarter

For example, with this option selected:

• If the financial year’s start date is March 10 and the period type is Monthly, the first period will start on March 1.
• If the period type is Quarterly, the first period will start on January 1.
• If this option were not selected in either case, then the first period would start on March 10 (as the financial year does).

This field is available only for period types based on months and for the Custom number of periods option.

The total number of financial periods within a financial year. With custom-length periods (or a custom number of periods), this setting defines the required number of financial periods. Otherwise, it displays the number of periods, which the system calculates automatically based on the period type.

A check box that causes the system (if selected) to generate an adjustment period or an additional period for posting adjustments. The adjustment period will have the same start and end date and will be the last period in the financial year.

The adjustment period does not appear by default for any date; in the lookup boxes for selecting document dates, you have to select it manually.

Note: This field is available only for week-long periods.

The method used to determine the end of the year for week-long periods. You can select one of the following options:

Last day of the financial year

To add an additional (fifty-third) week-length period if the last period ends four or more days earlier than the financial year ends. If the last period ends fewer than four days earlier, no additional period will be added.

Include last <Day of week> of the financial year

To add an additional (fifty-third) week-length period only if the specific day of week (which is the last in the financial year) is not included in the last period.

Include <Day of week> nearest to the end of financial year

To set the year end so that its last period includes the specific day of week that is nearest to the end of the financial year. An additional (fifty-third) period will be added if the specific day of week is closer to the end of the year than to the end of the last period.

For these options, <Day of the week> is the day of the week selected in the Day of week field.

A description of the financial period (such as the name of the month or the number of the quarter). For financial periods based on months, the descriptions are populated automatically but can be overwritten.

> [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support

A check box that indicates (if selected) that the restriction group is active. You can clear the check box to make the group inactive, which means that restrictions imposed by the restriction group do not affect the visibility of entities to users.

By default, this check box is selected.

A number series assigned to allocations.

This field is available only if the Allocation templates check box is selected in the Enable/disable functionalities (CS100000) window.

A check box that, if selected, indicates that reference numbers for documents created by using the Journal vouchers (GL304000) window are reused in case the number was allocated for the document that was not saved (thus, not created), or the reference number was allocated for a deleted document.

This check box is available if the Journal voucher check box is selected in the Enable/disable functionalities (CS100000) window.

A setting for the number of digits for the SAF-T standard account code.

For the Norwegian SAF-T report only the values 2 or 4 are valid.

The option that defines how the balances of the liability and income accounts are represented in the trial balance. The following options are available:

Normal

The credit balances for liability and income accounts are displayed with the plus sign, the debit balances with the minus sign. The Year to date net income account is included in the trial balance. In the trial balance of this type, the total balance of all asset accounts is equal to the total balance of all liability accounts.

Reversed

The credit balances of liability and income accounts are displayed with the minus sign, the debit balances with the plus sign. The Year to date net income account is excluded from the trial balance. In the trial balance of this type, the total balance of all accounts is equal to zero.

You need to specify an appropriate option before importing the trial balance to Visma Net depending on the type of the trial balance to be imported.

The option that indicates when the system generates reversing batches: On period closing or On post.

The On period closing cannot be selected if you want to revalue supplier/customer accounts in the currency management module (windows Revalue supplier accounts (CM504000) and Revalue customer accounts (CM505000) ).

A check box that indicates (if selected) that transaction posting to closed financial periods is allowed. Closed periods do not appear in the data entry windows on the list of financial periods, so the users have to type in the period directly.

If this check box is not selected, an error message will appear if the user attempts to post or enter transactions into a closed financial period.

A check box that indicates (if selected) that on the release of multiple documents in the Supplier ledger, Customer ledger, Cash management, and Inventory workspaces, documents are grouped by branch, posting period, and currency, and the batches are generated on a per-group basis rather than on a per-document basis.

If this check box is not selected, then for each document released in the Supplier ledger, Customer ledger, Cash management, and Inventory workspaces, a separate batch is generated in the General ledger workspace.

This check box is only available when the Journal voucher check box is selected in the Enable/disable functionalities (CS100000) window.

If you select this check box, then when new vouchers are saved, they have the On hold status by default.

A check box that indicates (if selected) that batch control totals will be validated: The users will have to enter the batch control total before they save the batch in the Journal transactions (GL301000) window.

If the check box is not selected, validation will be performed only when the user deselect the Hold batches on entry check box for a batch, and unbalanced batches may be saved as drafts.

This field is available only if the VAT entry from general ledger and the Journal voucher check boxes are enabled in the Enable/disable functionalities (CS100000) window.

A check box that indicates (if selected) that the voucher entry code is required when you add VAT-related journal transactions in the Journal transactions (GL301000) window.

This check box is only available when the Journal voucher check box is selected in the Enable/disable functionalities (CS100000) window.

If this check box is selected, the Ref.no. column in the Journal transactions (GL301000) window is automatically populated, with the next available number from the assigned numbering which you find in the Last number column in the Number series (CS201010) window.

The date that the system uses to filter the schedules to be loaded to the table. Those schedules whose Next execution date is earlier than or equal to the date specified in this field are loaded. Clear the field to display all schedules.

By default, the current business date is displayed.

The schedule’s unique ID.

By clicking the number, the system opens the Recurring transactions (GL203500) window as a dialog window; in this window, you can view the details of the selected schedule.

The reference number of the external or internal document associated with the journal transaction. Journal entries related to the same document should have the same reference number specified.

The documents reference numbers must be specified for VAT-related journal transactions.

It is required because VAT and taxable amounts are reflected in the VAT reports only if they are linked to the corresponding documents.

If the reference number of the external document has been manually specified for a journal transaction, the document cannot be opened because it was not added to the system.

The debit amount of the journal entry.

You can specify only a debit or a credit amount for a single journal entry.

The credit amount of the journal entry.

Again, you can specify only a debit or a credit amount for a single journal entry.

The workspace where the batch originates.

New batches can be created only for General ledger.

The project with which this transaction line is associated, or the code indicating that this batch is not associated with any project.

The Non-project code is specified on the General information tab in the Project accounting preferences (PM101000) window.

This column appears only if the Project accounting check box is selected and enabled in the Enable/disable functionalities (CS100000) window.

The particular task of the project with which this transaction line is associated.

This column appears only if the Project accounting check box is selected and enabled in the Enable/disable functionalities (CS100000) window.

Provides the following menu commands:

Reverse batch

Generates a reversing batch for the currently open batch and displays its details in the window. Enter the Control total for the reversing batch and save it.

Add to schedule

Navigates to the Recurring transactions (GL203500) window, where you can specify the schedule parameters for the batch. Once the batch is assigned to a schedule, its status changes to Scheduled. Only batches with the Balanced status can be assigned to a schedule.

Reclassify

Opens the Reclassify transactions (GL506000) window, in which you can initiate the reclassification process. For details, see: About reclassifying general ledger transactions.

Includes the following menu commands you can click to generate reports:

Batch register details

Navigates to the General ledger register (detailed) (GL62100S) report, which displays the list of all the batches released and posted to the general ledger during the specified financial period. Batch details include accounts, subaccounts, currency, and amounts.

Unreleased transactions details

Navigates to the Unreleased transactions (detailed) (GL610500) report, which displays the list of transactions that were entered (but not released) during the specified financial period.

Reversing batches

Navigates to the Reversing batches (GL690010) report, which displays details of reversing batches.

The current status of the batch. The status defines what processing can be applied to the batch. The following options are available:

On hold

This status is usually assigned to newly created batches. Batches with the On hold status cannot be released or posted. If an On hold batch has total debits equal to the total credits, its status can be changed to Balanced once you clear the Hold check box.

Balanced

This status indicates that the debit total of the batch equals the credit total and that the batch is ready to be released or posted. A balanced batch can be modified or deleted, but changes can be saved only if the batch credit and debit totals are equal.

Scheduled

This status indicates that the batch was attached to a schedule. Scheduled batches are used as templates for generating similar general ledger batches, with the dates calculated according to the schedule settings. The batch can be scheduled if its status is Balanced. A batch with a Scheduled status can be modified, but it can be saved only if the debit and credit totals are equal.

Unposted

This status indicates a balanced batch that was released but not yet posted. Such a batch cannot be edited or deleted.

Posted

This status indicates that batch journal entries were posted or were used for updating appropriate general ledger account balances. Posted batches cannot be modified or deleted; they are available only for viewing.

Void

This status indicates that this batch is invalid and was cancelled, for example, in cases when the batch was removed from the schedule before the schedule was completed. However, because it is needed for auditing, the batch cannot be deleted.

The date when the batch was created, which relates to the transaction dates of the journal entries as follows:

• For a manually created batch: All journal entries included in the batch have this transaction date specified in the Transaction date column in the table.
• For a batch generated automatically by a Visma Net workspace other than the General ledger: Each journal entry included in the batch can have its own transaction date specified in the Transaction date column of the Table area according to the transaction date specified in the corresponding workspace.

The financial period to which the transactions should be posted.

All transactions from a batch are posted to the same financial period. By default, the period is calculated based on the transaction date and the definition of financial periods, but the period can be changed. If the transaction date doesn’t match any financial period, an error message stating that the financial period is closed or does not exist in the system will appear, and you will not be able to save the batch.

The system supports posting to closed financial periods if the Allow posting to closed periods check box is selected in the General ledger preferences (GL102000) window. Closed financial periods do not appear in the list of financial periods, so a closed period can be entered only manually.

A check box that indicates (if selected) that the batch is auto-reversing.

For such a batch, the General ledger workspace automatically creates a batch that reverses the original debit and credit transactions into the next financial period (that is, the debit entry is reversed and becomes a credit entry, and the credit entry is reversed and becomes a debit entry).

Such batches are used to reverse period-end adjustments. A reversed batch will be created when the original batch is released or posted, depending on the value selected for the Generate reversing entries option in the General ledger preferences (GL102000) window.

The type of this general ledger batch, which is specified by the system automatically. A general ledger batch can be one of the following types:

Normal

The type of general ledger batch that either you create manually in the General ledger workspace, or the system creates automatically in any workspace of Visma Net once a document is released and posted to the General ledger. For example: When you release a supplier invoice in the Supplier ledger workspace, a general ledger batch of the Normal type is generated in the General ledger workspace.

Consolidation

The type of general ledger batch generated by the system once the process of importing the data from the consolidation units to the parent company is run. For details, see: General ledger consolidation overview.

Trial balance

The type of general ledger batch generated by the system when you release the trial balance entry in the Trial balance window. For details on importing the trial balances, see: Import trial balances - overview.

Reclassification

The type of general ledger batch generated by the system when you reclassify a general ledger transaction of the Normal type. For details on the reclassification process, see: About reclassifying general ledger transactions.

Allocation

The type of general ledger batch generated by the system when the allocation process is run. For details on the allocation process, see: About allocation rules.

A check box that indicates (if selected) that a VAT-related transaction can be created manually; select this check box when you begin to create the transaction. When you select this check box, the VAT ID and VAT category columns appear in the table area on this window.

If this check box is selected, the Skip VAT amount validation check box appears in the top part of this window.

Note that it is not possible to enter both purchase and sales VAT in the same batch, and VAT IDs having the artially deductible VAT set cannot be used.

A check box that (if selected) causes automatic validation of a VAT-related transaction that you create manually to be skipped. This check box appears only if the Create VAT transactions check box is selected in this window.

It is recommended that you leave this check box clear so the system performs VAT amount validation.

If the VAT amount validation is skipped (this check box is selected), the system does not warn you if the manually entered VAT amount does not match the taxable amount of a transaction, which may cause errors in the appropriate VAT report.

Opens the Reclassification history window for the selected transaction.

This button is available only if a reclassified transaction is selected in the table.

The account (associated with the specified branch) whose balance will be updated by the journal entry. If an account denominated to a foreign currency is specified, all other batch transactions should be in the same foreign currency.

NOTE: The account that is specified as the Year to date net income account in the General ledger preferences (GL102000) window cannot be used for direct updating by journal entries.

The particular task of the project with which this batch is associated.

This column appears only if the Projects workspace has been enabled and integrated with this workspace.

The reference number of the external or internal document associated with the journal transaction.

Journal entries related to the same document should have the same reference number specified.

The documents reference numbers must be specified for VAT-related journal transactions. It is required because VAT and taxable amounts are reflected in the VAT reports only if they are linked to the corresponding documents.

If the reference number of the external document has been manually specified for a journal transaction, the document can only be opened if it originates from workspaces other than General ledger.

The VAT used to calculate the VAT amount; this column appears if the Create VAT transactions check box is selected in the top part. The VAT is entered automatically by the system when you select an account in the Account column (and the subaccount in the Subaccount column, if applicable) associated with a particular VAT.

You can overwrite the default value.

Note that a VAT ID having partially deductible VAT will not be available in this module, you have to use Purchase invoices (AP301000) or Transactions (CA304000) window.

The VAT category based on which the taxable amount is calculated; this column appears if the Create VAT transactions check box is selected in the top part of the window.

This VAT code is entered automatically by the system if you select an account in the Account column for which a particular VAT category has been defined in the Chart of accounts (GL202500) window.

You can change the default VAT code.

Note that a VATcategory having partially deductible VAT will not be available in this module, you have to use Purchase invoices (AP301000) or Transactions (CA304000) window.

The date when the transaction was generated, which the system fills in as follows:

• For a manually created batch: This is the date of batch creation as specified in the Transaction date field in the top part of the current window.
• For a batch generated automatically by an Visma Net workspace other than General ledger: This is the creation date that was defined for the transaction by the conventions of the functionality that generated this transaction.

The date specified in this column is used for the transaction in Visma Net reports.

The current status of the batch. The status defines what processing can be applied to the batch. The following options are available:

On hold

This status is usually assigned to newly created batches. You can add new documents to the batches with the On hold status. You can take the batch off hold only if all the included documents have all the required information.

Balanced

This status indicates that all the batch’s documents are valid or the documents have all the required information. A balanced batch can be modified or deleted, but changes can be saved only if the added documents are valid.

Released

This status indicates that all the listed documents were successfully generated.

A check box that indicates (if selected) that the batch has the On hold status and cannot be released.

You can deselect the check box only if the documents included in the batch are valid (have all the required information).

The financial period to which all the documents and transactions should be posted. All transactions from a batch are posted to the same financial period.

By default, the period is calculated based on the batch date and the definition of financial periods.

Nevertheless, you may specify other dates for particular documents or transactions included in the batch.

The currency used for all the journal transactions in the selected batch.

By default, this is the base currency defined for all branches in the Organisations (CS101500) window. However, it is possible to select a different currency by clicking the field.

The exchange rate of the document that is valid for the chosen document currency and the Transaction date as defined in the Currency rates (CM301000) window.

You can change the rate in the Rate selection dialog box which appears by clicking the exchange rate field.

View base / View currency

(button)

The batch’s control total, which is used for batch status validation. The batch can be posted, released, or scheduled only if this amount is equal to the Debit total and Credit total amounts.

To make this control unavailable, deselect the Validate batch control totals on entry check box under the Data entry section in the General ledger preferences (GL102000) window.

The reference number to be used for the generated document; the number is assigned as you specify a few values for the document, and it is reserved for the document until the actual document will be generated.

This number is generated according to the number series assigned to the selected type of documents.

The transaction code.

User-defined transaction codes are assigned to the document types available in Visma Net in the Voucher entry codes (GL106000) window.

The account that will be debited by the document or transaction amount.

The system fills in this field automatically according to the settings specified for a selected customer or supplier on the General ledger accounts tab in the Suppliers (AP303000) or the Customers (AR303000) window.

For example, on the General ledger accounts tab in the Suppliers (AP303000) window the following will be used:

• For the supplier invoice, an account specified in the Supplier ledger account field.
• For a prepayment document, an account specified in the Prepayment account field.

The subaccount to be used for the debit journal entry.

Inserted by the system automatically cording to the settings specified for a selected supplier or customer.

You can overwrite a default value manually.

The project with which this transaction is associated, or the code indicating that this batch is not associated with any project.

The Non-project code is specified in the Project accounting preferences (PM101000) window.

This column appears if the Projects check box is selected and enabled in the Enable/disable functionalities (CS100000) window.

The particular task of the project with which this batch is associated.

This column appears if the Projects check box is selected and enabled in the Enable/disable functionalities (CS100000) window.

An alphanumeric string of up to 10 characters used to identify the ledger.

Follow your company’s internal rules when naming ledgers. The ID, once specified, cannot be changed in the future.

A detailed ledger description. This alphanumeric string can be up to 30 characters.

> [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support

The type of balance in the ledger. Select one of the following predefined types:

Actual

A ledger of this type is updated through journal transaction posting. Journal transactions are organised in batches, and the double-entry bookkeeping rule is enforced for these batches. The system supports multiple actual ledgers in the General ledger workspace; however, journal transactions generated by other workspaces will be posted only to the default posting ledgers specified for each branch in the Inter-branch account mapping (GL101010) window.

Budget

A budget ledger is used to store budget information. You update this type of ledger directly in the Budget (GL302010) window. Entering journal transactions to a budget ledger is not allowed.

Reporting

A reporting ledger is used to store translated financial information. This option is available only if the Multi-currency accounting functionality has been activated.

Statistical

A statistical ledger is used to store statistical information. Ledgers of this type are updated through journal entries in the Journal transactions (GL301000) window.

A check box that you select to indicate that the system should automatically generate inter-branch transactions for this ledger to balance transactions for all branches involved.

This column is displayed only if the Inter-branch transactions functionality is enabled in the Enable/disable functionalities (CS100000) window, and is available for editing if the consolidated branch ( Consol. branch ) is specified.

A check box that specifies, if selected, that the ledger should be used as a source ledger for consolidation. Ledgers for consolidation have the Reporting balance type if they contain information translated from the base currency.

This column is available only if the General ledger consolidation check box is selected and enabled in the Enable/disable functionalities (CS100000) window.

• Without branches
• Without branches not requiring balancing
• With branches requiring balancing

The branch to which the transaction was posted.

This column is available only if the Multi-branch support functionality is enabled in the Enable/disable functionalities (CS100000) window.

The subaccount to which the transaction amount was posted.

This column is available only if the Subaccounts functionality is enabled in the Enable/disable functionalities (CS100000) window.

Opens the Load transactions dialog box.

In this dialog box, you can specify the selection criteria to load the required list of transactions to the window.

Opens the Find and replace dialog box.

In this dialog box, you can specify the original and reclassification parameters for the transactions.

This replacement will be applied to the bulk of transactions that match the specified original parameters.

Inserts a row under the one you have selected, in which you can specify the parameters to be used when the system splits the transaction.

This button is available only if you have clicked the row of an entry to be split in the table of the window.

The branch to which the transaction was posted.

This field is available only if the Multi-branch support functionality is enabled in the Enable/disable functionalities (CS100000) window.

The first account in the range of accounts.

For a transaction to be uploaded to the window, its account must be within the specified range of accounts.

The last account in the range of accounts.

For a transaction to be uploaded to the window, its account must be within the specified range of accounts.

The first subaccount in the range of subaccounts.

For a transaction to be uploaded to the window, its subaccount must be within the specified range of subaccounts.

This field is available only if the Subaccounts functionality is enabled in the Enable/disable functionalities (CS100000) window.

The last subaccount in the range of subaccounts.

For a transaction to be uploaded to the window, its subaccount must be within the specified range of subaccounts.

This field is available only if the Subaccounts functionality is enabled in the Enable/disable functionalities (CS100000) window.

The first financial period in the range of periods.

For a transaction to be uploaded to the window, its period must be within the specified range of periods.

The last financial period in the range of periods.

For a transaction to be uploaded to the window, its period must be within the specified range of periods.

The first date in the range of dates.

For a transaction to be uploaded to the window, its date must be within the specified date range.

The last date in the range of dates.

For a transaction to be uploaded to the window, its date must be within the specified date range.

The workspace where the transaction originated.

If you select a workspace, a transaction will be uploaded to the window only if it originated in this workspace.

The customer or a supplier specified in the transaction.

If you select a customer or supplier, a transaction will be uploaded to the window only if it is specified in the transaction.

The maximum number of the records to be selected from the database.

The default value is 999. The system selects 999 records from the database that matches the criteria, applies additional filters, if needed, and displays the list of records.

A button that closes the dialog box and loads transactions that match the specified criteria.

New transactions are added to the list of existing transactions (if any).

The branch of the original transaction.

This field is available only if the Multi-branch support functionality is enabled in the Enable/disable functionalities (CS100000) window.

The subaccount specified in the original transaction.

This field is available only if the Subaccounts functionality is enabled in the Enable/disable functionalities (CS100000) window.

The description of the original transaction. The system searches for the exact string that you enter in this field.

To find transactions with no descriptions, enter two quotation marks in this field. You can use the wild card characters (* or?) to perform flexible search.

The branch which should be specified in the reclassification transaction.

This field is available only if the Multi-branch support functionality is enabled in the Enable/disable functionalities (CS100000) window.

The subaccount that should be specified in the reclassification transaction.

This field is available only if the Subaccounts functionality is enabled in the Enable/disable functionalities (CS100000) window.

The arrow icon that identifies the new entry that has been added in the process of splitting the selected journal entry. Select the original entry to be split or the new entry that has been added in the process of splitting the selected journal entry.

This column appears only if you have split the selected journal entry.

The number of the generated reclassification batch.

This column appears once the selected journal entry has been reclassified split and processed.

The branch of the reclassified transaction. This field is available for editing.

If you change this parameter, the system selects the check box to indicate that this transaction will be reclassified.

This column is available only if the Multi-branch support functionality is enabled in the Enable/disable functionalities (CS100000) window.

The account of the reclassified or split transaction. This field is available for editing.

If you change this parameter, the system selects the check box to indicate that this transaction will be reclassified.

The subaccount of the reclassified or split transaction. This field is available for editing.

If you change this parameter, the system selects the check box to indicate that this transaction will be reclassified or split.

This field is available only if the Subaccounts functionality is enabled in the Enable/disable functionalities (CS100000) window.

The date of the reclassified or split transaction. This column is available for editing.

For the lines of the split transaction, this column is available for editing if the branch, account, or subaccount (if applicable) has been changed in the To branch, To account, or To subaccount columns.

A description of the reclassified or split transaction. You can enter an appropriate description. This field is available for editing.

For the lines of the split transaction, this column is available for editing if the branch, account, or subaccount (if applicable) has been changed in the the To branch, To account, or To subaccount columns.

This column appears when you click Split for the selected journal entry and is available for editing only for the new lines that have been added when splitting the selected journal entry.

The remaining amount that can be split from the original journal entry or the amount to be transferred from the original entry to a new entry (for a new line).

For the new entries, either positive or negative values can be specified in this column. Positive amounts will decrease the amount of the original entry. Negative amounts, which are highlighted in red, will increase the amount of the original entry.

The branch of the original transaction. This field is not available for editing.

This column is available only if the Multi-branch support functionality is enabled in the Enable/disable functionalities (CS100000) window.

The subaccount of the original transaction. This field is not available for editing.

This field is available only if the Subaccounts functionality is enabled in the Enable/disable functionalities (CS100000) window.

The frequency of batch generation. The following options are available, and the time-related ones are described in detail in the next section:

Daily

The batches should be generated daily or every x days.

Weekly

The batches should be generated once a week or every x weeks.

Monthly

The batches should be generated once per month or every x months.

By financial period

The batches will be generated only once per financial period or every x financial periods.

The identifier of the batch.

Clicking the link navigates to the Journal vouchers (GL304000) window and displays the details of the selected batch.

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.

Read-only. The type of the selected account.

For more information, see: About account types and classes.

Read-only. The class of the selected account.

For more information, see: About account types and classes

The data source of the row set. 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.

Initiates the renumbering of rows.

You can type numbering step and code length (up to 10) in the Set numbering step dialog box that opens. The system changes the row codes to comply with new settings.

The descriptive name of the row.

> [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support

The type of the row.

This property defines how the values in the row are calculated and whether the column will display any data.

Select one of the available options:

General ledger

Use this row type to select the source of the data to calculate the values in the row from the general ledger.

Caption

Use this row type to display the caption of the report in this row.

Line

Use this row type to display the continuous line in this row.

Total

Use this row type to exclude the subtotals from the value calculation for the row.

Header

Use this row type to display the report header in this row.

The value to be displayed in the row. You can create a formula to define the value and use parameters in the formula you define.

> [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support

The printing style to be used for this data row. The printing style parameters are defined in the Style dialog box, which you invoke by clicking the selector in the Style field.

For the description of this lookup, see the Style parameters section of Printing styles.

The way a source amount should be distributed between the destination accounts. The available options are as follows:

By percent

By percentages, with a total of 100 percent

By weight

By user-defined coefficients, with the total not defined

By destination account YTD

To year-to-date balances on the specified accounts

By destination account PTD

To period-to-date balances on the specified accounts

The status of the batch. By default, the status of an allocation batch is Balanced.

If an allocation batch was modified by a user, it can be saved only if the status remains Balanced.

Select the type of export you want to execute:

• Year balance (SIE type 1)
• Period balance (SIE type 2)
• Period balance for object (SIE type 3)
• Balance and transactions (SIE type 4)
• Transactions (SIE type 4)

When this check box is selected, only the accounts that have been used on the selected period will be exported.

If you have in the Export type field, selected Year balance (SIE type 1) then this field is not visible.

Select the period to which the selected type of export will be executed.

If you have in the Export type field, selected Year balance (SIE type 1) then this field is not visible.

Here you select the financial year from which the export will be executed.

If you have in the Export type field, selected Year balance (SIE type 1) then this field is visible.

The VAT type of the code.

The options are:

• Sales
• Purchase
• Both

The country code for the VAT code.

In this field you can see and add a value for a subaccount.

You configure the length, input mask, and segment structure of the identifier in the Segment keys (CS202000) window. While adding a value to each segment, you can use the validation function, which allows you to select a segment value from the list of existing ones.

For details, see: About account IDs.

A detailed description of the subaccount.

> [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support

Initiates the release process for the selected import record.

Only a balanced import can be released. As a result, the status of the import changes to Released.

The current status of the import record. The following options are available:

On hold

This status indicates that the import record is a draft and can be edited manually. While the status of an import is On hold, the import may contain error indications. When you clear the Hold check box for an import with this status, if the import contains no errors and its total debits equal its total credits, the system changes the status to Balanced.

Balanced

This status indicates that the import record is created and is ready to be released or posted. An import with this status can be modified or deleted, but changes can be saved only if the credit and debit totals for the import are equal.

Released

This status indicates that the import record has been released.

The total of the debit amounts for the import record (the sum of the debit totals of the asset and expense accounts).

The system calculates this value automatically.

The total of the credit amounts for the import record (the sum of the credit totals of the liability and income accounts).

The system calculates this value automatically.

The system calculates this value by using the type of the balance to be imported, normal or reversed; that is, the sign used to display the positive amounts of the credit totals of the liability and income accounts accounted for calculations.

For details, see: Import trial balances - overview.

Gives you the ability to select one of the following actions to be performed for the records:

Validate

Validates the selected records or all records if you click the Process or Process all button, respectively

Merge duplicates

Merges duplicates for the selected records or all records if you click the Process or Process all button, respectively

The status of the record. The following options are available:

New

Indicates that the record was just imported.

Validated

Indicates that the record was validated—that is, that the account and subaccount were mapped to the internal account and subaccount.

Error

Indicates that the record was not validated—that is, that either the account or the subaccount was not mapped to an internal account or subaccount.

Duplicate

Marks the records detected as duplicates.

The data source of the unit set. 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 descriptive name of the unit.

> [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support

The formulas to be used to calculate the values to be used in this unit.

> [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support

The type of document or transaction to be generated for the code. This list of document types that can be processed through document batches in each specific workspace is the following:

• General ledger: General ledger entry
• Supplier ledger: Purchase invoice, Quick payment (not in use), Payment, Credit adjustment, Purchase credit note, or Prepayment
• Customer ledger: Sales invoice, Cash sale, Credit note, Debit note, Payment, or Prepayment
• Cash management: Cash entry

The numbering ID of the Number series (CS201010) window, which you can select by clicking the icon. The selected numbering ID processes the consecutive numbering of the transactions of the entry code it is assigned to. You find the assigned number in the Ref.no. column in the Journal transactions (GL301000) window

Note. Numbering ID is only available for general ledger transactions

By selecting the check box, the respective Unique trans. code is set as default for the General Ledger entry transaction type.

You find the unique transaction code in the Trans. code field in the Journal transactions (GL301000) window.

Note. Default transaction code is only available for general ledger transactions.

The workspace where the transaction originated.

This column is displayed for the selected range of days or periods, there are transactions originating in other workspaces that updated the balance of the selected account.

A field where you search and select the account class to which the account is assigned.

Account classes are used for grouping, sorting, and filtering of the information associated with General ledger accounts in reports and inquiries.