Pending File Update (ICU460)

How To

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.

• 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
  

Access this program by choosing Inventory Control-->Electronic Price Updates-->Pending File Update.

Use the following fields to update imported pricing information and standard part numbers:

1. Service Code

Enter the pricing service code from Service Code F/M.

2. Initial Item Load

Enter No or Yes to indicate whether this is the first time this item has been loaded into the inventory files. Press Enter (CR) to default to N.

Caution: Entering Yes overrides the action code and vendor default settings and treat each record in the pending file as if it were a new stocked item. Existing FACTS data will be overwritten.

3. Cost/Price Update

Enter whether to update Suggested FACTS costs/prices or Actual FACTS costs/prices. Press Enter (CR) to default to S.

4. Effective Date

This field is accessible only if Suggested Cost/Price data is to be updated. Enter the date the suggested changes are to take effect. Press Enter (CR) to default to the system date.

5. Beginning Vendor

Enter the beginning vendor to process. Press Enter (CR) to default to FIRST.

6. Ending Vendor

Enter the ending vendor number to process. Press Enter (CR) to default to LAST.

See Also

How to update imported pricing information and standard part numbers