Documentation >
MAC-PAC Technical Library >
Manufacturing >
Inventory Control >
Programs >
Cycle Count Performance Report - Purpose >
Cycle Count Performance Report - Calculations
Cycle Count Performance Report - Calculations
IC620E
A. Housekeeping
1. See Common Processing Routines - Housekeeping in this manual for a general discussion of this subroutine. Processing specific to this program is described below.
2. The Company Name (COMNAM) is retrieved from the System Control file (CT100M).
3. The date format record (category 049) is retrieved from the Reference file (REFERP).
4. The applications installed record (category 012) is retrieved from the Reference file (REFERP).
B. Mainline
This program prints a report for each request code record in the IC Transaction file. The transaction record contains the option selection code (1-4) which is used to determine the type of report to be printed. When a report has been printed for one transaction record, the next request code transaction record is read until the end of the file.
1. Option 1: All company/warehouses - All ABC classes
a. The Warehouse Description file is read. For each warehouse, all warehouse balance records are sequentially read and processed.
b. If any filters are specified in the request code transaction record, the information from the warehouse balance record is checked against these filter values.
c. Failure to pass one or both specified filters causes the report line for that warehouse balance record to be bypassed. A report line is printed only if all specified filters are passed.
d. This process is repeated until all warehouse description records are read.
2. Option 2: All company/warehouses - One ABC class
a. The Warehouse Description file is read. For each warehouse, all records from the specified ABC class in the Warehouse Balance file are sequentially read and processed.
b. As in Option 1, filters are checked if they are specified in the request code transaction record. The report line is printed or bypassed accordingly.
c. This process is repeated until all warehouse description records are read.
3. Option 3: One company/warehouse - All ABC classes
a. The specified warehouse record is read from the Warehouse Description file.
b. All records from the Warehouse Balance file corresponding to the specified warehouse are sequentially read and processed.
c. As in Option 1, filters are checked if they are specified in the request code transaction record. The report line is printed or bypassed accordingly.
d. Only one warehouse description record is read.
4. Option 4: One company/warehouse - One ABC class
a. The specified warehouse record is read from the Warehouse Description file.
b. All records from the Warehouse Balance file corresponding to the specified warehouse number and ABC class are sequentially read and processed.
c. As in Option 1, filters are checked if they are specified in the request code transaction record. The report line is printed or bypassed accordingly.
d. Only one warehouse description record is read.
5. For each warehouse balance record, the Year-to-Date Activity value and Year-to-Date Adjustment value are calculated from Year-to-Date quantities and the part's standard cost.
If overflow occurred when calculating the Year-to-Date amounts, a warning message is written to the report. This will indicate that amounts printed in the report might have been truncated due to overflow.
6. The inventory accuracy is calculated for each part and for the requested company/warehouse.
7. The reports are sent to the output queue requested at the time CHANGE PRINTER key is pressed and a valid OUTQ is entered. If no output queue was specified, the reports are sent to the system output queue (QPRINT).