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
|