Month End Procedure for Inventory Control (IC)

The following table identifies all of the programs used during the Month End process. Each program is identified as being Mandatory, Recommended or Optional during the Month End process. These terms are defined as:

  • Mandatory - The program must be run each Month (Period) End.

  • Recommended - The Month End process is not dependent on this program, but it is urged that the program be run. This program preserves the integrity of cross-reference files and purges eligible records from certain files.

  • Optional - This program is not required but is useful if you are using the feature or process.

The following table lists all of the Month End programs:

M/R/O Program Description
Mandatory IC50
IC51
Post all inventory adjustments
Print inventory adjustments register
Note: Be sure this step is run before the Sales Analysis period is closed via program SA89.
Optional IC57 Print In-Transit Shipment Report (reports Warehouse transfers) and balance to G/L control account.
Recommended IM71
IM72
Master File diagnostics
Print Master File Diagnostics report
Print Inventory Reports:
Recommended IC80
IC81
IC82
IC83
IC84
IC85
IC88
Print Inventory Movement (very rare-and then for small range only)
Print Inventory Evaluation (usually in summary form)
Print Over Stocked Report (usually 'on demand', not at month-end)
Print Stock Status Report (usually on demand, not at month-end)
Print Price Books (usually 'on demand', not at month- end)
Print Demand Unit History (very rare-and then for small range only)
Print Consignments (if applicable)
A copy of the IC81 Inventory Evaluation is recommended as a minimum.
If consignment inventory is used, IC88 should be printed on the actual month-end date.
Optional IM61 Report & Reset inventory class codes, as required and if used.
Optional IC89 Clear zero-balance consignments. This purge routine is only required if consignment inventory is used.
Recommended IC90 Purge inventory movement. This program can be run as needed to purge excess movement history.
Ensure a valid backup has been performed prior to any purge.
Recommended IC91 Purge Lot/Serial Transactions (as require to purge surplus history from lot/serial movement files.)
Also used by multi-bin inventory users to purge 'empty' bins.
Note: If using lot/serial, you need to keep movement history to match the invoice history detail.
Optional RM81
RM82
RM83
Auto merge of special products.

 
Back