Bucketing and Year-End Processing - Calculations

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 following information is obtained from the System Control file (CT100M).

a.   The Company Name (CONAME) is retrieved from the company name record (COMNAM).  If this record is not found, a warning message is sent to the system operator and processing continues.

b.   The month of the last audit trail and the beginning month/year of the fiscal period are retrieved from the Inventory Control control record (ICCTL1).  If this record is not found, a system abort occurs.

3.   The following information is retrieved from the Reference file (REFERP).

a.   The Date Format record (category 049) is retrieved.  If this record is not found, a message is sent to the operator, the date format defaults to MM/DD/YY, and processing continues.

b.   The Quantity Field Sizes record (category 446) record is retrieved to determine the number of decimal places.  If this record not found, a system abort occurs.

B.   Mainline

1.   The program performs year-end, month-end and daily routines, depending on the current run date.

2.   Year-End Processing.

a.   Year-end processing is initiated if the run date is equal to the Beginning month/year of the fiscal period and if the last audit trail occurred in the previous month.

b.   The Warehouse Description file is read sequentially.  The following year-to-date fields are reset to zero and the file is updated.

WDACY - Actual Counts YTD

WDDCY - Eligible Counts YTD

WDYSC - Scheduled Counts YTD

c.   For each Warehouse Description record, the program sequentially reads the Warehouse Balance file.  The following year-to-date fields on the Warehouse Balance file are reset to zero:

WBYTCC - Year-to-Date Cycle Counts

WBYTDA - Year-to-Date Adjustments

WBYTDD - Year-to-Date Dollar Activity

WBYTDU - Year-to-Date Activity

WBTAQ  - Absolute Adjustment Quantity

WBAADY - Year-to-Date Absolute Adjustment Dollar Value

d.   Activity buckets (WBDA01 to WBDA12) in the Warehouse Balance file are rolled.  WBDA11 is moved to WBDA12, WBDA10 is moved to WBDA11, etc. Zero is moved to WBDA01.

e.   The Warehouse Balance file is then updated.

f.    The current month/year is moved to the Beginning month/year (CCBDAT) on ICCTL1, and the System Control file is updated.

g.   Following year-end processing, daily processing is initiated.

3.   Monthly Processing.

a.   Monthly processing is initiated if the last audit trail occurred in the previous month and if it is not the beginning of a new fiscal year.

b.   The Warehouse Balance file is read sequentially.  The activity buckets are rolled as in year-end processing and the file is updated.

4.   Daily Processing.

a.   Daily processing is performed regardless of prior year-end or month-end processing.

b.   The logical Audit Trail Transaction file is read sequentially and only records with the following transaction codes are processed:
 

c.   Reversal transactions do not update the activity buckets.

d.   The transaction quantity is added to one of the Activity Buckets (WBDA01 to WBDA12) on the Warehouse Balance file depending on the difference between the run date and the transaction date.

e.   If year-end processing occurred, then the appropriate transaction quantity is added to Year-To-Date Activity quantity field (WBYTDU) and the Activity Amount is added to the Year-To-Date Activity amount field (WBYTDD).

f.    If the year-end processing occurred, and CZTRAN is D50 (i.e., Cycle Count Adjustment), the following additional processing occurs:

·      Year-To-Date Adjustments (WBYTDA) is incremented by 1.

·      Year-To-Date Absolute Adjustment Quantity (WBTAQ) is incremented by the Transaction Quantity.

·      Year-To-Date Absolute Adjustment Dollar Value (WBAADV) is incremented by the Activity Amount.

·      The Year-To-Date Cycle Count (WBYTCC) is incremented by 1.  If multiple cycle count adjustments are made to the same part in the same warehouse, WBYTCC is only incremented by the first transaction.

g.         The Warehouse Balance file is then updated.

IC090E Program Menu

• Purpose
• Calculations
• Files