About Common Products

Common Products are products linked together by the same 'base' Product Code, and all Common Products have the Common Product checkbox selected in Maintain Inventory Master (IM13) . These products share the same set up in IM13 and in Maintain Purchasing Information (PO13). When any of the common fields are updated for one of the Common Products, a special updating feature automatically updates the corresponding fields on all of the other Common Products.

Setting up Common Products:

  • Up to 6 additional characters can be added to the end of the Product Code field:

    • This suffix indicates a unique color or size of the product.

  • For example, you have 'teddy bear' products with a Product Code=1234BEARS. You have identical bears, but some are red and some are green. The Color/Size codes are defined in Maintain Inventory Tables (IM09), and to identify each bear uniquely by color, a code of RED or GREEN is attached to the 'base' Product Code. This distinguishes the 'teddy bears': 1234BEARS-RED and 1234BEARS-GREEN.

  • The Product Code and the unique suffix must be separated by a symbol, such as a dash '-'. To determine the 'separator symbol' used by your company, go to the Color Separator field found in Company Control Initialization (CC00/Inventory Control). Note: You cannot edit this field in CC00; you must use the symbol indicated here.

  • To identify Common Products, the Common Product checkbox in IM13/Stock folder must be checked.

    • When using the Common Products feature, the products must be set up the same in IM13 and in PO13. See below for a complete listing of common fields.

    • When any of the common fields are changed for any one of the Common Products, a special updating feature automatically updates the corresponding fields on all of the other Common Products. For example, if you change the price for 1234BEARS-RED, the price changes 1234BEARS-GREEN and for all corresponding 1234BEARS Common Products.

The common fields in Maintain Inventory Master (IM13) are:

    Folder 1 - Stock
    • Stock Unit
    • # Pcs / Selling Unit
    • Split Qty
    • Commodity Code
    • G/L Code
    • SKU Measurements (all 6 fields)

    Folder 2 - Selling

    • Product Tax Code
    • Royalty Code
    • Commission Code - this field is available only when the Code Used for Calculation is set to Commission in CC00/Order Entry
    • Fragility
    • Catalogue Page - for the first, second and third catalogues
    • Catalogue Code - for the associated catalogues

    Folder 3 - Pricing

    • Quantity Break
    • Price Per Unit
    • Net Price Item
    • Retail Price
    • Minimum Gross %
    • Maximum Discount %
    • Selling Prices
    • Ticketing and Misc. Price Component
    • Ticketing and Misc. Cost Component

    Folder 5 - Misc

    • Warranty Months and Days
    • Shelf Life Months and Days

The common fields in Maintain Purchasing Master (PO13) are:

(Note: Changes to fields in PO13 only affect the common products associated with the supplier being update. For example, let's say we have products 123-blue and 123-red, and both products are assigned to suppliers SUPPLIER1 and SUPPLIER2. If we change the purchasing criteria for SUPPLIER1 and product 123-blue, then product 123-red is updated for SUPPLIER1. No changes will be made for the same products assigned to SUPPLIER2.)

    Folder 1 Purchasing
    • Primary Supplier
    • Purchasing Unit of Measure
    • Purchasing Criteria
    • Endangered Species
    • Fumigation Required
    • Visa/Quota Required
    • From Purchasing Unit
    • To Stock Keeping Unit
    • Production Lead Time Days Override
    • Transit Lead Time Days Override
    • Port
    • Shipping Terms

    Folder 2 - Pricing Info

    • Quantity (all Quantities)
    • Purchase Price (all Prices)
    • Discount % (all Discount levels)
    • Price per U/M
    • MSRP
    • Minimum Order Quantity
    • Currency code
    • Country of Origin
    • Duty Code

    Folder 4 - Cost Factors

    • Landing Factors - from the Primary Shipping Method only

    Folder 5 - Promotion

    • Price
    • Discount
    • Start Date
    • End Date

  Back