IdealWare Online Users ManualDC4-03 D/C MAINTENANCE |
┌────────────────────────────────────────────────────────────────────────────────â”
│Oct16/07 THE IDEAL COMPUTER GROUP INC. │ │ CHEQUE FORMAT - BANK MAINTENANCE │ │ │ │ BANK CODE: _____ │ │ │ │ 1. CONTROL# PREFIX │ │ 2. LAST CONTROL# │ │ 3. CHEQUE FORMAT │ │ *** MICR CHEQUE'S ONLY *** │ │ 4. MICR FORMAT │ │ 5. BANK NAME │ │ 6. BANK ADDRESS │ │ 7. BANK ADDRESS │ │ 8. BANK ADDRESS │ │ 9. AUX ACCOUNT# │ │ 10. BANK TRANSIT# │ │ 11. BANK ACCOUNT# │ │ │ │ │ │ │ │ │ │ENTER THE BANK ACCOUNT CODE; │ │PRESS F5 FOR FORMAT INQUIRY, F6 FOR BANK ACCOUNT INQUIRY. │ │ │ └────────────────────────────────────────────────────────────────────────────────┘ |
Enter bank code for cheques to format.
If you enter a bank code with no associated cheque format the following prompt displays.
[Enter] to associate a cheque format.
The program steps you through each field. See FIELDS - FORMAT ASSOCIATION.
[F2] to not associate cheque format.
If you enter a bank code with an associated cheque format you are prompted to modify or delete the bank options associated with the format. See PROCEDURE - MODIFY/DELETE FORMAT ASSOCIATION.
[F2] to display the next bank code and format.
[F4] to exit to menu.
[F5] to display list of defined formats for selection.
[F6] to display list of bank codes for selection.
PROCEDURE - MODIFY/DELETE FORMAT ASSOCIATION
When you display a bank code with an associated cheque format you are prompted to modify or delete the association. To modify or delete cheque formats see PROCEDURE - FORMAT CODE MAINTENANCE.
Enter the field number to modify.
[Enter] to clear the display.
"B" to print a blank cheque with next sequential cheque number.
The print selection menu displays. After printing the blank cheque the display is cleared and you are returned to the BANK CODE field.
"D" to delete association with the format.
"Y" to delete association.
"N" to not delete association.
"T" to print a test pattern.
The print selection menu displays. After printing the test pattern the display is cleared and you are returned to the BANK CODE field.
[F2] to display the next bank/format association on file.
[F7] to access bank positive pay maintenance.
See PROCEDURE - BANK POSITIVE PAY MAINTENANCE.
After modifying any of the fields #3 - #11 the following prompt displays.
Enter the number of field to modify.
[Enter] when modifications complete.
[Enter] to update the file.
[F4] to cancel all changes.
You are returned to the BANK CODE field where you can enter another bank code or press [F4] to exit the program.
Example Cheque Format - Bank Maintenance Screen display:
┌────────────────────────────────────────────────────────────────────────────────â”
│Oct17/07 THE IDEAL COMPUTER GROUP INC. │ │ CHEQUE FORMAT - BANK MAINTENANCE │ │ │ │ BANK CODE: TD1G GENERAL BANK (CDN. FUNDS) - TORONTO-DOMINION BANK │ │ │ │ 1. CONTROL# PREFIX C │ │ 2. LAST CONTROL# 24162 │ │ 3. CHEQUE FORMAT TD GENERAL ACCT (CDN) - TD BANK │ │ *** MICR CHEQUE'S ONLY *** │ │ 4. MICR FORMAT │ │ 5. BANK NAME │ │ 6. BANK ADDRESS │ │ 7. BANK ADDRESS │ │ 8. BANK ADDRESS │ │ 9. AUX ACCOUNT# │ │ 10. BANK TRANSIT# │ │ 11. BANK ACCOUNT# │ │ │ │ │ │ │ │ │ │ │ │** FIELD# TO MODIFY; 'D'=DELETE; 'B'=BLANK; 'T'=TEST; CR TO CONTINUE: __ │ │ F7=POSITIVE PAY MAINTENANCE │ │ │ └────────────────────────────────────────────────────────────────────────────────┘ |
FIELDS - FORMAT ASSOCIATION
Enter bank code for cheques to format.
If you enter a bank code with no associated cheque format the following prompt displays.
[Enter] to associate cheque format.
The program steps you through each field.
[F2] to not associate cheque format.
If you enter a bank code with an associated cheque format you are prompted to modify or delete the bank options associated with format. See PROCEDURE - MODIFY OR DELETE FORMAT ASSOCIATION.
[F4] to exit to menu.
[F5] to display list of defined formats for selection.
[F6] to display list of bank codes for selection.
Enter the control number prefix up to 2 characters.
Typically, the prefix is used to identify the bank account. In cases where you have multiple checkable accounts with the same bank, use the first character to identify the bank and the second character the a account. For example T1, T2, T3, etc.
[Enter] to accept displayed value.
[F2] for none or to clear the field.
Enter the last cheque number printed for the account.
The program will use the next sequential number as the next cheque number. If you use preprinted cheques, you can reset the cheque numbering by entering the number previous to the first number on the new cheques.
[Enter] to accept displayed value.
[F2] to set the control number to "000000".
Enter desired format code for bank account.
[Enter] to accept displayed value.
[F1] to access cheque format code maintenance.
Access maintenance if you want to define a new format code or modify an existing format. See PROCEDURE - FORMAT CODE MAINTENANCE.
[F5] to display list of format codes for selection.
*** MICR CHEQUE'S ONLY ***
The following fields are applicable only to MICR cheque formats. If you would like to use MICR cheque printing, please talk to your Ideal consultant. In addition to appropriate printer hardware, some setup is required.
Enter MICR cheque format to use.
[Enter] to accept displayed value.
[F2] for preprinted cheques.
This nulls the field. When you use preprinted cheques the magnetic ink coding is already imprinted on the cheque forms.
[F5] to display list of MICR cheque formats for selection.
Enter the name of the bank to print on cheque.
[Enter] to accept name associated with the bank code.
[F2] to clear the field.
Enter first line of bank address to print on cheque.
[Enter] to accept displayed value.
[F2] to clear the field.
Enter second line of bank address to print on cheque.
[Enter] to accept displayed value.
[F2] to clear the field.
Enter third line of bank address to print on cheque.
[Enter] to accept displayed value.
[F2] to clear the field.
Enter any related auxiliary bank account number.
[Enter] to accept displayed value.
[F2] to clear the field.
Enter bank transit number.
[Enter] to accept displayed value.
[F2] to clear the field.
Enter bank account number.
[Enter] to accept displayed value.
[F2] to clear the field.
PROCEDURE - FORMAT CODE MAINTENANCE
At the cheque format/bank maintenance screen, when you select field #3 - CHEQUE FORMAT you have the option of pressing [F1] to access format code maintenance, where you can modify existing cheque formats and add new formats. The maintenance screen is displayed and cursor is positioned in the FORMAT CODE field.
Enter format code to display definition.
If you enter an existing format code the definition is displayed and you have the option of modifying or deleting it. If you enter a code for which no definition exists you are prompted to add a new definition.
[Enter] to add the code.
The program steps you through each field of the format definition. See FIELDS - FORMAT DEFINITION.
[F2] to not add the code.
[Enter] to view format definition of displayed code.
[F2] to display the next definition.
[F5] to display list of format codes for selection.
Example Format Code Maintenance Screen display:
┌────────────────────────────────────────────────────────────────────────────────â”
│Oct18/07 THE IDEAL COMPUTER GROUP INC. │ │ CHEQUE FORMAT - BANK MAINTENANCE │ │ │ │ FORMAT CODE: TD │ │ │ │ 1. DESCRIPTION GENERAL ACCT (CDN) - TD BANK │ │ 2. REQUIRED CPI 10 │ │ 3. CHEQUE WIDTH 80 │ │ 4. LINES PER CHEQUE 21 │ │ 5. STUB OPTION A │ │ 6. LINES PER STUB 42 │ │ 7. SECOND STUB Y │ │ 8. MAIN STUB SUMMARIZED N │ │ 9. DATE FORMAT 2 MMDDYYYY │ │ 10. PRINT DATE INDICATOR Y │ │ 11. PRINT $ BEFORE AMOUNT Y │ │ 12. SINGLE OR DOUBLE DENSITY S │ │ │ │ │ │ │ │ │ │ │ │** FIELD# TO MODIFY; 'D'ELETE; CR TO CONTINUE: __ │ │ F5=DISPLAY; F6=REMITTANCE MAINTENANCE; F7=FIELD POSITION MAINTENANCE. │ │ │ └────────────────────────────────────────────────────────────────────────────────┘ |
Enter the field number to modify.
[Enter] to clear the display.
"D" to delete the format code.
"Y" to delete the code.
"N" to not delete the code.
[F5] to display the format.
See sample cheque format following. Press [Enter] to close the sample display and return to the maintenance screen.
[F6] to access remittance maintenance.
See PROCEDURE - REMITTANCE MAINTENANCE.
[F7] to access field position maintenance.
See PROCEDURE - FIELD POSITION MAINTENANCE.
FIELDS - FORMAT DEFINITION
Enter a format description of up to 30 alphanumeric characters.
[Enter] to accept displayed value.
[F2] to clear field.
Enter required CPI.
[Enter] to accept displayed value.
Enter the cheque width in characters.
This value is based on the CPI entered in field #2.
[Enter] to accept displayed value.
[F2] to clear field.
Enter the maximum lines that can print on cheque.
This value is based on the CPI entered in field #2.
[Enter] to accept displayed value.
[F2] to clear field.
"A" to print cheque stub after cheque.
"B" to print cheque stub before cheque.
"N" to not print a stub.
[Enter] to accept displayed value.
[F2] to clear field.
Enter the maximum lines that can print on stub.
This value is based on the CPI entered in field #2.
[Enter] to accept displayed value.
[F2] to clear field.
"A" to print 2nd cheque stub after cheque.
"B" to print 2nd cheque stub before cheque.
"N" to not print a 2nd stub.
[Enter] to accept displayed value.
[F2] to clear field.
"Y" to summarize stub.
"N" to print details on stub.
[Enter] to accept displayed value.
"1" for YYYYMMDD.
"2" for MMDDYYYY.
"3" for DDMMYYYY.
"N" for MonDD/YY.
[Enter] to accept displayed value.
"Y" to print date indicator on cheque.
"N" to not print date indicator on cheque.
Select this option with preprinted cheques with a date indicator.
[Enter] to accept displayed value.
"Y" to print $ before cheque numeric amount.
"N" to not print $ before cheque numeric amount.
Select this option with preprinted cheques with a $ preceding cheque numeric amount.
[Enter] to accept displayed value.
"S" for single density printing.
"D" for double density (bold) printing.
[Enter] to accept displayed value.
[Enter] to accept changes and update definition.
[F4] to cancel all changes.
PROCEDURE - FIELD POSITION MAINTENANCE
Select [F7] at format code maintenance to display the field position maintenance screen.
Example Field Position Maintenance Screen displays:
┌────────────────────────────────────────────────────────────────────────────────â”
│Oct19/07 THE IDEAL COMPUTER GROUP INC. │ │ FIELD POSITION MAINTENANCE │ │ │ │ FORMAT CODE: TD │ │ │ │ ******** CHEQUE ******** POSITION LINE NUMBER │ │ │ │ 1. CONTROL NUMBER 70 2 │ │ 2. DATE 65 4 │ │ 3. PAY TO 6 10 │ │ 4. NUMERIC AMOUNT 65 8 │ │ 5. ALPHA AMOUNT 5 7 │ │ 6. REGARDING 8 13 │ │ 7. BANK NAME 40 1 │ │ 8. FIRM NAME 5 1 │ │ 9. SIGNATURE 40 14 │ │ │ │ │ │ │ │ │ │ │ │ │ │** ENTER CORRECTION NUMBER: __ │ │ F5=DISPLAY CHEQUE FORMAT; CR=CHEQUE FORMAT MAINTENANCE. │ │ │ └────────────────────────────────────────────────────────────────────────────────┘ |
Enter the field number to modify.
[Enter] to return to cheque format maintenance.
[F5] to display the format.
See sample cheque format following. Press [Enter] to close the sample display and return to the maintenance screen.
FIELDS - FIELD POSITION
Each of the fields #1-#9 controls the placement of one information item on the cheque. Fields are positioned by the number of characters from the left margin and the number of lines down from the top of the form.
When editing an existing format, press [F2] to clear a field and [Enter] to accept the displayed value. When you have completed making your changes press [Enter] to display the confirmation prompt.
[Enter] to accept changes and update.
You are returned to the format maintenance screen where you can press [F5] to view the cheque and stub format.
[F2] to make additional changes.
[F4] to cancel all changes.
PROCEDURE - REMITTANCE MAINTENANCE
Select [F6] at format code maintenance to display the remittance maintenance screen.
Example Remittance Maintenance Screen display:
┌────────────────────────────────────────────────────────────────────────────────â”
│Oct18/07 THE IDEAL COMPUTER GROUP INC. │ │ REMITTANCE FORMAT MAINTENANCE │ │ │ │ FORMAT CODE: TD │ │ │ │ *** REMITTANCE HEADER *** POSITION LINE NUMBER │ │ 1. PRINT STUB HEADINGS Y │ │ 2. CONTROL LINE 0 1 │ │ 3. SUPPLIER LINE 1 1 PRINT NAME AND CODE │ │ 4. CONTROL NUMBER 64 1 │ │ 5. DATE 71 1 │ │ 6. PAGE 44 1 │ │ *** REMITTANCE DETAIL *** │ │ 7. HEADINGS LINE 0 3 │ │ 8. FOLIO# 31 3 │ │ 9. TRX. DATE 1 3 │ │ 10.REFERENCE 11 3 │ │ 11.GROSS 41 3 │ │ 12.DISCOUNT 56 3 │ │ 13.BALANCE 69 3 │ │ 14.LAST LINE FOR TOTALS 0 15 │ │ 15.SPECIFIC TOTAL LINE 0 0 │ │** ENTER CORRECTION NUMBER: __ │ │ F5=DISPLAY CHEQUE FORMAT; CR=CHEQUE FORMAT MAINTENANCE. │ │ │ └────────────────────────────────────────────────────────────────────────────────┘ |
Enter the field number to modify.
[Enter] to return to cheque format maintenance.
[F5] to display the format.
See sample cheque format following. Press [Enter] to close the sample display and return to the maintenance screen.
FIELDS - REMITTANCE FORMAT
You have the option to print or not print the remittance stub headings. The "control line" is the line where the headings print if you choose to print headings. Typically, this is the top line of the remittance stub.
Each of the fields #3-#15 controls the placement of one information item on the remittance stub. Fields are positioned by the number of characters from the left margin and the number of lines down from the top of the form. When editing an existing format, press [F2] to clear a field and [Enter] to accept the displayed value. When you have completed making your changes press [Enter] to display the confirmation prompt.
[Enter] to accept changes and update.
You are returned to the format maintenance screen where you can press [F5] to view the cheque and stub format.
[F2] to make additional changes.
[F4] to cancel all changes.
PROCEDURE - BANK POSITIVE PAY MAINTENANCE
The A/P and demand cheque printing systems now allow positive pay bank transfers and cheque history recording. Positive pay is a service that many banks offer to integrate cheque printing with cheque reconciliation. When you print your cheques, you transfer information about the cheques to the bank based on what is set in this maintenance program.
In addition, the A/P and demand cheque systems now share the same cheque format programs and files; and MICR printing is available in the A/P cheque printing system. Bank positive pay requires appropriate parameter settings to work. If you would like to utilize this feature, please talk to your Ideal consultant.
When you select [F7] at the main prompt the bank positive pay maintenance screen displays.
BANK POSITIVE PAY MAINTENANCE DISPLAY
┌────────────────────────────────────────────────────────────────────────────────â”
│Oct17/07 THE IDEAL COMPUTER GROUP INC. │ │ BANK POSITIVE PAY MAINTENANCE │ │ │ │ BANK CODE: TD1G │ │ │ │ │ │ │ │ 1. POSITIVE PAY CODE │ │ 2. POSITIVE PAY LOGIN ID │ │ 3. WORK DIRECTORY │ │ 4. TRANSFER PROGRAM │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │** ENTER CORRECTION NUMBER: __ │ │ PRESS CR TO RETURN TO BANK MAINTENANCE. │ │ │ └────────────────────────────────────────────────────────────────────────────────┘ |
Enter the field number to modify.
[Enter] to clear the display and return to cheque format/bank maintenance screen.
FIELDS - BANK POSITIVE PAY
Enter positive pay bank code.
[Enter] to accept displayed value.
[F5] to display list of bank codes for selection.
Enter the positive pay login sequence.
[Enter] to accept displayed value.
Enter the full path to the working directory.
[Enter] to accept displayed value.
Enter the full path to the transfer program.
[Enter] to accept displayed value.
Example Bank Positive Pay Maintenance Screen Display:
┌────────────────────────────────────────────────────────────────────────────────â”
│Oct03/07 DEMO COMPANY │ │ BANK POSITIVE PAY MAINTENANCE │ │ │ │ BANK CODE: CN │ │ │ │ │ │ │ │ 1. POSITIVE PAY CODE NATIBANK │ │ 2. POSITIVE PAY LOGIN ID abcdefg │ │ 3. WORK DIRECTORY /tmp │ │ 4. TRANSFER PROGRAM pwd │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │** OK TO UPDATE? (ENTER TO UPDATE; F2 TO MODIFY; F4 TO BYPASS; F5 TO DISPLAY): │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────────┘ |
[Enter] to update changes to file.
[F2] to modify additional fields.
[F4] to cancel all modifications.
[F5] to display is disabled.
A sample cheque and stub format follow.
Oct18/07 THE IDEAL COMPUTER GROUP INC. CHEQUE FORMAT - BANK MAINTENANCE 1" 2" 3" 4" 5" 6" 7" ONNNNNNNN0NNNNNNNNN0NNNNNNNNN0NNNNNNNNN0NNNNNNNNN0NNNNNNNNN0NNNNNNNNN0NNNNNNNNN, _ _ _ 999999 _ _ _ _ MonDD/YY _ _ _ _ _ _ NINE MILLION NINE HUNDRED AND NINETY NINE THOUSAND _ _ NINE HUNDRED AND NINETY NINE DOLLARS AND 99 CENTS $99,000,000.00_ _ _ _ MR. AND MRS. JOHN DOE _ _ _ _ _ _ _ _ _ _ _ ** 'F2'=NEXT 15 LINES; PRESS ENTER TO CONTINUE: _ Oct18/07 THE IDEAL COMPUTER GROUP INC. CHEQUE FORMAT - BANK MAINTENANCE 1" 2" 3" 4" 5" 6" 7" ONNNNNNNN0NNNNNNNNN0NNNNNNNNN0NNNNNNNNN0NNNNNNNNN0NNNNNNNNN0NNNNNNNNN0NNNNNNNNN, _ _ PAYEE NAME (PAYEE) BANK: CONTROL: MonDD/YY_ _ _ SEQ# DUE DATE DESCRIPTION AMOUNT _ XXX MonDD/YY XXXXXXXX XXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX -999999.99 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ ** 'F1'=UP 15 LINES; PRESS ENTER TO CONTINUE: _