Products (ICI1_IM13)

The Products (ibis_ici1.im13) table allows you to create an maintain products kept in your inventory. Products entered here are used throughout PointForce iTopia, including inventory control, order entry, invoicing, physical inventory, purchasing and retail sales modules.

A product includes:

• Stock information which defines the characteristics of the product including stock keeping units, serial and/or lot controls, split quantity, and so on;
• Selling information which identifies the tax, royalty, and commission codes, catalogues, packaging details, material composition, and so on;
• Miscellaneous information which includes data sheet (MSDS) information, warranty, shelf life, images/picture file, Internet and Intranet web sites URLs, manufacturing details, and so on;
• Reference information which indicates the date on which the product was retired, the date on which the product was flagged for deletion, and the user id that flagged the deletion, and so on.

The following list defines every field available in the products (ici1) table in alphabetical order:

• 3rd Catalog Page - enter the page number on which the current product displays in the third catalogue. For more information, please see the Catalogue topic.

• Active Months Last Year - displays the number of months the product was active during the last year.

• Active Months This Year - displays the number of months the product has been active during the current year.

• Allow returns for product - this field is reserved for future use.

• Alternate Description - (this field is from the Inventory Secondary file (ibis_icsd)) enter an alternate description for the product as required. This field can be used to enter a description in a second language. You can enter up to 35 alpha-numeric characters. Note: The language set up in the Customers (SU13) view or in the P/O Suppliers (PO11) view determines whether the description or the alternate description prints.
  • Note: If you have the 'WMS Version' field set to 'Elite WMS' (any version) in CC00/Warehouse Management Interface, you cannot use the following characters in the alternate description field: ^ < >.

  • If you have the 'WMS Version' field set to 'Elite WMS' (any version) in CC00/Warehouse Management Interface, you cannot use the following characters in the alternate description field: ^ < >.

• Alternate Second Description - (this field is from the Inventory Secondary file (ibis_icsd)) displays the color code set up in the Product Colors (ibis_ick.im09) view and prints on some forms and reports if the 'Use second description' field is selected in CC00/Inventory Control and if space allows.

• Associated Item - enter or select from the lookup a valid product code with which this product is associated. For example, you sell the same generic product to customers but you package it differently or put a unique logo on it for each customer. This product is a variation of the generic item. The product code for the generic item is entered in the associated item field.
  • In Product Consolidated Inquiries (ibis_ic45) you can enter the generic product code and view all the products that are associated with it. This is helpful for checking stock levels and purchasing commitments.

• Assortment Factor - enter the factor used to calculate the "Factored Quantity" that is applied to the assortment pricing calculation. This field is only available when a code is entered in the assortment pricing code field. When you enter an assortment pricing code, this field defaults to '1'. You can update this field as required; valid options are 0.01 to 99999.

• Assortment Pricing Code - assign an assortment pricing code to products that are from the same product 'family' or group. Assortment pricing codes are defined in the Assortment Pricing (ibis_icas.im90) table. The order quantities for all products with the same assortment pricing code are added together and the applicable detail lines are re-priced based on the accumulated amount.
  • For more information, please see the Assortment Pricing topic.

  • The Assortment Pricing Code field is available only when the assortment pricing check box is selected in CC00/Inventory Control.

• Attachments – displays the product document that was added using the Browse option in the Attachments section.

• Bar Code Print Flag - select this option to print labels for the product when it is received.
  • When this option is selected, the Customer Product Label Print (IM42) screen automatically opens if you click on Product Labelling from the Tools menu on the P/O Receipt and In Transit Entry (PO60) screen.

• Catalogue Code 1 - enter or select from the look up the catalogue code associated with the primary catalogue page number entered. For more information, please see the Catalogue topic.

• Catalogue Code 2 - enter or select from the look up the catalogue code associated with the secondary catalogue page number entered. For more information, please see the Catalogue topic.

• Catalogue Code 3 - enter or select from the look up the catalogue code associated with the 3rd catalogue page number entered. For more information, please see the Catalogue topic.

• Character Code - enter or select from the look up a character code. Character codes identify products by the character they represent. For example, you may stock various Disney products, and character codes like 'Cinderella' or 'Snow White' can be applied. Character codes are defined in the Product Characters table (ibis_icch.im09).
  • With the Character Code, you can identify all products representing the same character using Crystal Reports or iTopia.

• Class Code - enter or select from the look up a class code. Class codes are used to group products together for reporting and inventory reordering. Every product is assigned a class code. Class codes are maintained in ABC Classes (IM01). The default class code for new products is A.
  • Class code 'X' indicates that the product is flagged for deletion (by Inactive Product Deletion (IM16)). When a product is flagges for deletion, Order and Quote Entry (OE30) does not allow the order quantity to be greater than the quantity available on new order lines; P/O Entry (PO40) does not allow the product to be ordered on a new purchase order; and PO Preliminary Generation (PO23) skips these products on proposed POs.

• Color Scheme - enter or select from the look up a color scheme code. Color scheme codes identify products with the same color scheme or pattern. For example, you may stock chairs, cushions and drapery fabric in a paisley color scheme/pattern. Color schemes are maintained in the Product Color Schemes (ibis_ichc.im09) table.
  • With the Color Scheme code, you can identify all products with the same color scheme or pattern using Crystal Reports or iTopia.

• Commission Group - enter or select from the look up a commission group code. Commission group codes represent a subdivision within a commission line. For example: lamps, furniture, area rugs, and art work are examples of groups in the Household Goods product line. When the 'Code Used for Calculation' is set to 'Commission' in CC00/Order Entry, then the commission group code is mandatory. Commission groups are maintained in the S/A Commission Lines and Groups (ibis_sa04) table. For more information on commission groups, please see the SA Commission Lines and Groups help topic.

• Commission Line - enter or select from the look up a commission line code. Commission line codes allow you to categorize products into a broad grouping for commission purposes, for example Household Goods. When the 'Code Used for Calculation' is set to 'Commission' in CC00/Order Entry, then the commission line code is mandatory. Commission lines are maintained in the S/A Commission Lines and Groups (ibis_sa04) table. For more information on commission lines, please see the SA Commission Lines and Groups help topic.

• Commit Lot/Serial - (this field is from the Inventory Secondary file (ibis_icsd)) indicates when the serial or lot number is entered into the system. For more information, please see the Lot/Serial Control Overview topic. Note: Every product requires a code in the commit lot/serial field. The following options are available from the drop list:
  • N - no serial or lot numbers are required for this product. The commit lot/serial default for new products is N.
  • O - serial/lot numbers are entered during the order entry (OE30) process. The serial/lot number(s) print on the picking slip. Procedurally, this means that the order desk identifies the serial and/or lot numbers to ship to the warehouse pickers. The serial/lot numbers are confirmed and modified, if necessary, during invoicing.
  • I - serial/lot numbers are entered during the invoicing (IN41) process. Procedurally, this means that the warehouse pickers decide the serial/lot numbers that will be shipped. Blank lines print on the picking slip to provide space for the pickers to note the serial and/or lot numbers. The picking slip is sent to invoicing for processing.

• Commodity - the commodity code is used to categorize products into various product lines and product groups. The Products view includes both the product line and product group fields.
  • Commodity codes are maintained in the Commodities (IM02) table.

  • For more information on commodity codes, please see the Commodities (IM02) topic.

• Common Product - are products that share the same pricing and purchasing characteristics. From the drop list, select 'Yes' or 'No' to indicate whether the product is a common product. When the common product field is set to Yes, the product is linked with other products in the master file.
  • When any of the common fields are changed for any one of the common products, a special updating feature automatically updates the corresponding field on all other common products. For example, if you change the price for 1234BEARS-RED, the price also changes for 1234BEARS-GREEN and for all corresponding common products.

  • For more information, please see the About Common Products help topic.

• Company - the company field is available when you create a new product record. The company defaults to the company assigned to your user id in the Session Parameters view. You can change the default company during the product code creation process only. Once the product is created, the company to which the product is associated displays in the General section (at the top of the view).

• Consigned Units - displays the consigned units of the product as determined by the Invoice and Credit Note Update (IN43) program.

• Created By - displays the name of the user who created the record you are viewing or maintaining. May not be overridden.

• Created On - displays the date on which the record that you are creating or maintaining was created. May not be overridden. May also represent the creation date of the records you are attempting to retrieve.

• Customer Part Numbers - enter or select from the look up a customer part number for the product. Customer part numbers are maintained in the Customer Part Numbers (IM40) table.

• Delete Run Numbers - this field is reserved for future use.

• Description - enter a description of the product code. The description field is 35 characters in length. The description displays and prints on all product related reports (Inventory, Purchasing, Sales, etc.) and documents (Picking Slips, Invoices, Bills of Material, Work Orders and so on). You can use the description field to search for a product in OE30, IN41 and RS41.
  • Note: If you have the 'WMS Version' field set to 'Elite WMS' (any version) in CC00/Warehouse Management Interface, you cannot use the following characters in the description field: ^ < >.

• Developer Code - enter or select from the look up a developer code. Developer codes identify products made by the same developer. Developer codes are maintained in the Product Developers (ibis_icdc.im09) table.
  • With the developer code, you can identify all products made by each developer using Crystal Reports or iTopia.

• EAN - enter the European Article Numbering (EAN) code for the product. The EAN is part of the Global Trade Item Number (GTIN) standard in product identification. Specifically, GTIN is the foundation for the EAN.UCC (European Article Numbering and Uniform Code Council) system for uniquely identifying trade items sold, delivered, warehoused, and billed throughout retail and commercial distribution channels.

• Exclusive Flag - select this check box to indicate that the product is exclusive or limited. You can use this flag identify all exclusive products using Crystal Reports or iTopia.

• Flagged for Deletion By - this field is not maintainable. The user or system process that flagged the record for deletion.

• Flagged for Deletion on - this field is not maintainable. The date on which the record was flagged for deletion.

• Forecast Calculation Code - indicates the forecast calculation code assigned to this product. Forecast calculation codes are maintained in the P/O Forecast Calculations (ibis_po07) table. The code identifies how a forecast for the amount of product likely to be sold this month should be calculated.
  • If the product is a non-inventory (NI) type, this field automatically defaults to REG and cannot be modified.

• Fragility Code - enter or select from the look up a fragility code. Fragility codes identify products made from fragile components, for example: glass, crystal, paper and so on. Fragility codes are maintained in the Product Fragility Codes (ibis_icfr.im09) table.
  • With the fragility code, you can identify all products made from fragile components using Crystal Reports or iTopia.

• Full Image - displays an image of the product if a .jpg file of the product is located in the ici1 directory. The full image file name must match the product code, for example: if the product code is ABC123, then the image file must be names ABC123.jpg.
  • For more information on images and image locations, please see the Image Location in iTopia for PFE 7.1 and higher topic.

• Future Product Price List - opens the Future Pricing Transfer (IM22) program allowing you to enter future price lists for the current product.

• General Ledger - is one of the factors used to determine the GL Control Accounts updated for this product as a result of posting customer invoices, inventory adjustments or stock receipts. Product GL codes are maintained in the Product G/L Codes (ibis_icgl.im09) table.
  • For more details on setting up G/L Control Accounts for Invoice postings, see CC00/Invoicing/GL.

  • For more details on setting up G/L Control Accounts in a Receipts Accrual system, see CC00/Purchasing/General Ledger.

  • For more details on setting up G/L Control Accounts for Inventory Adjustments, see Inventory Adjustment G/L Assignment (ibis_icga.im44).

• Global Trade Number - displays the UCC-12 UPC code entered for the product in Product Pack Info (IM23).

• Harmonized Tariff Number - enter the harmonized tariff number for the product. The Harmonized Tariff System Number is a 10-digit numeric code, formatted as follows: '0000.00.0000'. The harmonized tariff number is used for reporting purposes only. The tariff number prints on the Export Invoice Print (IN52) report.

• Height per SKU in CM - enter the height per stock keeping unit (SKU) in centimeters for the current product.

• Hold for Packaging Approval - when this check box is selected, the product is on hold pending packaging approval. You cannot purchase products flagged on hold for package in approval in P/O Entry (PO40).

• Hold for Product Approval - when this check box is selected, the product is on hold pending product approval. You cannot purchase products flagged on hold for product approval in P/O Entry (PO40).

• Include for Order Stream - when this check box is selected, the product is uploaded to order stream when the inventory file is created. When this check box is not selected, the product is not included in the export to order stream process.

• Inventory Brands - allows you to easily identify all products with the same inventory brand name. The inventory brand codes are maintained in the Inventory Brands (ibis_icib.im09) table.

• Inventory Master Warehouse Information - Create - opens the Inventory Master Warehouse Info view allowing you to add a new warehouse for the product.

• Inventory Master Warehouse Information - Edit - if you hover over this link, you can view the existing warehouses for the current product. If you click on this link, the Inventory Master Warehouse Info view opens allowing you to edit an existing warehouse for the product.

• Item Status - enter or select from the look up a status code for the product, for example you can assign an item status of C for Clearance to an item. Item status examples include trade show sell offs, best sellers, old stock and so on. Item status codes are maintained in the Item Statuses (ibis_icis.im09) table.
  • The item status code is used in conjunction with Order Discount Limits (OE04). Depending on the item status and order type, OE04 indicates the reference price list that should be used to determine the effective discount. Depending on the limits set in OE04, the sales order may be flagged for a pricing hold or a pricing review for discount in excess of these limits. The effective discount is reported by item status on the Order Pricing Hold Management (OE62) view.

• Latest Landed Replacement Cost - displays the latest landed replacement cost for the product from one of the following sources:
  • PO Purchasing Information (PO13) - when the product/supplier record is created, the landed replacement cost is calculated in PO13 and updates this field.

  • PO Land Factor Revisions (PO65) - if landing factors are corrected after the product has been received, then the latest landed replacement cost is updated by this table.

  • Quick Product Creation (IM99) - if a product is created with purchasing data and inventory information, then the latest landed replacement cost is updated by this table.

• Length per SKU in CM - enter the length per stock keeping unit (SKU) in centimeters for the current product.

• Licensed Name - enter or select from the look up a licensed name code. Licensed name codes identify products by their licensed name, for example: you may stock products with licensed names like Disney or Warner Brothers. Licensed name codes are maintained in the Licensed Names (ibis_icln.im09) table.
  • Using the licensed name code, you can identify all products by license using Crystal Reports or iTopia.

• Lot Control Flag - (this field is from the Inventory Secondary file (ibis_icsd)) identifies products with lot number control. For more information, please see the Lot/Serial Control Overview topic. Note: Every product requires a lot control code. The following options are available from the drop list:
  • N - no lot number is required. The lot control default for new products is N.
  • M - lot control is by the manufacturer's lot number.
  • P - lot control is by the production lot number assigned by your company.
  • B - lot control is by both the manufacturer's lot number and the lot number assigned by your company.

    Note: When using codes M, P or B, ensure the lot control option is selected in Company Control Initialization (CC00/Inventory Control).

• Lot Size 1 - this field is currently not in use.

• Lot Size 2 - this field is currently not in use.

• Mark-Up Category Code - enter or select from the look up a mark-up category code for the product. Mark-up category codes are assigned to products that have the same price change being applied. Mark-up category is used as a 'select sequence' in the Selling Price Recalculation (IM28) program. Mark-up category codes are defined in the Product Mark-up Categories (ibis_icmc.im09) table.

• Material Type 1 - enter or select from the look up a material code that is associated with the primary material type. Product material types are maintained in the Product Material Types (ibis_icma.im09) table. For more information, please see the Product Material Composition and Percentage topic.

• Material Type 2 - enter or select from the look up another material code for the product, if required. Product material types are maintained in the Product Material Types (ibis_icma.im09) table. For more information, please see the Product Material Composition and Percentage topic.

• Material Type 3 - enter or select from the look up another material code for the product, if required. Product material types are maintained in the Product Material Types (ibis_icma.im09) table. For more information, please see the Product Material Composition and Percentage topic.

• Material Type 4 - enter or select from the look up another material code for the product, if required. Product material types are maintained in the Product Material Types (ibis_icma.im09) table. For more information, please see the Product Material Composition and Percentage topic.

• Material Type 5 - enter or select from the look up another material code for the product, if required. Product material types are maintained in the Product Material Types (ibis_icma.im09) table. For more information, please see the Product Material Composition and Percentage topic.

• Material Type 6 - enter or select from the look up another material code for the product, if required. Product material types are maintained in the Product Material Types (ibis_icma.im09) table. For more information, please see the Product Material Composition and Percentage topic.

• Material Type 7 - enter or select from the look up another material code for the product, if required. Product material types are maintained in the Product Material Types (ibis_icma.im09) table. For more information, please see the Product Material Composition and Percentage topic.

• Material Type Percent 1 - enter the percentage of the product that is made from the associated material type code. Note: Material type 1 is the primary material type and must have the highest percentage amount. For more information, please see the Product Material Composition and Percentage topic.

• Material Type Percent 2 - enter the percentage of the product that is made from the associated material type code. For more information, please see the Product Material Composition and Percentage topic.

• Material Type Percent 3 - enter the percentage of the product that is made from the associated material type code. For more information, please see the Product Material Composition and Percentage topic.

• Material Type Percent 4 - enter the percentage of the product that is made from the associated material type code. For more information, please see the Product Material Composition and Percentage topic.

• Material Type Percent 5 - enter the percentage of the product that is made from the associated material type code. For more information, please see the Product Material Composition and Percentage topic.

• Material Type Percent 6 - enter the percentage of the product that is made from the associated material type code. For more information, please see the Product Material Composition and Percentage topic.

• Material Type Percent 7 - enter the percentage of the product that is made from the associated material type code. For more information, please see the Product Material Composition and Percentage topic.

• Material Type Percent Other - the system displays the percentage remaining or outstanding as you enter the materials and percentage. This field is for display purposes only. For more information, please see the Product Material Composition and Percentage topic.

• Maximum Tally - this field is currently not in use.

• Measuring Units - enter or select from the drop list the measuring units used for the current product. Valid options include:
  • U.S. - the imperial method of unit measurement, i.e. inches, pounds, cubic feet, and so on.
  • Metric - the metric method of unit measurement, i.e. centimeters, kilograms, cubic meters, and so on.

• Models and Assembled Sets - opens the Models and Assembled Sets (IM29) program allowing you to enter model or assembled set information for the current product.
  • For more information on assembled set, please see the Assembled Sets Overview topic.

  • For more information on models, please see the Models Overview topic.

• Modification Counter - this field is not maintainable. The date and time the record was last modified.

• Modified By - this field is not maintainable. The user or system process that last modified the record.

• Modified On - this field is not maintainable. The date on which the record was last modified.

• Nested Inventory Master Warehouse Information – displays the warehouse information for the current product. Allows you to add or modify a warehouse to the product record. The inventory master warehouse information (ibis_icwm) table is automatically updated.

• Nested Master Price Lists – displays the master price lists embedded view for the current product. Allows you to add, modify or delete a master price list to the product record. The master price list (ibis_icplp) table is automatically updated.

• Nested Product Notes – Displays the product notes embedded view for the current product. Allows you to add, modify or delete a product note to the product record. The product notes (ibis_imnot1) table is automatically updated.

• Number of Pieces/Selling Unit - identifies the number of pieces contained in a single stock keeping unit (SKU). The default for new products is 1.
  • Here's an example:
    • 500 sheets of paper = 1 Package
    • SKU = PKG
    • Split Qty = 1
    • Number of Pieces/Selling Unit = 500

• Number of Styles in Assortment - identifies the number of styles in the assortment. This field is enabled only for products with a product type of AI (Assortment Item). You can enter a maximum of 999 styles. For more information, please see the Assortment Items (IM31) topic.

• P/O Purchasing Information - opens the P/O Purchasing Information (PO13) program allowing you to enter purchasing information for the current product.

• Package Description - enter or select from the look up a package description code. Package descriptions identify products with the same packaging, for example: you may have products packaged in wooden boxes, printed boxes, red boxes or cone shaped boxes. Package description codes are maintained in the Package Descriptions (ibis_icpk.im09) table.
  • With the package description code, you can easily identify products by their package description using Crystal Reports or iTopia.

• Package Design - enter or select from the look up a package design code. Package designs identify products with the same package design, for example: you may stock products with a floral design on the package. Package Design codes are maintained in the Package Designs (ibis_icpa.im09) table.
  • With the package design code, you can identify all products with the same design on the package using Crystal Reports or iTopia.

• Packing Information - opens the Product Pack Info (IM23) program allowing you to enter packing information for the current product including: the GTIN, weights and measurements, and so on.

• Picture File - this field allows you to enter the name of a picture file that overrides the full image and/or thumbnail image files. Because full and thumbnail images require a file name that matches the product code, each image must be unique. The picture file field has no naming constraints, thereby allowing you to use one image for multiple products.
  • For example, you may stock various colored pencils, each with a unique product code. Using the picture file, you can store one image of the pencils and use that image for each unique pencil product code instead of storing multiple pencil images (one to match each product code).

  • For more information on images and image locations, please see the Image Location in iTopia for PFE 7.1 and higher topic.

• Price Breaks - this field is reserved for future use.

• Primary Catalogue Page Number - enter the page number on which the current product displays in the primary catalogue. Note: During order entry, you can search for a product using the primary catalogue page number. For more information, please see the Catalogue topic.

• Primary Supplier Code - displays the supplier code and supplier name of the primary supplier for the product. This information is set up in the PO Purchasing Information (PO13) table. The primary supplier code cannot be edited in the products view.

• Product Code - the product code is available when you create a new product record. Once the product is created, the code displays in the General section (at the top of the view). The length of the product code is determined during installation and can vary from company to company. (The typical length of the Product Code field is 20 characters.) You may use an alpha-numeric combination. The product code is a mandatory field and every product must have a unique code.
  • Note: You cannot begin a product code with special characters, for example, you cannot use .,-^=&';*+[]/ (i.e. &Vase).

  • You cannot use a backslash / in the product code. Product codes containing a / will cause issues with the views that are nested in the Products view.

  • In addition, if you have the 'WMS Version' field set to 'Elite WMS' (any version) in Company Control Initialization (CC00/Warehouse Management Interface), you cannot use the following characters in the product code: " { . , / ( ) * + & < >.

  • Once a product code is entered and updated, the code can only be altered by means of Product Re-code Merge (RM81/82). The product may be recoded to a new code or merged with an existing code.

  • You can create Common Products and Special Products using the product code field. For details on these, click on the links listed below:
    • Common Products
    • Special Products

  • Note: You can use the product code field to search for a product in Order and Quote Entry (OE30), Invoice Direct Bill Credit Note Entry (IN41) and Cash Counter Invoice Entry (RS41).

• Product Compliance - opens the Product Compliance (OE06) program allowing you to enter product compliance information for the current product.

• Product Documents Directory – enter the path to a directory where files pertaining to the product exist on your network. Note: A UNC path is constructed from the name of the server, the name of the share on that server and is followed by any additional subdirectories within the share. For example, \\Server\Share\SubDirectory1\SubDirectory2. The path provided in a UNC type field is not validated by iTopia.

• Product Group - every product is assigned a product group code. Product group codes are a sub-division of products within a product line, for example Planters which are part of the Gardening product line. Product groups are maintained in the Commodities (IM02) table. You can use the product group code to search for a product in order entry (OE30), invoice/direct bill/credit note entry (IN41), and retail sales entry (RS41).
  • For more information on product groups, please see the Commodities (IM02) topic.

• Product Line - every product is assigned a product line code. Product line codes allow you to categorize products into a broad grouping, for example Gardening products. Product lines are maintained in the Commodities (IM02) table. You can use the product line code to search for a product in order entry (OE30), invoice/direct bill/credit note entry (IN41), and retail sales entry (RS41).
  • For more information on product lines, please see the Commodities (IM02) topic.

• Product Notes - Create - opens the Product Note Query allowing you to create a new product note.

• Product Notes - Edit - if you hover over this link, you can view the existing product notes for the current product. If you click on this link, the Product Note Query view opens allowing you to edit an existing note for the product.

• Product Price List - Create - opens the Price Lists - Product view allowing you to create a new price list for the product.

• Product Price List - Edit - if you hover over this link, you can view the existing price lists for the current product. If you click on this link, the Price Lists - Products view opens allowing you to edit an existing note for the product.

• Product Publishing - opens the EC Product Publishing Entry (EC13) program allowing you to enter e-Commerce product publishing information for the current product.

• Product Tax Code - enter or select from the look up a tax code. Product tax codes are maintained in the Invoice Product Tax Exceptions (IN07) table.
  • Each Product is assigned a product tax code that is used by the tax routine to identify any 'exceptions to the rule' when calculating taxes on this Product.

  • For more information, please see the Invoice Product Tax Exceptions topic.

  • For an overview of the Tax Set Up, please see the Tax Overview topic.

• Product Tests - enter or select from the look up a product test code. Some products may require testing before they are shipped, and the product test code enables you to easily identify where the product is in the testing cycle. Product test codes are maintained in the Product Tests (ibis_icpt.im09) table.
  • With the product test code, you can identify all products at each stage in the testing cycle using Crystal Reports or iTopia.

• Product Type - a 2 character code assigned to every product. Depending on the code selected, specific processing is performed during order entry and invoice processing. The following product type codes available from the drop list:

  PP	-	Purchased Product
  CP	-	Class Product
  AS	-	Assembled Set
  MO	-	Model
  DP	-	Data Sheet for MSDS
  FM	-	Family Product
  WO	-	Work Order Product
  AI	-	Assortment Item
  NI	-	Non-Inventory

• Product UDF Boolean Character 1-5 - this field is used for potential customization purposes. The field may be used at a specific customer site to store non-generic information, which may be required by other (host) systems.

• Product UDF Character 1-10 - this field is used for potential customization purposes. The field may be used at a specific customer site to store non-generic information, which may be required by other (host) systems.

• Product UDF Date 1-5 - this field is used for potential customization purposes. The field may be used at a specific customer site to store non-generic information, which may be required by other (host) systems.

• Product UDF Numeric 1-5 - this field is used for potential customization purposes. The field may be used at a specific customer site to store non-generic information, which may be required by other (host) systems.

• Product Unit Demand History Entry - opens the Product Unit Demand History Entry (IM64) program allowing you to adjust 24 months of regular and flyer demand unit history for the current product.

• Promo Product Code - this field is reserved for future use.

• Reason for Deletion - this field is available when the class code is set to 'X' flagging the product for deletion. Enter the reason for deleting the product in this field. You can enter a maximum of 30 characters in this field.

• Recoded to Product - if the current product has been recoded to another product code, the new product code displays in this field. Products are recoded in the Product Recode and Merge Entry (RM81) table.

• Release Date - enter or select from the calendar look up a release date for this product.

• Retired Date - enter or select from the calendar look up a retire date for this product.

• Royalty Code - enter or select from the look up a royalty code. Royalties are shares of the product or profit reserved by the vendor. Royalty codes are maintained in the S/A Commission Royalty Rates (SA05) table. For more information on royalties, please see the Royalty Set Up & Reporting Overview topic.

• Sales Conversion Code - enter a sales conversion code in this field for the product. This field is for information purposes only.

• Season - enter or select from the query a season code. Season Codes are assigned to products that are available for a specific season only. Season codes are maintained in the Seasons (ibis_icsc.im09) table and include the start and end dates for the season. When you assign a season code to the product, the season start date and season end date display the dates from the seasons table.
  • When a product has a season code, you can set the system up to display a warning message in Order and Quote Entry (OE30) to identify when products from different seasons are on the same sales order. The message is a warning only and the sales order can still be processed. To set this up, ensure the Enable Season Code Warning check box is selected in Company Control Initialization (CC00/Order Entry).

• Secondary Catalogue Page Number - enter the page number on which the current product displays in the second catalogue. For more information, please see the Catalogue topic.

• Secondary Location - enter the secondary bin location for the product in this field.

• Second Description - (this field is from the Inventory Secondary file (ibis_icsd)) displays the color code set up in the Product Colors (ibis_ick.im09) view and prints on picking slips, invoices, bills of material and work orders if the 'Use second description' field is selected in Company Control Initialization (CC00/Inventory Control).

• Selling Status - enter or select from the look up a selling status code. Selling status' categorize how the product is selling by tagging the product with a status code, for example: popular, selling quickly, sold out-returning, sold out-not returning, selling slowly, and so on. Selling status codes are maintained in the Product Selling Statuses (ibis_icss.im09) table.
  • With the selling status code, you can identify all products with a specific status using Crystal Reports or iTopia.

• Serial Number Control - (this field is from the Inventory Secondary file (ibis_icsd)) identifies products with serial number control. For more information, please see the Lot/Serial Control Overview topic. Note: Every product requires a serial number code. The following options are available from the drop list:
  • N - no Serial Number required. The serial number control default for new products is N.

  • R - track the serial number from the point of receiving stock. When the product is received, the serial number is recorded in P/O Receipt and In Transit Entry (PO60).

  • I - track the serial number from the point of invoicing. The serial number is recorded on the picking slip and is entered into IN41 once the product has been picked.
    • Note: The use of serial numbers committed at invoicing does not include 'prebilled' orders because the invoice is automatically generated as a byproduct of scheduling the order. The goods are not picked when the invoice is created so the serial numbers are unknown. Warehouse transfers do not record serial numbers when the transfer is invoiced because the product has technically not been sold.

    • Note: In multi-bin environments, you should never use this option. If you have serialized products that do not require tracking, we recommend that you set up the product as a "PP" type and record the serial numbers as a comment line on the invoice.

      If you want to track the serialized product in a multi-bin environment, you can set the serial number control to 'R' (receiving) and set the commit lot/serial field to 'I' (invoicing) or 'O' (order entry).

  Caution: You cannot change a product coded "N" for no tracking to R" or "I" in the following situations:

  • If the product is a component of an assembled set as defined in Models and Assembled Sets (IM29). Assembled sets cannot contain components with serial number tracking. If this situation arises, redefine the set as a model (which allows serialized components) and then change the serial number control flag.

  • If the product has stock in any warehouse. If this situation arises, the stock on hand must be temporarily adjusted to zero via Inventory Adjustment Entry (IC50), the serial number control codes can be changed and then adjusted back in via IC50, along with the appropriate serial numbers.

  • If the product is shippable on an outstanding sales order. In this scenario, the shippable order lines must be deleted. The serial number control codes can be changed and then the order lines can be re-entered.

• Sort Sequence Code - the sort sequence code is an optional code that can be a maximum of six characters in length. This code provides another tool for reporting purposes that is different from both the product code and the commodity code. PointForce iTopia maintains a commodity/sort sequence code cross-reference to the IM13 file. The Inventory Listing (IM15) report has the option to sequence the report by commodity/sort sequence code.

• Special Features - enter or select from the look up a special feature code . Special features identify the unique or special features of the product, for example: you may have products with 'bells and whistles'. Special feature codes are maintained in the Product Special Features (ibis_icsf.im09) table.
  • With the special features code, you can identify all products with the special feature, like 'bells and whistles', using Crystal Reports or iTopia.

• Split Quantity - is the standard shipping quantity for a product. During order entry (OE30), the order quantity is validated as a multiple of the Split quantity value. If the order quantity is NOT a multiple of the split quantity, a warning message displays allowing the operator to continue or re-enter the quantity ordered. If the operator continues and the product is flagged as 'non-stocked', then a password is required to proceed (Note: Passwords are maintained in Password Overrides (CC04)). The carton must be opened and the appropriate quantity removed. Here's an example:
  • A coffee cup set is packaged in a master carton with a total of 24 coffee cups.
  • The master carton contains 4 boxes, each with 6 coffee cups.
  • The smallest quantity we want to sell to our customers is the box with 6 coffee cups. The inner pack or split quantity is 6 coffee cups.

• Stock Keeping Unit - the stock keeping unit code (SKU) for a product represents the smallest unit in which the product is stocked and sold. An SKU is assigned to every product and the default for new products is each (EA). When sales orders and invoices are processed, the transaction quantity is expressed in this unit of measure. The SKU is maintained in the Unit of Measure (ibis_icm.im09) table.
  • If you want to enter twelve (12) items in Order and Quote Entry, for example, then you can do either of the following options, depending on how the SKU is defined for the item:
    • If the SKU of the product is EA (Each), then you order 12.
    • If the SKU is DOZ (Dozen) then you order 1.

• Stock/Non Stock Flag - indicates the stock type for the product. Order quantities are validated based on the code entered here. The following options are available from the drop list:
  • S - stocked product. Order quantities are validated to be a multiple of the product's split quantity but non-standard order quantities are allowed. Stocked products are used in the automated reordering modules of PointForce iTopia, allowing purchase orders to be generated automatically.
  • N - non-stocked product. Order quantities must be a multiple of the product's split quantity. A password is required to proceed (Note: Passwords are maintained in Password Overrides (CC04)). You can manually create a purchase order in P/O Entry (PO40) for any quantity required for non-stocked products. Sales orders for non-stocked products are listed on the P/O Receiver Print and Query (PO43) receiving copy.
  • R - retail items are considered non-stocked or special items. You can manually create a purchase order in PO40 for any quantity required, but these items are not used in the automated reordering modules.

• Substitute Products - opens the Substitute Products (IM14) program allowing you to enter substitute product(s) for the current product.

• TAT Code - this is an optional field. Enter or select from the lookup a TAT code for the product.
  • When the product is entered on an order in Order Entry (ibis_oe30) or a direct bill/credit note in Invoices Direct Bill & Credit Note Entry (ibis_in41), or through a reatil sale in Retail Cash Counter Invoice Entry (ibis_rs41), the TAT code defaults to the TAT code assigned to the product.

• Theme Code - enter or select from the query a theme code. Theme codes identify products with the same theme, for example: Halloween, Valentine's Day, Mother's Day, and so on. Theme codes are maintained in the Product Themes (ibis_ictc.im09) table.
  • With the theme code, you can identify all products with the same theme using Crystal Reports or iTopia.

• Thumbnail Image - displays an image of the product if a .jpg file of the product is located in the ici1 directory. The thumbnail image file name must match the product code, for example: if the product code is ABC123, then the image file must be named ABC123.jpg.
  • For more information on images and image locations, please see the Image Location topic.

• WMS Lot Controlled - select this check box to identify to the Elite WMS system that the current product is lot controlled. This field is available when an Elite WMS warehouse is set up in CC00/Warehouse Management Interface. For more information on Elite WMS, please see the Elite WMS Overview topic.

• WMS Overpicking Allowed - select this check box to allow overpicking in an EliteSeries WMS warehouse. This field is available when an Elite WMS warehouse is set up in CC00/Warehouse Management Interface. For more information on Elite WMS, please see the Elite WMS Overview topic.

• WMS Serial Controlled - select this check box to identify to the Elite WMS system that the current product is serial controlled. This field is available when an Elite WMS warehouse is set up in CC00/Warehouse Management Interface. For more information on Elite WMS, please see the Elite WMS Overview topic.

For the functionality of each action (i.e. button) available on this view, refer to the About the Actions topic.