This file maintenance provides default values for information not present in the pricing service/vendor flat file. The default values may be vendor specific, where different values apply to different vendors.
The information contained within this file maintenance provides the update program with the details of how to process the records from the flat file (i.e., create a new item record, create new catalog records, or skip new items) and how to handle multiple quantities/prices.
Access this program by choosing Inventory Control-->Electronic Price Updates-->Vendor Defaults F/M.
*1. Service Code
Enter the pricing service code from Service Code F/M. F3 defaults to the first record.
*2. Vendor
Enter the vendor from AP Vendor F/M or press F1-ALL if all Vendors are treated the same when updating the FACTS IC files.
*3. Item Price Class
Enter the item price class from IC Item Price Class F/M or press F1-ALL if all Item Classes and Price Classes for this Vendor are treated the same when updating the FACTS IC files.
*4. Item Number
Enter the item number from IC Item F/M or press F1-ALL. If a specific item needs to be handled differently than the others for this Vendor/Item Class, enter the Item number.
5. New Item Handling
The item handling code indicates how the records in the flat file will be processed: create a new Stocked item, create a new Nonstocked item, create a new Uninventoried item, create a new Catalog item, or Skip new items (X). Press Enter (CR) to default to S.
6. Create Vend/Item
This field is accessible only if new item handling is set to create a stocked or cataloged item. Indicate Yes/No to create a new vendor/item record in the PO Vendor/Item F/M. Press Enter (CR) to default to Y.
7. Price Multiplier List
Enter the multiplier for the list price. The List price mapped in the EPU Service Code F/M will be multiplied by this factor and written to the pending file. Press Enter (CR) to default to 1.
8. Price Multiplier Standard
Enter the multiplier for the standard price. The Standard price mapped in the EPU Service Code F/M will be multiplied by this factor and written to the pending file. Press Enter (CR) to default to 1.
9-14. Price Multiplier Level 1-6
Enter the multiplier for price level 1-6. The Level 1-6 price mapped in the EPU Service Code F/M will be multiplied by this factor and written to the pending file. Press Enter (CR) to default to 1.
15. Manual Cost Multiplier
Enter the multiplier for the manual cost. The Manual Cost mapped in the EPU Service Code F/M will be multiplied by this factor and written to the pending file. Press Enter (CR) to default to 1.
16. UM Relation
Enter the default small, middle, and large units of measure. Use F2-Search to search existing unit of measure codes. Press Enter (CR) to default to EA, however EA must be on file in IC Unit of Measure F/M.
17. UM Defaults
Enter the default stocking, pricing, selling, costing, and buying unit of measure. Press Enter (CR) to default to EA, however EA must be on file in IC Unit of Measure F/M.
18. Conversion Factor Mask
Enter the mask for units of measure conversion factors. Nine characters are used (including an optional decimal). Options: ########0, #######.0, ######.00, #####.000, ####.0000, ###.00000, ##.000000, #.0000000. Press Enter (CR) to default to ########0.
19. Conv Fact SM/2
Enter the number of smallest UMs found in one middle UM. For example, if each is the smallest unit of measure and a dozen is the middle UM, enter 12 here. Press Enter (CR) to default to 1.
20. Conv Fact SM/3
Enter the number of smallest UMs found in one large UM. For example, if each is the smallest unit of measure, a carton is the largest unit of measure, and there are 48 eaches in a carton, enter 48 here. Press Enter (CR) to default to 1.
21. Active
Enter Yes or No to indicate whether this item is active for purchasing and replenishment. Press Enter (CR) to default to Y.
22. Serial/Lot
Enter whether this is a Serial item, Lot item or neither. Press Enter (CR) to default to N
23. BOM/Formula
Enter whether this is a bill of materials item, finished item or neither. Press Enter (CR) to default to N.
24. Taxable
Enter Y or N to indicate whether this item is taxable. Press Enter (CR) to default to Y.
25. Misc Sales
Enter No or Yes to indicate whether this item is to post to miscellaneous sales in Sales Orders. Press Enter (CR) to default to N.
26. Commission %
Enter the commission percentage. Press F1 for no priority. Press Enter (CR) to default to 0.
27. Freight Class
Enter the freight class. Press Enter (CR) to default to blanks.
28. Stocking Whses
Enter the stocking warehouse codes, side by side. F1 defaults to ALL.
29. Seasonal Item
Enter the whether this item is a Non-seasonal Low seasonal, or High seasonal item. Press Enter (CR) to default to N.
30. Use Ledgercards
Enter No or Yes to indicate whether to use ledger cards. Press Enter (CR) to default to N.
31. Restocking_SMG000_000 Method
Enter whether the restocking method is Order point/line point or Min/Max . Press Enter (CR) to default to O.
32. Order Qty Method
Enter whether the order quantity method is Economic Order Quantity, Movement class, or Manual. Press Enter (CR) to default to E.
33. Safety Allowance
Enter the safety allowance percentage. Press Enter (CR) to default to 0%.
34. Restocking_SMG000_000 Whse
Enter the restocking warehouse. Press Enter (CR) to default to direct from vendor.
35. Create Levels
Enter which types of 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 based upon the level/quantity break pricing flags in the IC Static Control Record. CR may default to Both.