Inventory Control File Maintenances Overview
Use the file maintenance programs in the Inventory Control module to set up and maintain information on items and warehouses.
The programs on the File Maintenance menu enable you to set up and maintain items records in a particular warehouse (with location, reordering controls, stocking information, etc.), and serial/lot numbers for an item in a warehouse (with receiving information, quantity, etc.).
The Item Interchange F/M allows setting up alternate reference numbers for an item, so that when the reference number is entered at an item field, the correct item number is displayed automatically. An item may have an unlimited number of interchanges. The Warehouse/Vendor Review F/M contains information on vendor buying requirements and how often a vendor’s product line should be reviewed for reordering.
The last four programs are really user time savers. The Create Warehouse/Item Records allows creation of a new warehouse or the adding of a product line to a warehouse without the operator having to enter each record manually. The Create Warehouse/Vendor Review Records allows duplication of warehouse/vendor records from one warehouse to another. The Transfer/Change Item Codes and Item Changer Programs allow changing selected item information without having to pull up each record in the Item F/M and changing it manually.
You can also access Infrequent File Maintenance programs from the File Maintenances menu.
You can access the following programs from the IC File Maintenances menu:
- Item F/M (ICF910), which is used to create and maintain records in the item file.
- Item/Unit Of Measure F/M (ICF915), which is used to enter units of measure information for an item, including conversion factor and weight per unit, and whether it can be used for selling, stocking, or pricing. It is also used to define the unit of measure defaults for stocking, pricing, selling, costing and buying.
- Warehouse/Item F/M (ICF920), which is used to create and maintain records in the warehouse/item file. Each record contains general, restocking, usage, sales, cost, activity and receipt information relevant to a particular item in a given warehouse.
- Catalog Item F/M (ICF905), which is used to maintain information on catalog items and export catalog items into the FACTS Item F/M.
- Serial/Lot F/M (ICF930), which is used to maintain serial numbers and lot numbers for items.
- Item Interchange F/M (ICF935), which is used to access or identify item numbers in the inventory using different codes.
- Whse/Vendor Review Cycle F/M (ICF945), which is used to create and maintain the warehouse/vendor review cycles.
- Quick Item Add, which is used to create and maintain records in the item file quickly by using an existing item to serve as a template for the new item.
- Create Warehouse/Item Records (ICU910), which is used to create warehouse/item records automatically for a range of items in the item file.
- Create Warehouse/Vendor Review Records (ICU930), which is used to duplicate Warehouse/Vendor Review Records from one warehouse to another.
- Transfer/Change Item Codes (ICU920), which is used to change information in the Item and Warehouse/item Files for a range of items.
- Item Changer (ICU940), which is used to change specific information about an item to be reflected throughout the FACTS System.
- Use the Past Transfer Removal program to delete old records from the past transfer history files based on selection criteria. This program can be run through job stream.
See Also
For more detailed information on file maintenance programs, consult the following topics.
How to use file maintenance programs
Information for creating and maintaining items
Information for creating and maintaining units of measure for an item
Information for creating and maintaining warehouse/item records
Information for creating and maintaining on catalog items and exporting catalog items into the FACTS Item F/M.
Information for creating and maintaining serial numbers and lot numbers for items.
Information for creating and maintaining an item interchange records
Information for creating and maintaining warehouse/vendor review cycles
Information for creating and maintaining records item file records quickly by using an existing item to serve as a template for the new item
Information for creating and maintaining warehouse/item records automatically for a range of items in the item file
Information for duplicating Warehouse/Vendor Review Records from one warehouse to another
Information for changing information in the Item and Warehouse/item Files for a range of items
Information for changing specific information about an item to be reflected throughout the FACTS System
Information for running the Past Transfer Removal program