Recurring transactions (GL203500)

This topic gives you information about the elements that you find in this window in Visma.net ERP, such as fields, field values, buttons, and check boxes.

You can use this window to create and maintain scheduled batches. Also, you can view the details of active and completed schedules.

Schedules are used to automatically generate recurring batches, such as loan-related journal entries recording monthly paid interest or principal amounts or both.
A schedule defines how many times and how often specific batches should be repeated.

One or several batches of the Normal type and the Balanced status can be assigned to a schedule.
Once a batch is assigned to a schedule, its status changes to Scheduled.
The system uses the original batches as templates to generate similar batches with transaction dates generated based on how you define the schedule.
Only batches originated in the General ledger can be scheduled.

For user reference, you can attach to a schedule a scanned image (or electronic version) of the related contract or another document that is the basis for the schedule you have created.

For more information on recurring batches, see: About recurring journal transactions and Schedule a recurring batch.

If you are in the list window, the first line in the table is a search line. Each column has a search field which you can click to search for or filter on specific values and narrow down the displayed table rows. You can search and filter in as many columns as you need to, to only display the results you want to view.

There are two types of search fields:

  • White: here you can type a specific search term to display results in this column containing this exact value. If you search on several (partial) words, you can separate them by a space or % and get different results:

    • space: the result contains the words in any order,

    • %: the result contains the words in the specific order, and the % functions as a wildcard as well.

  • Grey: you can click this to open the column filter pop-up window where you can filter the results for this column.

The window toolbar includes standard and window-specific buttons.

Button Description
Run now Executes the schedule.

In the top part, you can create a new schedule or select any existing schedule for editing or deleting.

Element Description

Schedule ID

The ID of the schedule. The system assigns a new schedule's unique ID in accordance with the numbering series assigned to schedules in the General ledger preferences (GL102000) window.

Active

A check box that indicates (if selected) that the schedule is active. When the check box is cleared, the schedule cannot be used.

Start date

The start date for the schedule.

Expiration date

The date that, if set, indicates when the schedule expires (unavailable when the Never expires check box is selected).

Never expires

A check box that indicates (if selected) that no expiration date is set.

Execution limit (times)

The maximum number of times the schedule can be executed. This field is unavailable when the No limit check box is selected.

No limit

A check box that indicates (if selected) that the schedule should be continued into future financial periods.
Description A description for the schedule.

Last executed

A read-only field that displays the date when the batches were last generated, if applicable.

Next execution

A read-only field that displays the date when the schedule should be executed next, based on the schedule parameters.

Executed (times)

A read-only field whose value shows how many times the schedule was executed —that is, how many times batches were generated. A 0 here indicates that the schedule was not executed yet and no batches were generated.

Schedule type

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 everyx financial periods.

Enter the parameters described below, which depend on the schedule's type.

Element Description

Every x day(s)

An integer that specifies a time interval (in days) for batch generation.
For example: 1 would mean every day and 2 would mean every other day, starting on the Start date.
Element Description

Every x week(s)

An integer that specifies a time interval (in weeks) for batch generation, with the check boxes indicating the day of the week when the batches should be generated: Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, or Saturday.
Element Description

Every x month(s)

An integer that specifies a time interval (in months) for batch generation.
For example: A 3 here would generate the batch every three months.

On day

The day of the month for the batch.

On then th day of the week

This option includes an ordinal number in the left field that specifies the week in the month, and a day of the week in the right field, such as 2nd Thursday.
Element Description

Every x period(s)

An integer that specifies a time interval for batch generation, measured in financial periods.

Start of financial period

An option button that sets the start date of the financial period as the day when documents should be generated.

End of financial period

An option button that sets the end date of financial period as the day when documents should be generated.

Fixed day of the period

An option button that defines the particular day of the financial period when documents should be generated.

This tab includes the list of batches assigned to the schedule (in a tabular format). Each row displays details of the selected batch.

The table toolbar includes only standard buttons.

Column Description

Batch number

The reference number of the original batch, which is used as a template for scheduled batches.

Ledger

The default ledger to which the batch transactions should be posted.

Transaction date

The date of the batch transactions.

Post period

The financial period to which the batch transactions are to be posted.

Status

The status of the original batch.

Control total

The control total of the batch, which should be equal to both the credit and debit amounts of the batch.

Currency

The currency used for the batch transactions.

This tab contains the list of batches generated according to the schedule.

The table toolbar includes only standard buttons.

Column Description

Batch number

The ID number of the generated batch.

Ledger

The default ledger to which the batch transactions should be or were posted.

Transaction date

The date of the batch transactions.

Post period

The financial period to which the batch transactions should be or were posted.

Status

The status of the generated batch.

Control total

The control total of the batch, which is equal to both the credit and debit amounts of the batch.

Currency

The currency used for the batch transactions.

Parent topic:
General ledger windows - overview