AICS Research

Official Check
Transmission
Report

Last updated:

February 15, 1999
Summit Spectrum 28.13
Report highlights

This report produces a detail list of all official checks issued, void or stopped on a date specified by the user. These checks are written into a KSAM database. The database is then read to produce a detail report for accounting, which is used to balance that day's activity. A file is also created that is transmitted to Travelers Express in the format specified by them.

This report has been automated to run each night without input or interference from an operator. In this way, the report is printed and waiting on the department printer when employees come in in the morning. A template is provided to allow the report to be run after corrections have been made.

Files included
  • OfCheckW - QueryCalc worksheet
  • OfCheckM - QueryCalc macro
  • OfCheckR - ASCII file which stores the report date
  • TOfChec1 - template which runs the macro
  • Readme.txt - a text file of instructions
Databases accessed
  • CHECKS - Spectrum Image Database
  • OFCLCHK-PRDB - KSAM Database created by QueryCalc
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).

Transmission. This report creates a file formatted for transmission to Traveler's Express. If you use a different check vendor, the layout may have to be modified.

QC Reports   QueryCalc
     Top