The Finance Repayments Sequencing form is accessed via Contract Administration / Batch Control / Finance Sequencing. This option enables viewing and editing of the batch order sequence (for subsequent processing by the system) for all batches. It also provides an additional way for batches to be toggled between "live" (denoted by a tick) and "not live" (denoted by a blank field).
The form is split into three areas. These are the Titlebar, the Finance Repayments Sequencing Record Table and the column of Command Buttons at the bottom of the form.
In addition to displaying the form name the Title Bar provides a number of useful buttons.
This form displays a record table of all the fields held within the four tabs of the Finance Repayment Batching form.
To view the Allocation Sequence field first select the Grid command button. From the new display of buttons select the Field command button. This presents a Field Selection List Box containing the following fields from which to select:
- FORMAT (Print Format)
- FREQENCY(Release Frequency)
- HOUSE(Finance House 1 - 20)
- INVCTYPE(Invoice Types)
- INVNO(Invoice Number)
- LEASETYP(Lease Type 1 - 20)
- LIVE(Live Batch Control)
- NAME(Description)
- RELEASE(Next Release Date)
- SEQUENCE(Allocation Sequence)
- SUPPREF(Invoice Reference)
- TYPE(Type Code)
To view the Allocation Sequence and/or Live status for all batches, highlight and confirm the SEQUENCE option and LIVE option with a double-click of the mouse (This operation can be performed for a number of fields at the same time by double-clicking on each required field to be viewed) and select the OK command button.
The list displays up to a maximum of twenty five finance batch records at any one time. To view the remaining records the Scroll Bar to the right of the form can be operated in a number of ways:
A number of command buttons are available. Some buttons are context sensitive and are greyed-out and only become available dependent upon the particular process that is being accessed. The full list of command buttons is as follows:
Exits the Finance Repayment Sequencing Records form and returns to the Batch Control Menu.
Provides online access to a context sensitive Help form.
Selection of this button displays a further form that provides an Ad-hoc Report Generator for the creation of quick query reports to form. An enquiry is formulated by completing a simple set of verbs and field names. A saved formulated query can be retrieved for future use.
Displays all records. Each field for the record is displayed in the appropriate row with the code displayed in the left-hand column and the field data in the right hand column(s). Selection of this command button makes available several alternative command buttons not available within Column mode:
- Refresh
Redisplays the records on the form with any new modifications.
- Autorefresh
A checkbox that, when ticked, automatically redisplays all records on the form after an amendment.
- Fields
The purpose of this command button is to allow the display of a user-defined selection of fields for every record. This is intended to reduce data entry errors. This operation can be performed for one field or a number of fields at the same time by double-clicking on each required field to be viewed and selecting the OK command button.
- Column
Displays one record at a time. Within this option, records may be created, amended or deleted.
Whilst within Grid mode, the record table may be edited with a single-right-click of the mouse in either of the columns which then displays a small menu box with the following options:
- Edit Row
Allows the values within the finance batches to be edited. Alternatively, single-left-click into the row, enter the appropriate data and use the Tab key to move to the next column.
- Insert Row
Inserts a blank row above the selected record so that a new finance batch code /description may be added.
- Delete Row
Deletes the selected finance batch code record.
- Copy
Enables the finance batch values for one record to be copied to other records to speed data entry.
- Filter
Presents a Selection Criteria Box which enables selection of only those records meeting the selection criteria. The following mutually exclusive selection criteria option buttons/fields are available:
- Equals
Searches the selected column for a description matching that entered in the data entry box at the bottom of the form. Any records equaling the criteria are displayed.
- Not Equal
Searches the selected column for a description matching that entered in the data entry box at the bottom of the form. Any records equaling the criteria are not displayed.
- Greater Than
Searches the selected column for any records with a text character string which is alphabetically higher than the character(s) entered in the data entry box at the bottom of the form. Any records greater than the criteria are displayed.
- Less Than
Searches the selected column for any records with a text character string which is alphabetically lower than the character(s) entered in the data entry box at the bottom of the form. Any records less than the criteria are displayed.
- Contains
Searches the selected column for any records with a text character string containing the character(s) entered in the data entry box at the bottom of the form. Any records meeting the criteria are displayed.
- Range
Searches the selected column for any records with a text character string which is alphabetically equal to or between the character(s) entered in the two data entry box at the bottom of the form. Any records meeting the criteria are displayed.
- No Filter
No filter is applied to the record search. The Reset command button also activates the "No Filter" option.
Sorts the records by the chosen keypath. Upon selection, a Keypath List Box is displayed from which the appropriate keypath (if there is more than one) is selected.
A checkbox that, when ticked, sorts the records in descending order.
Restricts a Sort by allowing entry of a text string from which to start.
Restricts a Sort by allowing entry of a text string at which to finish.
Enables the creation of an additional Finance Batch record.
Deletes the currently selected Finance Batch record.
On first accessing the Finance Repayment Sequencing form this command button is greyed-out. Following selection of the Amend button the Cancel option then becomes available to enable any edits to be cancelled.
Saves the current record.
Displays the next Finance Batch record.
Displays the previous Finance Batch record.