The EPU Control File Maintenance program defines consistent rules for creating and reading FACTS item numbers from the data sent by the pricing service(s) or vendor and other global EPU parameters.
EPU Control F/M can also be used to preserve existing FACTS data that may otherwise be changed by the updates. These controls are not specific to pricing service or vendor data.
The control record determines item number definition, an item number separator, an alpha sort definition, and whether to allow changes to the alpha sort key, class, item description, vendor-item and price class fields. It also determines which pricing UM fields to update and whether to keep or delete imported suggested cost/price information.
Access this program by choosing Inventory Control-->Electronic Price Updates-->EPU Control F/M.
1. Item Number Definition
Enter up to 3 elements (in sequence) to build the item number by: Item number, Vendor prefix, catalog number, Item class (K), Vendor number, Model number, or UPC number. When using Vendor Direct Data, using the Item number option indicates that the vendor item number and your FACTS item number are an exact match. Vendor prefix or vendor number, when applicable, is pulled from Service Code/Vendor F/M. Item class, when applicable, is pulled from Commodity Code/Item Class F/M. Press Enter (CR) to default to V.
2. Item Number Separator
Enter the non-alphanumeric character to insert between item definition fields. For example, item number is defined as the Vendor Prefix + Item Number. If the vendor prefix is "3GM", the item number is "47850", and the separator is defined as "/", the new item created would be "3GM/47850". Press F1-NONE or F2-SPACE.
3. Alpha Sort Definition
The alpha sort is used to sort items for reporting and inquiry purposes. Enter whether to use the Catalog number, Item description, Item number, Item class + item number (K), or Vendor prefix + catalog number sort. The alpha sort may vary from vendor to vendor. If so, the Alpha Sort Definition may be defined in Service Code/Vendor F/M for the specific vendor. Press Enter (CR) to default to V.
4. Item Component Modification
When building item numbers through EPU, indicate how the item number components should be modified. Enter 0 for no modification, 3 for strip leading/trailing spaces from components, 4 for convert components to upper case, or 7 strip leading/trailing spaces from components and convert components to upper case.
5. Allow Change To Alpha Sort
Enter No or Yes to indicate whether to allow the update to change the item’s alpha sort
6. Allow Change To Item Class
Enter No or Yes to indicate whether to allow the update to change the item class field.
7. Allow Change To Item Desc
Enter No or Yes to indicate whether to allow the update to change the item description field.
8. Allow Change To Vendor-Item
Enter No or Yes to indicate whether to allow the update to change the vendor-item field.
9. Allow Change To Price Class
Enter No or Yes to indicate whether to allow the update to change the price class field.
10. Price/UM Update
A pick list appears as you enter this prompt. Select I to update the INCOMING pricing UM, D to update only the DEFAULT pricing UM or A to update ALL pricing UMs.
11. Delete Suggested
This prompt enables you to keep or delete suggested cost/price information that exists in FACTS. From the pick list that appears, select either Y to delete corresponding cost/price records in FACTS and replace with those from the imported file or N to keep the FACTS records.
12. SSI_Flat.Exe Path
This entry is only necessary for CD Catalog files. Enter the drive, directory and subdirectories where this FACTS flat file program is stored.