Pending F/M (ICF450)

Use this program change or remove recently imported records before running the Pending File Update program.

To access this program, choose Inventory Control-->Electronic Price Update-->Pending F/M.

Records can be manually added to this file if necessary. Records with errors or exceptions will not be updated and will remain in the pending file after the Pending File update is run. Currently, the exception codes are defined as follows:

01 - Vendor not on file

02 - Commodity code not on file

03 - Not primary vendor

04 - Different item class on file

05 - Pricing UM not on file

06 - Duplicate interchange number

07 - Item not in inventory or catalog

08 - Numeric field error

09 - Prices not descending

10 - Zero price or other price error

11 - Quantity breaks not ascending

12 - Different vendor-item number on file

13 - No standard pack

14 - Different item price class on file

PR -Prices on file will NOT be updated

If you find that data records are unrecognizable or they are flagged with a large number of exceptions, revisit the EPU file maintenances. These situations also may indicate a problem exists in the data file.

Use the following fields to correct or delete records before you update them to the system:

*1. Service Code

When adding a new record, enter the service provider code. When editing an existing record, the * indicates this field may not be changed. If this is an unnecessary record, delete the record. If this is a necessary record, use the checklist provided for the initial setup to verify this service provider has been added to all necessary file maintenances. Run Flat File Import again making sure to INITIALIZE the pending file.

*2. Vendor

When adding a new record, enter the vendor. When editing an existing record, the * indicates this field may not be changed; however, the Change Vendor Number option allows this field to be edited. Enter the primary vendor for this item. "!!!! … Not on File" in the Vendor field indicates that an associated record in Service Code/Vendor F/M is missing. Refer back to the Initial Setup Procedures.

*3. Item

When adding a new record, enter the FACTS item number. When editing an existing record, the * indicates this field may not be changed.

*4. Action

When adding a new record, enter the action code. When editing an existing record, the * indicates this field may not be changed.

NEW - New item from manufacturer

PRC - Price change (+/-)

REQ - New request by user

DIS - Item discontinued by manufacturer

MSC - Miscellaneous change

ITM - New service item number

INC - Price increase

DEL - Item deleted by manufacturer

DEC - Price decrease

SKP - Item skipped by manufacturer

 

5. Desc1

Enter the description 1 for this item (up to 30 characters).

6. Desc2

Enter the description 2 for this item (up to 30 characters).

7. Alpha

Enter the alphabetic sort definition to be used to sort this item alphabetically for print-outs and searches. Press Enter (CR) to default to the first 10 characters of what is set up to be the alpha sort definition key in the EPU Control F/M.

8. Item Class

Enter the item class from IC Item Class F/M for this item. When editing an existing record, "Not on File" in the class field indicates that an associated record in Commodity Code/Item F/M is missing. Refer back to the Initial Setup Procedures.

9. Item Price Class

Enter the item price class from IC Item Price Class F/M for this item. When editing an existing record, "Not on File" in the price class field indicates that an associated record in Commodity Code/Item F/M is missing. Refer back to the Initial Setup Procedures.

10. Commodity Code

Enter the product (commodity) code from Commodity Code/Item Class F/M for this item.

11. Weight

Enter the per unit weight of the item (0-9999.999). Press Enter (CR) to default to 0.

12. upc #

Enter the Universal Product Code (UPC) for this item. Press Enter (CR) to leave this prompt blank.

13. Model #

Enter the model number for this item. Press Enter (CR) to leave this prompt blank.

14. Interchange

Enter the interchange number. Press Enter (CR) to leave this prompt blank.

15. Standard Pack

Enter the standard pack of multiple buying unit of measure. Press Enter (CR) to default to 1.

16. New Item

Enter the new item number for updating the Item File. Press Enter (CR) to default to blanks.

17. Vendor-Item

Enter the primary vendor-item number. F1 defaults to the same number as the item number. Press Enter (CR) to default to blanks.

18. Pricing UM

Enter the unit of measure. Press F2 to search the available UM codes.

19. List Price

Enter the list price. Press Enter (CR) to default to .00.

20. Manual Cost

Enter the manual cost. Press Enter (CR) to default to .00.

21. Standard Price

Enter the standard price. Press Enter (CR) to default to .00.

22. Create Levels

Enter which types of price levels to create: Price Levels, Quantity Breaks, Both Price Levels and Quantity Breaks, or Neither Price Levels or Quantity Break Prices. The options available for this field are set in the IC Static Control Record based on whether level pricing and quantity break pricing are used. Pressing Enter (CR) may default to Both.

23-28. Price Level 1-6

Enter the level 1-6 price for this item. Enter F1 for no price. Press Enter (CR) to default to .00.

29-34. Qty Level 1-6

Enter the quantity break for the level 1-6 price. Enter F1 for no quantity break. Press Enter (CR) to default to 0.

35. (Optional) Exceptions found in this record. OK to continue?

This prompt appears if exceptions were found in the record. Exceptions may occur as a result of the data in the flat file or by lack of information in the file maintenances. The exception codes will display in the lower left-hand part of the screen. All exceptions must be resolved before the record can be updated. Enter N to edit the record now or Y to save the record for editing later. Press V to view exception codes or C to change vendor number.