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.
*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.