Use the following steps to set up and import standard part numbers using the FACTS Electronic Pricing Update system.
Prerequisite: The items for which you want to create standard part numbers must already exist in Item F/M or Catalog Item F/M.
1. Create source codes, such as UPC, EAN, IDW, for standard part numbers in Standard Part Source F/M. Inventory Control>File Maintenances>Infrequent File Maintenances>Standard Part Source F/M. Source codes define the source of the standard part number, for instance UPC, IDW or EAN (the European equivalent to UPC). They refer to the industry standard by which the part numbers were created.
2. Use Standard Part Map F/M to define positions, field lengths etc. for each pricing service and vendor that provides flat files. Inventory Control-->Electronic Price Updates-->Standard Part Map F/M. Make sure the service code and source code you need to create the maps are set up in Service Code F/M and Standard Part Source F/M.
3. Run Flat File Import. The information imported through this program is not considered "in the system" until you run Pending File Update. Inventory Control-->Electronic Price Update-->Flat File Import. The import function provides the ability to remove a previously used flat file before processing the current file. Any record that contains an error during the import will be flagged in the pending file with an exception code. During the initial setup, it may be necessary to run the import program a number of times, reviewing the pending file each time and adjusting the file maintenances as needed until the import program can successfully translate the data in the flat file.
4. Use Pending Standard Part F/M to correct or delete standard part numbers and descriptions before you updated them to the system. This step is optional. Inventory Control-->Electronic Price Update-->Pending Standard Part F/M. After you import a flat file in Flat File Import and resolve exceptions in Pending F/M, use this program to modify standard part numbers and their descriptions. Afterwards, run Pending File Update to update them into the system.
5. Run Pending File Update to add the standard part numbers into the system. Inventory Control>Electronic Price Update>Pending File Update. This program updates the FACTS system with the data from the pending file based on the run time selection criteria. Information that is not present in the flat file, but is required in the IC master files (Item F/M), will be pulled from the Vendor Defaults F/M. Records that successfully update to the FACTS IC files are removed from the pending file. Any record that contains an exception code will remain in the pending file until the record is corrected and updated or manually removed. Actual or suggested cost/price data can be updated.
Notes: The Pending File Update program does not allow you to include alternate bin locations for items.
As the program creates warehouse/item records, the replenishment flag is populated with the default value. If the item is stocked, the replenishment flag is set to Yes. If the item is non-stocked, the flag is set to No.
The program determines and sets the cost class based on the default value in the Vendor file.
eCatalog Note: When a new item record is added to ICMAST or ICICAT or certain fields are changed, a record will be added to the eCatalog log file for the next update to the catalog database. Field changes that will trigger an update are: Description 1 Description 2 Item Class Vendor-Item List Price
6. Use Standard Part Number Entry to add any additional standard part numbers and descriptions into the system. Any information created in this program is immediately added to the system. Inventory Control>Electronic Price Update>Standard Part Number Entry. Source codes must be set up in Standard Source F/M before you can create standard part numbers in this program
Prerequisite: Before you set up a standard part number, make sure the item to which it is related is set up in Item F/M or Catalog Item F/M.
1. Create source codes, such as UPC, EAN, IDW, for standard part numbers in Standard Part Source F/M. Inventory Control>File Maintenances>Infrequent File Maintenances>Standard Part Source F/M.
2. Use Standard Part Number Entry to create the numbers and their descriptions. Standard part numbers entered in this program are automatically added to the system. You do not have to run an update.