A batch with On hold status cannot be released or posted.

You can give a batch this status by selecting the Hold check box in the Journal transactions (GL301000) window. The On hold status is usually assigned to a newly created batch if further editing is planned.

Also, if after being edited, a batch becomes out of balance, it can be saved as On hold. If a batch that’s on hold has total debits equal to total credits, you can change its status to Balanced once you clear the Hold check box.

To have the On hold status assigned by default to all batches on their entry, select the Hold batches on entry check box in the General ledger preferences (GL102000) window.

The Balanced status indicates that the batch’s debit total equals its credit total and the batch can be released or posted. You can modify or delete a balanced batch, but you can save changes only if the batch’s credit and debit totals remain equal.

To have the Balanced status assigned by default to all entered batches, clear the Hold batches on entry check box in the General ledger preferences (GL102000) window.

The Scheduled status indicates that the batch was attached to a schedule. A scheduled batch is used as a template for generating similar general ledger preferences batches with 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 its debit and credit totals are equal.

The status of a batch will change to Void if the batch is deleted from the schedule. A scheduled batch can be fully deleted only if the schedule was never executed and no ordinary general ledger preferences batches were generated in accordance with it.

Identifies the columns to be included in the analytical report. This is a mandatory attribute for the analytical report.

For more information about the column sets, see Column sets - overview.

Identifies the columns to be included in the analytical report. This is a mandatory attribute.

For details about the row sets, see About row sets.

Identifies the units used to compose the analytical report. Use units to describe the structure of complex reports, such as the reports composed from several sections or including different views of data. Units present the dimensions of data in the analytical report.

For more information about the unit sets, see Unit sets - overview.

Specifies the text describing the content analytical report. Depending on the report structure, a row header or a column header can be used to specify the header for analytical report.

The report header can be defined as a header for the column set selected for the report, or as the row header having the appropriate style.

Specifies the data filtering criteria on the report level. The data can be filtered using various criteria including groups of accounts and subaccounts, specific periods, and totals calculation method.

For information about the data filtering criteria, see About data filtering criteria.

Allow for setting up the page layout including the report page and margins sizes, selecting the font attributes (the font name, size, style, and colour), and setting the text align and background colour attributes for the text lines in the report.

The formatting parameters defined for the whole report include setting the report attributes for the page formatting, and defining the printing style for the report text. For more information about the printing style, see Printing styles.

Can be set for any particular row in the report to visually emphasise it. These parameters include text align, font name, size, style and colour, and background colour attributes. Additionally, the separation lines can be included in the report by adding the rows having an underline type.

The formatting parameters defined on the row level include setting the row attributes for the row formatting, and defining the printing style for the text in the row. For more information about the row attributes, see About row attributes.

Can be set for any particular column in the report to visually emphasise it. These parameters include text align, font name, size, style and colour, and background colour attributes.

The formatting parameters defined on the column level include setting the column attributes for the column formatting, and defining the printing style for the text in the column. For more information about the column attributes, see Column attributes.

The code of the current account (if the Account option is selected in the Expand field in the Data source editor).

The code of the current subaccount (if the Sub option is selected in the Expand field in the Data source editor).

The description of the current account (if the Account option is selected in the Expand field in the Data source editor).

The description of the current subaccount (if the Sub option is selected in the Expand field in the Data source editor).

The last account group in the range of account groups used in the report. Refers to the value in the End account field in the Default data source section section.

Note: This parameter is valid only in the reports of the PM type.

The last project in the range of projects used in the report. Refers to the value in the End project field in the Default data source section section.

Note: This parameter is valid only in the reports of the PM type.

The last project tasks in the range of the project tasks used in the report. Refers to the value in the End task field in the Default data source section section.

Note: This parameter is valid only in the reports of the PM type.

The first account group in the range of account groups used in the report. Refers to the value in the Start account field in the Default data source section section.

Note: This parameter is valid only in the reports of the PM type.

Adds the value of one numeric expression to another or concatenates two strings.

Example: =A10+B10

Here, A10 and B10 are cell references. If the values in the cells are 12.85 and 2.25, the result of the expression would be 12.85 + 2.25 = 15.1.

Subtracts the value of one numeric expression from another.

Example: =A20-B30

Here, A20 and B30 are cell references. If the values in the cells are 12.85 and 2.25, the result of the expression would be 12.85 - 2.25 = 10.6.

Multiplies the value of two expressions.

Example: =C10*D10

Here, A20 and B30 are cell references. Assuming that the parameters have the values C10 = 2.25 and D10 = 2, the example would evaluate to 2.25 * 2 = 4.5.

Divides the values of two expressions.

Example: =A10/C10.

Here, A10 and C10 are cell references. If the values in the cells are 4.0 and 2.0, the result of the expression would be 4.0 / 2.0 = 2.0.

Divides two numbers and returns only the remainder.

Example: =B15 % C15

Here, B15 and C15 are cell references. If the values in the cells are 15.0 and 6.0, the result of the expression would be 3.0.

Performs logical conjunction on two Boolean expressions. If both expressions evaluate to True, then the operator returns True; if either or both expressions evaluate to False, And returns False.

Example: =(A10>0) And (C10>0)

In this example, A10 and C10 are cell references. If A10 = 10 and C10 = 20, then the expression would evaluate to True. Alternatively, f A10 = -10 and C10 = 20, the expression would evaluate to False.

Performs logical disjunction on two Boolean expressions. If either expression evaluates to True, the operation returns True; if neither expression evaluates to True, Or returns False.

Example: =(A10>0) Or (C10>0)

In this example, A10 and C10 are cell references. If A10 = 10 and C10 = 20, then the expression would evaluate to True. Alternatively, f A10 = -10 and C10 = -20, the expression would evaluate to False.

Performs logical negation on a Boolean expression, yielding the opposite of the expression it evaluates. If the expression evaluates to True, the operator yields False; alternatively, if the expression evaluates to False, Not yields True.

Example: =Not (A10>C10)

In this example, A10 and C10 are cell references. If A10 is larger than C10, then the expression would evaluate to False. Alternatively, if A10 is smaller than C10, the expression would evaluate to True.

Equality operator.

Example: =(A10=B10)

In this example, A10 and B10 are cell references. If the value in the A10 cell is equal to the value in C10, then the expression evaluates to True, otherwise the expression evaluates to False.

Inequality operator.

Example: =(C10<>A10)

(where A10 and C10 are the links used as a formula parameters)

In this example, A10 and C10 are cell references. If the value in the A10 cell is not equal to the value in B10, then the expression evaluates to True, otherwise the expression evaluates to False.

The less than operator.

Example: =(@10<@12) (where @10 and @12 are the links to cells in the current column)

In this example, @10 and @12 are the links to cells in the current column. If the value in the A10 cell is not equal to the value in B10, then the expression evaluates to True, otherwise the expression evaluates to False.

Greater than operator.

Example: =(C10>A10) (where A10 and C10 are the links used as a formula parameters)

In this example, A10 and C10 are cell references. If the value in the A10 cell is not equal to the value in B10, then the expression evaluates to True, otherwise the expression evaluates to False.

The less than or equal to operator.

Example: =(C10<=A10) (where A10 and C10 are the links used as a formula parameters)

In this example, A10 and C10 are cell references. If the value in the A10 cell is not equal to the value in B10, then the expression evaluates to True, otherwise the expression evaluates to False.

The greater than or equal to operator.

Example: =(A10>=A10) (where A10 and C10 are the links used as a formula parameters)

In this example, A10 and C10 are cell references. If the value in the A10 cell is not equal to the value in B10, then the expression evaluates to True, otherwise the expression evaluates to False.

This operator is used in an elementary logical expression that evaluates the search results and returns True when the parameter matches one of the elements from the set of values.

Example: =(A20 In (10, 50, 57)) (where A20 is the link used as a formula parameter)

This operator is used as a parameter in logical expressions.

Example: =((D30<A30)=True) (where D30 is the link used as a formula parameter)

This operator is used as a parameter in logical expressions.

Example: =((C10=E10)=False) (where C10 and E10 are the links to the data)

This operator is used as a parameter in logical expressions.

Example: =(@20=Null) (where @20 is the cell in the current column and 10th row)

Converts an expression defined in a function argument into the Boolean expression. If the expression is zero, False is returned; otherwise, True is returned.

Example: =CBool(A11+B11-C11*0.05) (where A11, B11 and C11 are the links used in a function argument)

Converts an expression defined in a function argument to a value of the Date type. The CDate function argument should be a valid date expression. CDate recognises date formats according to the locale setting of the system.

Example: =CDate(A2-B2) (where A2 and B2 are the links used in a function argument)

Converts an expression defined in a function argument to a string. If the CStr function argument equals null, CStr returns a run-time error; otherwise, it returns a string of characters.

Example: =CStr(A12) (where A12 is the link used in a function argument)

Converts an expression defined in a function argument to a value of the Double type.

Example: =CDbl(A12/B2) (where A12 and B2 are the links used in a function argument)

Converts an expression defined in a function argument to a value of the Single type. If the expression defined in the function argument lies outside the acceptable range for the Single type, an error occurs.

Example: =CSng(A12) (where A12 is the link used in a function argument)

Converts an expression defined in a function argument to a value of the Decimal type.

Example: =CDec(A12*0.15) (where A12 is the link used in a function argument)

Converts an expression defined in a function argument to a value of the Integer type.

Example: =CInt(A10) (where A10 is the link used in a function argument)

Converts a numeric value to a value of the Short type.

Example: =CShort(B2) (where B2 is the link used in a function argument)

Converts a numeric value to a value of the Long type.

Example: =CLong(B12) (where B12 is the link used in a function argument)

Removes all leading spaces or parsing characters from the specified character expression, or all leading zero bytes from the specified binary expression.

Example: =LTrim(CStr(A12)) (where A12 is the link used in a function argument)

Removes all trailing spaces or parsing characters from the specified character expression, or all trailing zero bytes from the specified binary expression.

Example: =RTrim(CStr(A12)) (where A12 is the link used in a function argument)

Removes all trailing spaces or parsing characters from the specified character expression, or all trailing zero bytes from the specified binary expression.

Example: =Trim(CStr(A12)) (where A12 is the link used in a function argument)

Replaces the format item in a specified formatting string ( format ) with the text equivalent of the arguments ( arguments ).

Example: =Format('Currency:........ {0:C}; Account:........ {1:N}', A1, B1) (where A1 and B1 are the links used as a function arguments; 0, 1 are the specifiers indicating where the arguments will be inserted; C is the currency format specifier; and N is the number format specifier)

Returns a string that has been converted to upper case. The string argument is any valid string expression. If string contains a null value, the null value is returned.

Example: =UCase(CStr(A12)) (where A12 is the link used in a function argument)

Returns a string that has been converted to lower case. The string argument is any valid string expression. If string contains a null value, the null value is returned.

Example: =LCase(CStr(A12)) (where A12 is the link used in a function argument)

Returns the position of the first occurrence of one string ( findString ) within another ( string ).

Example: =InStr(CStr(A12), 'rur') (where A12 is the link used in a function argument)

Returns the position of the last occurrence of one string ( findString ) within another ( string ), starting from the right side of the string.

Example: =InStrRev(CStr(A12), 'rur') (where A12 is the link used in a function argument)

Returns an integer containing either the number of characters in a string or the nominal number of bytes required to store a variable.

Example: =Len(CStr(A12)) (where A12 is the link used in a function argument)

Returns a string containing a specified number of characters from the left side of a string. If string contains the null value, the null value is returned.

Example: =Left(CStr(A12), 3) (where A12 is the link used in a function argument)

Returns a string containing a specified number of characters from the right side of a string. If string contains a null value, the null value is returned.

Example: =Right(CStr(A12), 3) (where A12 is the link used in a function argument)

Returns a string in which a specified sub string ( oldValue ) has been replaced with another sub string ( newValue ).

Example: =Replace(CStr(A12), 'rur', 'eur') (where A12 is the link used in a function argument)

Right-aligns the characters in a specified string ( string ), padding with the specified characters ( paddingChar ) on the left for a specified total width ( width ).

Example: =PadLeft(CStr(A12), 3, '%') (where A12 is the link used in a function argument)

Left-aligns the characters in a specified string ( string ), padding with the specified characters ( paddingChar ) on the right for a specified total width ( width ).

Example: =PadRight(CStr(A12), 3, '%') (where A12 is the link used in a function argument)

Returns the absolute value of a number.

Example: =Abs(A10-B10)

Here A10 and B10 are the links used in a function argument.

Returns the largest integer that is not greater than the argument.

Example: =Floor(A10-A12)

Here A10 and A12 are the links used in a function argument.

Returns the smallest integer that is not less than the argument.

Example: =Ceiling(A10-C11)

Here A10 and C11 are the links used in a function argument.

Returns a numeric expression, rounded to the specified precision ( decimals ).

Example: =Round((A10-B12), 5)

Here A10 and B12 are the links used in a function argument, and 5 is the number of digits after the decimal separator.

Returns the smaller of the two values.

Example: =Min(A10, A12) =Min(A10, 12)

Here A10 and A12 are the links used as function arguments)

Returns the greater of the two values.

Example: =Max(A12, A14) =Max(A12, 240)

Here A12 and A14 are the links used as function arguments.

Computes the value of x raised to the specified power ( power ).

Example: =Pow((A12, 2))

Here A12 is the link used as a function argument, and 2 is the power index.

Returns the current date and time according to the system date and time on the local computer.

Example: =Now()

Returns the current date according to the system date and time on the local computer.

Example: =Today()

Returns the current date and time according to the user’s time zone.

The system gets the user’s time zone from the following sources, which are ordered by the priority from the highest to the lowest:

1. User’s preferences specified in the User settings (SM203010) window.
2. The employee calendar specified in the Work calendar (CS209000) window and selected for the user’s employee in the Employees (EP203000) window.

Example: =NowUTC()

Returns the current date according to the user’s time zone.

The system gets the user’s time zone from the following sources, which are ordered by the priority from the highest to the lowest:

1. User’s preferences specified in the User settings (SM203010) window.
2. The employee calendar specified in the Work calendar (CS209000) window and selected for the user’s employee in the Employees (EP203000) window.

Example: =TodayUTC()

Returns the new date calculated as a date parameter to which the specified time interval has been added.

The interval argument is a string expression that is the interval to be added. This argument can have the following values:

yyyy

year (a number of years will be added to a date )

m

month (a number of months will be added to a date )

y

day of year (same as day )

d

day (a number of days will be added to a date )

h

hour (a number of hours will be added to a date )

n

minute (a number of minutes will be added to a date )

s

second (a number of seconds will be added to a date )

The number is the numeric expression that is the number of intervals to be added. The numeric expression can either be positive, for dates in the future, or negative, for dates in the past. The date argument is the date to which interval is added.

Example: =DateAdd(CDate('31/01/1995'), 'm', -2) =DateAdd(Today(), 'y', 3) =DateAdd(Now(), 'd', 1)

Returns the year component of the date.

Example: =Year(Now())

Returns the month component of the date.

Example: =Month(Now())

Returns the day component of the date.

Example: =Day(Now())

Returns the day of week for a date.

Example: =DayOfWeek(Today())

Returns the day of the year for a date.

Example: =DayOfYear(Now())

Returns the minutes for a date.

Example: =Minute(Now())

Returns the second component of the date.

Example: =Second(Now())

Returns one of two values, depending on the evaluation of an expression. If the expression evaluates to True, the function returns the truePart value; otherwise, it returns falsePart value.

Example: =IIf((A10-B10)<>0), CStr(A12), 'No data available') (where A10, A12, and B10 are the links used as a function arguments)

Returns one of the values, depending on the evaluation of the expressions in the parameter. The function returns the value_n, which corresponds to the first expression in the enumeration that evaluates to True.

Example: =Switch(((A10-B10)<>0), A12, ((A10-B10)>0), B35)

Returns nullValue, if value is NULL; otherwise, returns value.

Example: =IsNull(A10, '0') (if A10 is NULL, returns 0, otherwise returns the A10 value)

Returns the sum of the values in the specified interval.

Example: =Sum('A11','A100') (where A11 and A100 are the links used in a function argument)

Returns the values in the specified range of rows in the specified column sorted in ascending order.

Example: Sort('0100','0145','B') (the values in rows from ‘0100’ to ‘0145’ in the ‘B’ column will be sorted in ascending order)

Returns the values in the specified range of rows in the specified column sorted in descending order.

Example: SortD('0100','0145','B') (the values in rows from ‘0100’ to ‘0145’ in the ‘B’ column will be sorted in descending order)

Specifies the margin size settings for the report page, which can be set in pixels, points, picas, centimetres, millimetres, or inches.

Left

Specifies the size of the left margin of the report page.

Top

Specifies the size of the top margin of the report page.

Bottom

Specifies the size of the bottom margin of the report page.

Right

Specifies the size of the right margin of the report page.

Determines the size of the report page, which can be set in pixels, points, picas, centimetres, millimetres, or inches.

Width

Specifies the report page width.

Height

Specifies the report page height.

With this field, you can select which control account module you want to perform reconciliation on.

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

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

The alternatives are:

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

The company you want to filter on. If no company and branch are selected, you will get the sum of all companies.

This field indicates which control account module is selected for this reconciliation batch.

The alternatives are:

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

A statement of all transactions made in the General ledger at the time given in the field Last period.

The link will open the window General ledger details.

By clicking Release/post, you will release marked documents. Only documents with the error message Not released in General ledger or Not posted in General ledger will be processed.

The button is only active if you have selected the Discrepancy category Unposted/Unreleased.

Filter on Company.

The column is only visible if you have activated multi-branch.

Filter on Branch.

The column is only visible if you have activated multi-branch.

Filtering different categories of discrepancies.

• UnPosted/Unreleased [1,2,21]
• Manually entered [22]
• GL Transactions do not exist [0]
• AR Transactions do not exist [20,22]
• Amount mismatch [3,4,5,6]
• Other work spaces [22]
• Different branches [23]
• Reversed batch [24]
• Deleted documents [25]

[NN] The numbers correspond with the Discrepancy category (in the top part), see information in the Discrepancy column in the table.

Filter on From period.

The period is suggested from Reconciled financial period in General ledger preferences and, if that is empty, it will suggest the first open period from Financial periods.

Filter on Account.

You can only select accounts defined as Control account module for customers and suppliers.

Filter on Customer.

Select the customer you wish to filter upon.

This is the Note from the transaction.

If the line contains a General ledger transaction, it will be the note you see or can edit and if the line only contains a Customer transaction, it will be the invoice note that will shown and can be edited.

A check box that, when selected, indicates that the transaction is hidden.

To hide or unhide, you can select the line and click the Hide/Unhide button. You hide transactions when you have found a matching correction transaction, so you do not need to check them again.

Discrepancy types:

1. The General ledger transaction does not exist.

2. The General ledger transaction is not released.

3. The General ledger transaction is not posted.

4. The Currency ID does not match.

5. The Currency rate does not match.

6. The invoice ledger currency sum does not match.

7. General ledger currency sum.

8. The invoice ledger amount does not match General ledger amount.

9. The Branch ID does not match.

10. The invoice does not exist.

11. The invoice has not been released.

12. The General ledger transaction is directly entered.

13. The General ledger account is used in another module.

[99] the number exists in the database text, so it can be used in Generic queries

The difference between Customer ledger amount and General ledger amount.

(General ledger amount - Customer ledger amount)

The window where the customer document was created.

The screen ID will tell you what window the document was created in. (00000000 = created by API).

The window where the customer document was last edited.

The screen ID will tell you what window the document was modified in. (00000000 = created by API).

The window where the GL Batch was created.

The screen ID will tell you what window the document was created in. (00000000 = created by API).

The window where the customer document was last edited.

The screen ID will tell you what window the document was modified in. (00000000 = created by API).

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.