Product Setup - General field descriptions

When you click Create on the Add Product window, these fields are displayed for setting up the product information.

Fields are presented in alphabetical order within each section.

General description

Brief Description

The product description; an expanded explanation or identification of the product. Two lines of description are available. The most important description should be entered on the first line, with a secondary description entered on the second description line. Both descriptions appear during transaction entry functions, but generally only the first description or the lookup name appears on all reports and inquiries.

Enter Description in Multiple Language

Click this button to change the language of the product description that prints on pick tickets, acknowledgments, purchase orders, warehouse transfers, and invoices for a particular customer or vendor. This button is displayed only if you have selected a default language for your company in SA Company Setup, even if the language is English.

Extended Description

Specify an extended product description, if necessary. If you specify more than 70 characters, the Extended field reverts to a horizontal scrolling field to accommodate the extra characters. You can specify up to 256 characters in the field. This description is printed in addition to the text in the Description 1 and 2 fields on reports if the option, Display Extended Product Description on Reports, in SA Administrator Options-Products-Defaults is selected. The Extended Description is displayed in inventory setup and inquiry functions regardless of the administrative option.

Lookup Name

If the Lookup Name field is left blank, the first 15 characters are defaulted from the Product, Description 1, or Description 2 fields, or remains blank based on the SA Administrator Options-Products-Defaults Lookup Name From option.

The lookup name is generally used instead of the product name throughout the Product and Price/Discounting modules. The lookup name usually appears on most inquiries and reports. Therefore, set up meaningful lookup names.

If the product description is changed, the lookup name is not updated to the new product description. Two options are available to change the lookup name:

Manually change it to match the product description.
Clear the Lookup Name field and, when you click Create and Continue, the new product description appears in the Lookup Name field, based on the Lookup Name From option in SA Administrator Options-Products-Defaults.

Sequence #

The sequence number allows you to sort products within a lookup name inquiry. For example, you may have five products with the same lookup name. This field allows you to place those products in a particular order.

Status

The options are Active, Inactive, Labor, or Superseded.

When a product is inactive, the product cannot be entered in any transaction entry function or updated through reports that update records. A product can be set to inactive for a temporary period or permanently. If the result is permanent, be sure the Product Warehouse Product Setup record is balanced properly and no outstanding balances exist.

These conditions must be met before the status can be changed to inactive:

No Product Warehouse Product Setup balances exist
The product is not on an active cycle count
There are no active Sales Order, Purchase Order, Transfer, Kit, or Tally lines for this product
Note: The product can be set to inactive if it exists on an open purchase order line as a true nonstock item while still being bound by the previous conditions.

A labor product is a service that you provide, rather than a physical product. Prices, costs, and discounts are tracked, but quantities are not.

Note: When you set up a labor product record, use a product category with a Product GL Distribution Setup inventory account that debits an expense account instead of an asset account. An out-of-balance condition occurs if you combine labor products with inventory products in the same product category.

Transaction entry functions do not update any quantities for labor products, although you can set up Pricing and Discounting records for prices and discounts.

Superseded products are those products that have been replaced by another product. A Product Extended Product Cross Reference Setup record must be set up for this product with the product superseding this one. When the superseded product is specified in the cross-reference file, the status is automatically changed to Superseded. If you subsequently delete the Product Extended Product Cross Reference Setup record, the Product Setup status returns to Active.

Logistics

Bill of Lading Rate

This field is for informational purposes for the class or rate printed on your Sales Entry Processing Bill of Lading forms.

Cube

The Cube field is used if you are implementing Total Warehouse Logistics (TWL). Cube is the volume represented by one stocking unit of this product. It is used by TWL algorithms to maximize warehouse space and direct tasks. The cube is calculated as the length x height x width. If the total cube is known, the dimensions is calculated. If three of the variable amounts are known, the fourth can be calculated. If any of the variables change, the Cube is recalculated in Product Setup and TWL is updated. The dimensions are validated and a message is displayed if the cube does not equal the length x height x width. If this field is zero, 1 is downloaded to TWL for the cube, height, weight, and length.

All dimensions for all products and locations in the system and TWL must be in a similar unit of measure. For example, if you calculate cubic volume in inches, inches must be used for all products and locations in both warehouses. Because the TWL location records do not recognize a fractional unit of measure, use the smallest equivalent unit of measure relevant to your products.

Height / Length / Width

Determine the cube of the product. If three of the variable amounts are known, the fourth is automatically calculated. For example, if the height, width, and cube are known, the length is calculated. If any of the variables change, the cube is recalculated in Product Setup. The system validates the dimensions and a message appears if the cube does not equal the length x width x height.

Taxation Weight

Optionally, you can calculate an industry tax by weight. This value used to calculate industry taxes when conditions are met. You must have enabled industry tax functionality in SA Company Setup, set up expanded tax groups in SA Table Code Value Setup, and set up a tax master record in SA Sales Use Tax Setup. When you specify amounts in the tax record, you must specify a Flat Excise Amount and set the Apply To field Taxation Weight. The Taxation Weight is differentiated from the actual Weight of the product because the two weights may not be the same, and because the actual Weight may be used to calculate non-tax-related amounts. The Taxation Weight default is 1.00000. The field allows 7 digits before the decimal and 5 after.

Weight

The weight of one stocking unit. Specify as pounds and a fraction. This is used by the Purchase module to meet weight targets on PO RRAR. The total weight is printed on the pick ticket. It is also used in Sales Order Entry to determine and display the total weight of an order in Sales Order Entry-Totals.

Units

Counting

The product's counting unit if it is different than the stocking unit. If the counting unit is the same as the stocking unit, leave this field blank. The counting unit should be the actual unit you use to take a physical count. Product Count Entry and Product Qty Adjustments Entry use the counting unit. If the counting unit does not exist, the stocking unit will default during Product Qty Adjustments Entry.

When a valid counting unit is entered, the description and unit conversion appear to the right of the field. The counting unit is set up in SA Table Code Value Setup or Product Extended Unit Conversion Setup.

The lookup provides the same information for this field as it did for the Stocking field.

Selling

The unit you specify on the Sales Order Entry line item. If the selling unit is the same as the stocking unit, you can leave this field blank.

Sales Order Entry defaults the selling unit each time this product is sold, unless it does not exist. Then the stocking unit defaults to the line item. If the selling unit is different than the stocking unit, set up a Price/Discounting record for that unit if it differs from the relative price of the stocking unit. If one does not exist, the price record for the stocking unit will be used. The price and discount will be multiplied against the unit conversion in SA Table Code Value Setup or Product Extended Unit Conversion Setup to obtain the correct price and discount for Sales Order Entry.

When you specify a valid selling unit, the description and unit conversion appear to the right of the field. The selling unit is set up in SA Table Code Value Setup or Product Extended Unit Conversion Setup.

The lookup provides the same information for this field as it did for the Stocking field.

Stocking

The stocking units should be the base unit of measure (each, box, and so on) for this product. It should be the smallest unit in which this product can be sold, purchased, or stocked. All other units are based off the stocking unit. The stocking unit will automatically default to each. Although a lookup of various units is available, these units are relative to the stocking unit; therefore, the stocking unit is not validated in SA Table Code Value Setup or Product Extended Unit Conversion Setup.

Stocking units should not be changed. Changing the stocking unit seriously impacts the preceding and current transactions in Purchase Order Entry, Sales Order Entry, Transfer Entry, Inventory Control, Sales Manager, and any other transaction that includes a stocking unit that is relative to the Product Setup stocking unit. If the stocking unit is changed, the unit conversion on the lines, and therefore the calculated quantities, may no longer be valid.

Note: If the stocking unit is accidentally changed, contact Infor Support Services to help you restore your files.

When you perform a lookup on a unit field you have two options.

Product unit - The lookup window reflects any unit conversion records that you have set up in Product Extended Unit Conversion Setup.
Nonspecific - The lookup window reflects nonspecific unit conversions set up in SA Table Code Value Setup that may be applied to any product.

For each Pricing and Discounting record that contains a product, the unit must be entered. Pricing and Discounting records do not have to be set up for each unit conversion for this product.

Kit

Allow Memo Tally

Identifies a stocked product as a memo tally product. A memo tally product represents the generic variety of products, such as molding, which is bundled, handled, and tracked in Product Warehouse Products Setup as a single product. When you select this field, the product cannot be a tally product, and you do not have to establish a mix for memo tally products in KP Tally Mix Setup.

Allow Transfer

Valid for products with a Kit Type of Build on Demand. Indicate if your company allows build on demand kits to be tied to warehouse transfers.

Choose Allow WT BOD to allow build on demand kits entered on sales orders to be tied to warehouse transfers.

Choose Do Not Allow WT BOD to prevent build on demand kits from being tied to warehouse transfers. A prebuilt kit cannot be tied to a warehouse transfer.

Bundle ID Required

A product that is set up as a random-tally kit can also be marked as a tally bundle product. A bundle ID is required (except for loose inventory) whenever the tally bundle product is entered on a purchase order or customer order line. Loose inventory does not require a bundle ID.

Comp Prt Transfer

Indicate which documents you want the fabricated kit components to print on.

Choose OE Pick to print fabricated kit components on the Sales Order pick ticket and Sales Order Master List Report.

Choose WT Pick to print fabricated kit components on the Warehouse Transfer pick ticket and Transfer Master List Report.

Choose Both to print fabricated kit components on both the Sales Order and Warehouse Transfer pick tickets and their corresponding master list reports.

Choose Neither to prevent printing of fabricated kit components on all documents.

Choose Blank to not allow fabricated kits (the Allow Transfer field is set to Do Not Allow WT BOD).

Kit Type

Use this field if the product is assembled from components and is considered a kit product. Kits can either be prebuilt, build-on-demand, or a tally. Prebuilt and build-on-demand kits are set up in KP Setup Components.

Prebuilt

Prebuilt kits may be used whenever a group of products is going to be grouped and packaged together. Prebuilt kits are built through Kit Production and stored in the warehouse as a stocked product. The quantity that is assembled depends on the demand placed on the kit product. When an order is placed for the kit, the kit is taken from the shelf and inventory is reduced on the kit's Product Warehouse Product Setup record. A KP RRAR is produced when replenishment is needed, if the ARP in Product Warehouse Product Setup is set up as kit. This option cannot be selected if this is a labor product.

Build on demand

Build-on-demand kits are built as needed when a Sales Order Entry order sets its production in motion. Build-on-demand kits may be established so that each kit can be customized to meet your customer's needs. Variable quantities or optional components may be substituted during Sales Order Entry. For example, a build-on-demand kit is useful when one customer may select tinted glass and another customer may select clear glass. The glass component can be exchanged as the order is entered and the kit built at the time of the order. Pure build-on-demand kits are not pre-assembled and will not be included on the KP RRAR report. The number of kits available to be built depends solely on the availability of the components.

The build-on-demand kit type also encompasses fabricated kits. Fabricated kits are a kind of hybrid between a prebuilt and build-on-demand kit. The prebuilt part is used because the kit can be stocked as a single product in the shipping warehouse. The build-on-demand designation is used because the kit is not fabricated until an order is placed in Sales Order Entry. Unlike pure build-on-demand kits, fabricated kits can be assembled and transferred from one warehouse to another on a warehouse transfer. When you specify a product as a build-on-demand kit, you can then use the Allow BOD Transfer field to specify if it is a fabricated kit.

Note: If a kit type is changed to build-on-demand and there is an on hand balance in any warehouse or existing POs, sales orders, or transfers, a warning message is displayed. Click Save to save the changes anyway.

Tally

This distinguishes a product as the parent of the components attached to the tally product. The system assumes all tally products are specified dimensional tally products unless you select the Random Comp Mix or Allow Memo Tally options.

Nonstock Kit

Another type of kit is a nonstock kit, also referred to as a build-on-demand kit. These kits do not have Product or Kit Production records. Nonstock kits can only be entered in Sales Order Entry by selecting the Kit field on the Non Stock window.

Order Entry Kit Rollup

You can roll the price, cost, or both of each kit component into the price and/or cost of the kit. Rolling means that the individual component costs are added together and the total is used as the kit cost. Costs are rolled depending upon the SA Administrator Options-Products-Costs Which Cost to use for GL option and is obtained from the Product Warehouse Product Setup record, unless you have selected FIFO costing, in which case the cost from the Product FIFO Setup record is used. If the price is rolled up, the base price for each component is added together for the price of the kit. The base price and cost on the kit record are ignored. The commission cost (also calculated based on the cost settings in SA Administrator Options-Products-Costs) is rolled only when the OE Kit Rollup option is cost or both. For cost pricing, the costs of the components will be rolled, then a PD Pricing Setup record is created for the kit. Prices are not rolled on fabricated kits. Because components are not available, this field is ignored for fabricated kits, and the General Ledger cost from the tied work order or warehouse transfer is used.

Select Blank if you do not want the component prices and/or costs rolled into the kit. If you have activated the National Program functionality, and you have components of kits that qualify for National Program, ensure this field is set to blank. You do not want the component prices or costs rolled into the kit. This is because one or more of the components is priced for a National Program.

The Pricing Cost roll option is valid for BOD kits but not for prebuilt kits. If Pricing Cost is selected, the PD Pricing Setup record cost is rolled. The GL cost is always rolled regardless of this option.

Print on Invoice

Specify whether components should be listed on documents. Select this option if the kit components of build-on-demand kits should be individually printed on Sales Order Entry invoice, delivery notes, and acknowledgements. The components of build-on-demand kits are automatically printed on pick tickets so the warehouse personnel can assemble the kit.

Random Comp Mix

When you select this field, the product becomes a random dimensional tally. This type of tally contains any mix of components that equals the total linear feet ordered.

Req N/S Component

Indicate whether required nonstock components exist on the kit. When this field is selected and a build-on-demand kit is entered in Sales Order Entry, the operator must access the Kit Components window. An error message appears if the operator attempts to exit the window without adding the nonstock component.

VA Assembly Type

This field applies to the primary assembly-type product. Select Preset for assembly-type items with components of variable length. Select Configurable for assembly-type products with variable components, including, but not limited to, variable lengths. Select Not Assembly for non-assembly items. By default, Not Assembly is selected for all products.

If this item in a non-kit item that you want set up for Infor Infor CPQ (CPQ), select Configurator.

VA Cutoff Length

Specify the amount to add to the order length to compensate for material lost in the product’s manufacture or assembly. This field applies to components of the primary product.

VA Cutoff Unit

Specify the unit of measure for the cutoff length. Leave this field blank to use the stocking unit of measure. This field applies to components of the primary product.

Category

Alternate Product Group

Specify an alternate product group for the product. If the Report to Supplier option is selected on the Alternate Product Group record, sales, rebate, and inventory information for products assigned to this alternate product group must be sent to the supplier when using electronic communications.

The value you specify here is validated against the alternate product group table values created in SA Table Code Value Setup. This is an optional setting.

If you create a Product Setup record from a Product Catalog Setup record in Sales Order Entry, the Alternate Product Group value is copied to the Product Setup record but can be changed.

Brand

Use this field to associate a brand code with a specific product number. Adding a brand code to a product record improves your ability to quickly find (with auto-lookup or keyword search) the product your customer is requesting. Often, the product number is unknown, but the brand code is remembered. Using this field is also beneficial if the manufacturer changes their number or brand; you can update that number within the record, but your product number remains the same (retaining your product sales data under one number).

Brand codes are set up in SA Table Code Value Setup.

Category

The product category is used for General Ledger and Sales Manager updating. It is important because many Product and Sales Manager reports can be generated in product category order or for a product category range. Sales Order Entry and Purchase Order Entry can distribute to General Ledger balance sheet and income accounts according to the product category (inventory, uninvoiced inventory, core charge, gross sales, line discount, order discount, cost of goods). The product categories are set up in SA Table Code Value Setup.

Changed On

Update this date each time the composition of the product changes. The customers must have the most current MSDS sheet available to them. The next time the product is sold in Sales Order Entry, this date is compared to the MSDS Sent date. The MSDS Sent date is updated in one of these ways:

During Sales Entry Processing Invoice Processing if the Update Sales Manager option is set to Yes
During Sales Entry Processing Sales Manager Update if you do not update Sales Manager during invoicing.

Country

Used to assign the Country of Origin, that is, where a product was manufactured, produced, or grown. This value prints on the Commercial Invoice Document. When used in conjunction with an HS Code or tariff code, it further defines the criteria for a particular rate. This field must be set up in SA Table Code Value Setup.

ECCN

If you have set up Export Control Classification Number (ECCN) codes in SA Table Code Value Setup, you can assign an ECCN code to the product. This value is included in the order line in Sales Order Entry and other applicable records and documents.

HS Code

This field can be used to assign HS Codes or other kinds of tariff codes to a product. A harmonized tariff code is part of the Harmonized Commodity Description and Coding System that was created by the World Customs Organization (WCO). The HS system uses a logical nomenclature method to categorize goods into approximately 5,000 commodity groups. Countries often assign customs duties based on the harmonized tariff code of the product. You must set up the HS Code in SA Tariff Rate Setup.

LIFO

Used to group products in specific groups if LIFO valuation is employed. The LIFO category must be set up in SA Table Code Value Setup.

Mfg Prod

Use this field to assign a manufacturer's product number to the product. The value you specify in this field is not validated, but it is searchable. Adding a manufacturer's product number improves your ability to quickly find (with auto-lookup or keyword search) the product your customer is requesting.

Model

If you have activated the National Program functionality, and you participate in National Programs that use product model numbers, you can associate that number with a product. For example, some Manufacturers require a specific model number for a claim to be submitted and reimbursed; or, a specific model number has one price and another model number has a different price. Product model numbers are created in SA Table Code Value Setup for National Program.

NCNR

Select this option to designate the product as non-cancellable or non-returnable (NCNR). This notifies your buyers and customer service reps that it should only be added to sales or purchase orders when the customer is aware that the order cannot be canceled, or when the item cannot be returned to you or to the vendor for a full refund. The NCNR flag is displayed in Sales Order Entry, Purchase Order Entry, and Purchase Demand Center Entry.

Products that are designated as NCNR cannot be entered on a Return Merchandise (RM) order or return line in Sales Order Entry or Purchase Entry Order unless the option, Allow Entry of NCNR in SA Operator Setup - OE/PO Entry Options is selected for the operator. This security setting is also required before you can delete or cancel a line for a NCNR product.

Preference

When you select a Tier and specify a Tier Group, you can also select a Preference. (If you set up a preference in Product Warehouse Product Setup, it overrides your selection here.)

A preference is a priority attribute (such as choice of warehouse) used in conjunction with a tier and a tier group. Select a value that you have defined in SA Table Code Value Setup-Product Preference type.

Standard Repair Time

When a value is specified in this field, it is added to the SRT Product Code in the Sync.ItemMaster BOD, which is sent to Service Management. When the BOD is consumed in Service Management, the value is validated against the SRT Master and captured in the Item master to indicate that SRT applies to that Item.

The Standard Repair Time field is a free-form, alphanumeric, three-character field. Typically, the characters are specific to the manufacturer and are grouped by industry or type of service; for example, electrical (ELE). You can use SA Mass Maintenance Administration to add the SRT to integrated product records.

This field is available only if the option, Service Management Active, is selected in SA Administration-Administrator Options-Integrations-Service Management.

Tier

Select a Tier and specify a Tier Group. A tier is a product attribute (such as quality, availability, location, and/or price) used in conjunction with a tier group and a preference. Select a value that you have defined in SA Table Code Value Setup-Product Tier type.

Tier Group

A tier group is used to group products of the same tier together, so these products display in the Tiers and Preferences context application. This is a freeform field with no validation, but it is key to using tiers and preferences.

UNSPSC Code

Specify the United Nations Standard Products and Services Code® (UNSPSC) for the product. UNSPSC is a global categorization method for products that facilitates Internet searching. This optional code can be up to a 12 alpha characters in length. It is not validated and can be updated through Product Import.

If you create a Product Setup record from a Product Catalog Setup record in Sales Order Entry, the UNSPSC value is copied to the Product Setup record but can be changed.

MSDS

Changed On

If you change the MSDS option for this product, or the number of the MSDS sheet, you must manually change the Changed On date. You should change this date if the composition of the product changes, the MSDS sheet number changes, or the components of a kit change. The next time the product is sold in Sales Order Entry, the system compares Changed On date with the MSDS sent date in SM Extended Totals Hazardous Report. This date stamps an order. The date stamp is displayed in the MSDS at Pick column in the Sales Order Entry-Details-Line Detail grid. Adjust your workflow so the customer has the appropriate MSDS sheet available to them.

MSDS

Indicates the product is potentially hazardous and requires that a Material Safety Data Sheet be provided to the customer. Select this option if this is an MSDS product. The system tracks the last purchase and the last date an MSDS form was sent out. The MSDS sent date is updated:

During Sales Entry Processing Invoice Processing if the Update Sales Manager option is set to Yes.
When the Product Hazardous Materials (MSDS) Report is generated.

When an MSDS sheet must be provided to the customer, a message is printed at the bottom of the pick ticket. MSDS information can be sent with the package, as specified on the pick ticket, or at a later time through Product Hazardous Materials (MSDS) Report.

Sheet #

Indicate a specific sheet number associated with this MSDS product. Each time a customer must receive an MSDS, the MSDS number is printed so the correct one can be sent.

eCommerce

EDI Code: If you are using Electronic Data Interchange (EDI), specify your two-character product/service ID qualifier in this field. This field relates to the X12 Document Map, Segment IT1, Element 6. If you are not using EDI, ignore this field.
External Webpage: The product web site specified by the product manufacturer.
Internal Webpage: Your internal web site for this product.

Catch Weight

Allow Purchase Order Tracking

Select this option to track and process this product as a catch weight product on purchase orders. When selected, the Actual Total Weight of a catch product must be specified in Purchase Receipt of Inventory Entry. This setting is used in combination with the activation settings in SA Administration-Administrator Options-Products-Defaults-Catch Weight. For a product to be tracked as a catch weight product on a purchase order, these settings are required:

The product must be designated as a catch weight product.
The option, Allow Purchase Order Tracking, must be selected.
In SA Administrator Options, the option, Enable Catch Weight Tracking, must be set to either, For Purchase Orders, or Both Sales Orders and Purchase Orders. If neither of these options is selected, the Allow Purchase Order Tracking option is ignored by the system.

If the SA Administrator Options are set for purchase orders, but the Allow Purchase Order Tracking is cleared for this catch weight product, catch weight tracking and processing for this product is not performed for purchase orders.

Allow Sales Order Tracking

Select this option to track and process this product as a catch weight product on sales orders. When selected, the Actual Total Weight of a catch product must be specified in Sales Shipping Feedback Entry. This setting is used in combination with the activation settings in SA Administration-Administrator Options-Products-Defaults-Catch Weight. For a product to be tracked as a catch weight product on a sales order, these settings are required:

The product must be designated as a catch weight product.
The option, Allow Sales Order Tracking, must be selected.
In SA Administrator Options, the option, Enable Catch Weight Tracking, must be set to either, For Sales Orders, or Both Sales Orders and Purchase Orders. If neither of these options is selected, the Allow Sales Order Tracking option is ignored by the system.

If the SA Administrator Options are set for sales orders, but the Allow Sales Order Tracking is cleared for this catch weight product, catch weight tracking and processing for this product is not performed for sales orders.

Catch Weight Product: This setting is used in combination with the activation settings in SA Administration-Administrator Options-Products-Defaults-Catch Weight. If the SA Administrator Options setting is not enabled, this Catch Weight section is not available. When this section is available, select this option to designate this product as a catch weight product. If selected, special processing is performed to handle catch weight products. When selected, additional fields in the section are available to configure catch weight processing.

Max Tolerance Amount: Optionally, for a catch weight product, specify a maximum allowable tolerance as an amount (weight). When a catch weight is specified in the Actual Total Weight field during receiving or shipping, the variance is calculated as the difference between the expected weight and the catch weight as an amount. If the variance exceeds the maximum tolerance amount specified here, a warning message is displayed: Warning: Catch Weight Tolerance Has Been Exceeded. This message is used only as a check to minimize unreasonable values being specified, but does not stop processing. Values specified in this field should normally be expressed as a unit of weight in stocking units of measure. For example, Max Tolerance Amount = 10 (lbs). If the expected weight = 50 (lbs), then an specified catch weight value below 40 or above 60 would trigger a warning message.

Max Tolerance %: Optionally, for a catch weight product, specify a maximum allowable tolerance as a percentage. When a catch weight is specified in the Actual Total Weight field during receiving or shipping, the variance is calculated as the difference between the expected weight and the catch weight as a percentage. If the variance exceeds the maximum tolerance percentage specified here, a warning message is displayed: Warning: Catch Weight Tolerance Has Been Exceeded. This message is used only as a check to minimize unreasonable values being specified, but does not stop processing. You can specify only Max Tolerance %, or you can specify a value for both tolerance fields.