Cheque Format Parameters
The Cheque Format Parameters allows you to define to the system the exact format of your cheque. This is done in the form of five record types defining the following:
General cheque size parameters (Form Width and Length, Stub First or Last)
Cheque stub banner size – Number of banner print lines
Cheque stub detail line size - Prints invoice detail lines
Cheque stub total line size- Total lines
Cheque body parameters size
General Cheque Size Parameters
Form Width
Enter the maximum number of columns for your cheque. The width represents the number of characters per inch that will print. For example if the printable area of your form is 8 inches wide and you are printing 10 characters per inch, your form width would be 080, or printing 12 characters per inch your form width would be 096. The maximum width is 132 columns.
# Of Lines on Cheque
Enter the number of lines to be printed on the entire cheque. For example a 7" form set to print 6 lines per inch would contain 42 lines. NOTE: The number of lines entered for the Stub; detail, banner and totals and the cheque body Must equal the total number of lines on the cheque.
The Stub of the cheque is defined as the part of the cheque that contains all the detail information. The Body of the cheque is the actual cheque.
# Of Lines on Stub – detail
Enter the number of print detail lines to be printed on the stub of the cheque. This is the portion of the cheque that contains the detail invoice information.
# Of Lines on Stub – banner
Enter the number of banner print lines to be printed on the stub of the cheque. The banner is the portion of the cheque that contains heading information.
# Of Lines on Stub – totals
Enter the number of total lines to be printed on the stub of the cheque. The total is the portion of the cheque that contains the total information.
# Of Lines on Cheque Body
Enter the number of print lines contained in the body of the cheque. This portion is the actual cheque.
Cheque Stub First or Last
Enter 'F' if the stub is to be printed before the cheque or enter 'L' if the stub is to be printed after the cheque.
On-Line Cheque Print Device
Enter the printer device that will be used for printing immediate cheques. Note: This field must be filled in, even if you are not printing on-line cheques. Entry of TT: would be sufficient.
Next | Select Next to accept the general cheque parameters and proceed to the Cheque Form Definition Screen. |
Cancel | Select Cancel to exit the program. |
Modify | Select Modify to modify any of the general cheque parameters. |
Restore | Select Restore to reload the last saved cheque format. |
Cheque Print Profile Form Definition Screen
The Cheque Print Profile Form Definition Screen allows you to define the titles and fields you wish printed on the cheque. Use your cursor keys to move around the form. Note the section displayed in the upper left corner and the current position displayed in the upper right corner. If your cursor is positioned on a field, the field definition will be displayed in the Field Definition Window at the bottom of the screen.
Enter a title type in the text at the position you wish it to appear. This screen is a full functioning editor. Use the backspace key to delete text and the space bar to insert a space. The following key definitions are also helpful.
<TAB> Moves 8 spaces to the right
<F1><LEFT ARROW> Moves to the first column of the current line
<F1><RIGHT ARROW> Moves to the last column of the current line
<F1><UP ARROW> Moves to the first line of the current screen
<F1><DOWN ARROW> Moves to the last line of the current screen
<INSERT> Insert a blank line above the current line
To enter a field, move the cursor to the desired location and press <Insert> to insert a new field.
You can move fields around by using the cut and paste options.
Cancel | Select Cancel to return to the Cheque Form Definition Screen. |
Insert | Select Insert to define a new field for the form. You will proceed to the Field Definition window. |
Modify | Select Modify to modify the field currently displayed in the Field Definition window. |
Delete | Select Delete to delete the field currently displayed in the Field Definition window. |
Cut | Select Cut to delete the field currently displayed in the Field Definition window from the form and save it in the past buffer. |
Paste | Select Paste to add the field currently saved in the paste buffer to the form. |
Field Definition Window
Field definition
If you are in Insert mode, a window will appear allowing you to select from a list of valid fields. I
Size
Enter the size of the field. The default will be the actual size of the field as stored in the file.
Mask
A window will appear displaying valid masks. Select a mask from this list or select User Defined Mask if you wish to enter a mask of your own.
LEFT JUSTIFIED | Displays the field left justified |
RIGHT JUSTIFIED | Displays the field right justified |
DATE | Displays field as a date. Format depends on field size specified |
(ie., size = 8 = YYYYMMDD) | |
INTEGER | Displays the field as an integer |
FLOATING POINT | Displays field as a floating point number formatted to 2 decimals |
(ie., ###.##) | |
USER DEFINED | specify your own mask |
(ie., #,###,###<###) |
Once the field is defined, the mask will appear on the Cheque Print Format Form Definition Screen.
Save | Click Save or ALT + S to save the cheque print profile entered and exit the program. |
Cancel | Click Cancel or ALT + C to exit the program without saving the profile. |
Valid Field Names
Generally speaking the valid field names may be broken into the following categories:
I - Data contained on the individual invoice record
V - Data contained on the vendor record
C - Data contained on the cheque record
T - Stub totals
W - Work variables
FIELD Name | Size | DESCRIPTION |
|---|---|---|
I-DATE | 9 | Invoice date prints DD-MM-YYYY. ie. December 1, 1999, prints 01-DEC-99 |
I-DAYDATE | 2 | The day portion of the I-DATE field |
I-MONTHDATE | 2 | The invoice portion of the I-DATE field |
I-N_MONTHDATE | The invoice printed in numeric i.e. DEC=12 | |
I-F_YEARDATE | 4 | The invoice year printed in numeric (e.g. 2005) |
I-YEARDATE | 2 | The year portion of the I-DATE field |
I-AMOUNT | 8 | The invoice amount |
I-DISCOUNT | 8 | The invoice discount amount |
I-NET | 8 | The invoice amount less the discount. (Also used for partial payments) |
I-DESC$ | Prints up to 150 characters of descriptive data (does word wrap & handles hard carriage returns in the desc area | |
I-REFERENCE$ | 1-50 | The first 50 characters of the invoice reference |
I-REFERENCE1$ | 1-50 | Characters 51-100 of the invoice reference data |
I-REFERENCE2$ | 1-50 | Characters 101-150 of the invoice reference data |
I-PONUMBER$ | 10 | Purchase order number to which the invoice was applied |
I-INVNUMBER$ | 14 | The invoice number |
I-BATCHNUMBER$ | 10 | The batch number where the invoice was entered |
I-BATCHYPP$ | 3 | The period number portion of the batch number |
I-BATCHTYPE$ | 3 | The batch type portion of the batch number |
I-PBATCHSEQ$ | 2 | The batch sequence number portion of the batch number |
I-BATCHER$ | 2 | The entry serial number portion of the batch number |
I-AUTHNUMBER$ | 4 | Payment authorization number (customers using manual cheque numbering) |
T-GROSS | 8 | Total of all invoice amounts on the stub |
T-DISCOUNT | 8 | Total of all discount amounts on the stub |
T-NET | 8 | Total of all net amount on the stub |
C-AUTHNUMBER$ | 4 | The authorization/accounts payable run (APR) number |
C-BANKNO$ | 4 | The bank number of the cheque |
C-MICR_NUMBER$ | 10 | The MICR number of the cheque |
C-NUMBER$ | 10 | The cheque number |
C-AMOUNT | 8 | The cheque amount in numeric |
C-WORDAMT$ | The cheque amount in word format | |
C-DATE | 11 | Cheque date prints DD-MMM-YYYY. ie. December 1, 1999 prints 01-DEC-1999 |
C-DAYDATE | 2 | The day portion of the C-DATE field |
C-MONTHDATE | 2 | The month portion of the C-DATE field |
C-N_MONTHDATE | The month printed in numeric is DEC-12 | |
C-YEARDATE | 2 | The year portion of the C-DATE field |
C-F_YEARDATE | 4 | The year of the cheque (e.g. 2005) |
C-DATE-YMD | 8 | The cheque date (e.g. 20051031) |
C-DATE-MDY | 8 | The cheque date (e.g. 10312005) |
C-DATE-DMY | 8 | The cheque date (e.g. 31102005) |
C-DATE-YMD-DBL | 15 | The cheque date spaced (e.g. 2 0 0 5 1 0 3 1) |
C-DATE-MDY-DBL | 15 | The cheque date spaced (e.g. 1 0 3 1 2 0 0 5) |
C-DATE-DMY-DBL | 15 | The cheque date spaced (e.g. 3 1 1 0 2 0 0 5) |
V-NUMBER$ | 10 | Vendor number |
V-Name$ | 1-40 | Vendor name |
V-ADDRESS1$ | 1-30 | First address line. |
V-ADDRESS2$ | 1-30 | Second address line |
V-ADDRESS3$ | 1-30 | Third address line |
V-CITY_A4$ | 1-25 | City |
V-PROV_A4$ | 2 | Province |
V-CTRY_A4$ | 3 | Country |
V-CITYPROV_A4$ | 1-27 | Will print as City, Province |
V-CITYPROVCTRY_A4$ | 1-30 | Will print as City, Province, Country |
V-CITYPROVCODE_A4$ | 1-40 | Will print as City, Province, Postal/Zip Code |
V-POSTALCODE$ | 1-10 | Postal/Zip code |
V-POSTAL_ADDRESS$ | 1-40 | Placing a block of 5 lines of this field will logically format the vendor address with the block. Compressing blank lines & formatting address according to postal standards |
V-ALT_LOCATION$ | 4 | Alternate vendor location code |
V-ALT_LOCATION_DESC$ | 30 | Alternate vendor location |
C-AUTHNUMBER$ | 4 | Payment authorization number |
C-BANKN0$ | 4 | Bank number of the accounts payable run |
W-LITERAL | 1-30 | Whatever is printed in the print mask field will be printed on the cheque |
W-DOLLARS$ | 1-30 | Will print the dollar portion of the cheque amount |
W-CENT$ | 1-2 | Will print the cent portion of the cheque amount |
J-ACCOUNT$ | 1-20 | Prints GL account number for each account charged on an invoice. These features available to Montana customers only |
J-AMOUNT | Prints the amount for each GL account charged on the invoice. Features available to Montana customers only |