AICS Research


Update MICR
Report


Last updated:

February 15, 1999
Summit Spectrum 28.13

Report highlights

MCU uses the MICR number to process ACH transactions, so it is important that accounts which are allowed to have ACH activity have the correct MICR number input in the SHCH screen. It would be possible to allow the member service representatives to input this number when they opened the account. First they would have to perform a CKDG to calculate the correct check digit for the account, write it down, and then input it into the correct field on the SHCH screen. No huge task, but it would take time and there would be an element of human error involved that could allow someone's payroll to get posted to the wrong person's account.

The solution was in this worksheet. A detail report finds share accounts that have blank MICR numbers. The correct MICR number is calculated (using the MOD 10 check digit routine), and the appropriate string input is created. An override string is also created in case there are restrictive flags on the account. The report is printed to disk, and afterward, when the credit union is open and Test Control is available, the disk file is copied into Test Control. Test Control processes the data just as if it were being entered into a teller terminal (only much, much faster).

The worksheet is all that is necessary to create the report. However, it has been automated to run each night without input or interference from an operator. In this way, the entire process is automatic and does not require human intervention.


Files included
  • ChgMicrW - QueryCalc worksheet
  • ChgMicrM - QueryCalc macro
  • ChgMicrJ - job which runs the macro
  • Readme.txt - a text file of instructions

Databases accessed
  • MEMBRS - Spectrum Image Database

Special Requirements

PostScript printer. In order to print the report to the PostScript form provided, you must have a PostScript printer. If you do not have a PostScript printer, you will need to edit the layout page(s).

MOD 10 Check digit. The calculations provided assume the use of the MOD 10 check digit routine. If you use a different routine, the formulas will have to be adjusted.

Test Control. The changes are processed using Summit's test control device. If you are not familiar with this process, contact Summit support.

QC Reports   QueryCalc

     Top