MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Technical Library > Manufacturing > Inventory Control > Programs > Cycle Count Schedule/Worksheet Generation - Purpose > Cycle Count Schedule/Worksheet Generation - Calculations

Cycle Count Schedule/Worksheet Generation - Calculations

IC230E

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 System Control file (CT100M) is accessed to retrieve the manufacturing Company Name (COMNAM) and the Lot Control Option (LOTOPT). 

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 to check whether the Job Control module is installed.  If Job Control is installed, the job/group number is printed on the worksheet.

B.   Mainline

1.   The statistics report fields are cleared.  The Inventory Control Report Request Transaction file (IC225AL) is read sequentially until all R60 transactions are read.

2.   For each transaction, the Warehouse Description file (IC170M) is read and the Warehouse Balance file (IC140ML6) is set to the beginning of the records for the transaction warehouse (CWHNO).

3.   Each warehouse balance record is checked to determine whether it meets the cycle count priority parameters.  The Cycle Count Part Selection flag (WBCCPS) is updated accordingly.  This field can have values of 0 through 6 and determines why a part should be cycle-counted.  The field may have one of the following values:

1 - Manual
2 - Control
3 - Overdue
4 - Currently Due
5 - Negative Balance
6 - Zero Balance

4.   The Cycle Count Schedule Statistics report (IC230A) is printed, showing totals for each category and year-to-date information.

5.   The Warehouse Balance file (IC140ML6) is reset and read sequentially.  Part descriptions and unit of measure are retrieved from the Part Master (DE100M).

6.   Multiple Location (IC130ML6) information is retrieved to write a Schedule Generation Workfile record (T0517) for each location of parts scheduled for cycle counting.

7.   Workfile records are written until cycle count capacity is reached or the file is ended.

8.   If over capacity, the Warehouse Balance file (IC140ML6) is continued to be read, printing records for the Cycle Count Schedule Exceptions report (IC230B).

9.   The Cycle Count Schedule (IC230C) is printed, in either part or location sequence, using the data from the Schedule Generation Workfile (IC230AL or IC230AP).

10.  The printer file is assigned to the proper output queue defined on the Warehouse Description file (IC170M).

11.  The date of previous cycle count interval field on the Warehouse Description file (IC170M) is updated.

12.  The record from the IC Report Request Transaction file (IC225AL) is deleted.

IC230E Program Menu