Inventory Control

Year-to-Date cycle count and adjustment data is maintained on the Warehouse Balance and Description Files.  In order to zero out these totals for the new year, the following steps are necessary:

1.   The user must run Inventory Control Audit Trails for the last period of the old year.  Ideally, this is done at the end of the last working day of the year that is being finished.

2.   When the Inventory Control Audit Trails are run for the first period of the new year, the year-to-date fields on the Warehouse Balance and Description Files are automatically reset to zero.

3.   The Beginning Month/Year on the IC Application System Control File is automatically set to the new year when the Inventory Control Audit Trails are run for the first period of the new year.  You can look at this Beginning Month/Year field to ensure that the Beginning Month is the beginning month of your new year.

4.   Transactions for the new year are then accumulated into the cleared year-to-date fields.

5.   If additional months will be required on the Calendar Date File (CT140M), the user must add these through the Calendar Maintenance option on the Design Engineering Menu.

Note:    As part of the year-end procedures, the Inventory Cost Analysis Calendar for the new year must be updated on Reference File category C24.