The Inventory Counting System uses, or affects the following fields in the Inventory Master file.
LAST_COUNT: The Last Count field stores the date on which the inventory item was last counted. This field is updated by the program which is run at the end of the count process. The field can be used along with the count cycle field to determine which items should be counted when counts are done on a cyclic basis. Note: If a partial or cycle count is being performed, the Last_Count field will only be filled in if a count record has been entered into the Inventory Count file for the item.
COUNT_CYCLE: The Count Cycle field stores the number of days which should pass between counts of the selected item. This field may be used along with the Last Count field to determine which items should be counted when inventory counts are performed on a cyclic basis. This field in the Inventory Master is manually maintained.
COUNT_QTY: The Count Quantity field is used to store the total quantity of the item that is physically counted during the count process. This field is cleared by the program which prepares an inventory location for a physical count. The field is updated by the system as count records are entered into the Inventory Count file for the item. If multiple count records are entered into the inventory count file for a single inventory item, the Count Quantity field will store the total of the quantities in the individual count records. The update program which is run at the end of the count process uses the difference between the EOM_QTY field and the Count_Qty field to determine the adjustment required for the item.
QTY_OH: The On Hand Quantity field stores the current on hand quantity of the item and it is updated at the end of the count process. If a partial or cycle count is being performed, the on hand quantity of the item is only adjusted if there is a count record entered into the Inventory Count file for the item. This is the basis quantity that the count quantity is compared to when making the adjustment.