The Payment Types form is accessed via Contract Administration / Miscellaneous Options / Payment Types and enables the set-up and editing of payment types.
This table contains all the valid payment types that can be entered into the Customer records (FC.custo) Contract Admin 1 Tab in fields INITIAL, REGULAR and RECHARGE. This shows how the customer pays for each of those types of invoices.
It also populates part of the Sales Invoice NL customer reference indicator field which aids the credit department in identification of the invoice type from the sales ledger transaction form with a payment type and date e.g. DD21, DD30, CH??, etc. Payment types are initially defined within this table and then held within the Contract Admin 1 Tab tab at customer level; this can be used to select individual documents for direct debit payment within a customer's account on specific days of the month. e.g. an initial rental invoice to be taken by direct debit on the 21st of the month would have a reference which started 001DD21.
It can then be used to select different invoice types for direct debit collections on specific dates for each customer rather than selecting all invoices for that customer and deleting those which should not be taken.
Note: This is so that the 4th, 5th, 6th and 7th characters in SL.trans.REFERENC can be read and for fleet invoices (SL.trans.TRUEMOD = FC) only select transactions in which (POS(YFL=SL.accts.BACS) not equal 0) and str(SL.trans.REFERENC,6,4) = DD01. The numeric portion is variable and should be part of the prompt mechanism. For non fleet invoices (SL.trans.TRUEMOD not equal FC) and fleet invoices where str(SL.trans.REFERENC,4,2) = " " the selection criteria should revert to the BACS selection criteria on the account header.
Note2 : The first character within this field is the Invoice Type.
The form is split into three areas. These are the Titlebar, the Payment Types 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 current payment types. Each Payment Type record row contains the following fields:
A four character Payment Type code e.g. DD25.
The associated payment type description. This is a thirty character user-defined meaningful textual field e.g. Direct Debit 25th.
The list displays up to a maximum of twenty five payment type records at any one time. To view the remaining records (if applicable) the Scroll Bar to the right of the form can be operated in a number of ways:
To edit the payment type record table a single-right-click of the mouse in any of the columns displays a small menu box with the following options:
- Edit Row
Enables the payment type values for the selected row to be edited.
- Copy
Enables the payment type values for one record to be copied to other records.
- Filter
Presents a Selection Criteria Box which enables selection of only those records meeting the selection criteria for the selected column upon which the filter is selected to operate. 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.
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 Payment Types form and returns to the Miscellaneous Options Menu.
Provides online access to a context sensitive Help form.
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.
Redisplays the records on the form with any new modifications.
A checkbox that, when ticked, automatically redisplays all records on the form after an amendment.
Restricts a Sort by allowing entry of a text string for the agreement number from which to start.
Restricts a Sort by allowing entry of a text string for the agreement number at which to finish.
The purpose of this field 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.
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 each field in a record by row, with the field name in the left-hand column and the field data in the right hand column. Within this option, records may be created, amended or deleted.