NEW PRODUCT INFORMATION SCREEN

Update 22 Init 19

 

  1. This screen is used to Add Products to the System.  It can be accessed two ways:
    1. Go to the Search Menu and select Products.  Or
    2. Go to the Inventory Control tab, Inventory Totals sub tab, query a product, highlight it and click the Product Details button.
  2. Buttons
    1. OK.  Adds new Product to the system.
    2. Cancel.  Exit the screen without adding the new product.
    3. Hazmat Info.  Displays Hazmat data regarding the product.
    4. View Image.  Displays contents of an image file in the system default picture viewing program.

    Note: Use only Allowed Characters in Data Fields  

  1. Required Fields (Coreflex WMS and Coreflex 3PL Public Warehouse)
    1. Product ID
    2. Product Type
    3. Description
    4. UOM Class
    5. Pur UOM
    6. Sell UOM
    7. Alloc Method
    8. Back Order Logic
    9. Item Code
    10. Max Alloc level

 

  1. Additional Required Fields for Public Warehouse
    1. Weight
    2. Cube
    3. Packsize

 

  1. Additional Required Fields for Private Warehouse
    1. Price
    2. Vendor Cost

 

  1. Field Details

The parenthesis indicate if the field is used primarily for Private Warehouse (PRV) or Public Warehouse (PWH).

 

    1. Alloc Method (PRV & PWH)

                                                               i.      Determines what inventory for this product will be considered first when allocating for an order.

 

    1. Alt Vendorno (PRV)

                                                               i.      Alternate Vendor #

                                                             ii.      Vendor must exists on the Set Vendors screen

 

    1. Alt Vendor Part no (PRV)

                                                               i.      Alternate Vendor’s part # for this product

 

    1. Alt Vendor Cost

                                                               i.      Purchase Cost from Alternate Vendor for 1 PurUOM of this Product.

 

    1. Alt Vendorno 2 (PRV)

                                                               i.      Second Alternate Vendor #

                                                             ii.      Vendor must exists on the Set Vendors screen

 

    1. Alt Vendor 2 Part no (PRV)

                                                               i.      Second Alternate Vendor’s part # for this product

 

    1. Alt Vendor 2 Cost

                                                               i.      Purchase Cost from Second Alternate Vendor for 1 PurUOM of this Product.

 

    1. Back Order Logic (PRV & PWH)

                                                               i.      Always set to Default

 

    1. NMFC # (PRV & PWH)

                                                               i.      This drop down lists the Shipping Classes of type NMFC.

 

    1. Cost (PRV)

                                                               i.      Cost to Purchase the Item.  The cost entered here should be the cost to purchase 1 of the units entered in the PUR UOM field.

 

    1. Description (PRV & PWH)

                                                               i.      Product Description.  This appears on most of the screens and print-outs associate with the product.  Should be used first over the NOTES field.

 

    1. Image File Name (PRV & PWH)

                                                               i.      File Name of the image file for this product.  If left blank, the system will look for a file named <productid>.<Extension specified in system setting for default file type>.  Ie P1.jpg. For more information click Here.

 

    1. Inv Adjustment Account (PRV)

                                                               i.      Used with Quickbooks to indicate which account to update when adjustments are made to the inventory level for this product.

 

    1. Item Code (PRV & PWH)

                                                               i.      Should be set to Inventory for all Inventory parts.  Services and Notes can be added to orders and won’t be considered for allocation or try to be picked.

 

    1. Linked Productid (PRV)

                                                               i.      Used only with Consigned Inventory Feature

 

    1. Master Pack Size (PRV & PWH)

                                                               i.      Used when a carton is divided into inner and outer (master) packs.

                                                             ii.      Indicates total number of units in the master pack.

                                                            iii.      In this case packsize will indicate the number of units in an inner pack.

 

    1. Max Alloc level (PRV and PWH)

                                                               i.      This is the highest Location Type (based on Move Level)  that Coreflex will use when allocating inventory to an order.

 

    1. Max On Hand (PRV)

                                                               i.      Qty to maintain in the warehouse when reordering product.

 

    1. Notes (PRV & PWH)

                                                               i.      Extra Descriptive field for product.

                                                             ii.      Generally Description should be used as it appears on more screens and printed output.

 

    1. Pallet Qty (PRV & PWH)

                                                               i.      Used with Feature Pallet Tracking.

                                                             ii.      Indicates standard amount of inventory on a pallet.

                                                            iii.      Used to populate the PCS field when product is selected on the Pallet Tracking Pre-Receive screen.

 

    1. Price (PRV)

                                                               i.      Selling price for 1 SellUOM of Product.

 

    1. Price Category (PRV)

                                                               i.      Used with Feature Pricing to group products together that are similarly priced.

 

    1. Product ID (PRV and PWH)

                                                               i.      Unique identifier for Product.

                                                             ii.      In Public Warehouse the productid must be prefixed with the account prefix.

 

    1. Product Type (PWH)

                                                               i.      Used primarily to group together products that are billed differently than the overall account is billed.

 

    1. Pur UOM (PRV and PWH)

                                                               i.      Default Unit of Measure the item is purchased in or received in. The drop down list is populated based on teh UOMs available for the UOM Class selected for the product. UOMs and UOM Classes are set up udsing the Unit of Measure Screen.

 

    1. Purchase Lead Time (PRV)

                                                               i.      Lead time in weeks for receiving the product after purchasing.

 

    1. Purchase Price (PRV)

                                                               i.      Purchase Price of the product.  Note that Cost is used as the default for the Purchase Orders and inventory valuation.

 

    1. Qty On Hand (PRV and PWH)

                                                               i.      Current Quantity in Inventory in base units for the Product.

 

    1. Re Order Method (PRV)

                                                               i.      Determines the quantity, if any, to re-order for the product when the Suggested Products to Reorder reports and Queries are run.

 

    1. ROP (PRV)

                                                               i.      Quantity in base units at which to re-order more of this product.

 

    1. Sales Tax Code (PRV)

                                                               i.      Sales Tax Code which will be sent to Quickbooks for orders containing the product.

                                                             ii.      Must match a Sales Tax Code in Quickbooks exactly.

 

    1. Size Class (PRV & PWH)

                                                               i.      Used for garment products to indicate the class of style/color/size the garment belongs to. Size classes are set up using the Setup - Size Classes Screen.

 

    1. Sell UOM (PRV & PWH)

                                                               i.      Default Unit of Measure the item is ordered or shipped in. The drop down list is populates based on the UOM Class selected for the product. UOM Classes and UOMs are set up using the Unit of Measure Screen

 

    1. SN Required  (PRV & PWH)

                                                               i.      Determines whether the Serial # will be prompted for for this product during RF Receiving and Picking Operations.

 

    1. UOM Class (PRV * PWH)

                                                               i.      Unit of Measure Class to be used for this product. UOMs are set up using the Unit of Measure Screen.

 

    1. Vendorno (PRV)

                                                               i.      Vendor # for the product

                                                             ii.      Vendor must exists on the Set Vendors screen

 

    1. Vendor Part no (PRV)

                                                               i.      Vendor’s part # for this product

 

    1. Weight (PRV & PWH)

                                                               i.      This should be the weight of 1 Purchase Unit of Measure (PURUOM).  To properly calculate the order weights, this should be set so that if the PURROM is CTN, it will be the weight of a CTN, etc.

 

  1. Fields used by Corefelx Industrial WMS Systems:
    1. Origin
    2. Origin Key
    3. Pref Size
    4. Pref Band
    5. Pick Method