Product Pack Info (IM23)

Additional Information
Create/Modify/Delete UCC-12 UPC
Create/Modify/Delete EAN/UCC-8/13
Create/Modify/Delete EAN/UCC-14
Elite WMS Overview
Elite WMS-GTIN/UOM/Dimensions
Troubleshooting IM13
Troubleshooting PFE-Elite WMS Interface
Understanding GTIN

The Product Pack Info (IM23) program updates the product (IM) and the supplier (PO) GTIN records. This program allows you to enter the following information for the product entered in the product code field:

  • One or more Global Trade Identification Number(s) (GTIN).
  • Pack information (including SKU Quantity, Inner Quantity, Weight, Width, Length, Height, Volume).
  • Container Information

Note: Every product and/or product/supplier record can have multiple GTINs associated with it.

The following list defines every field on the Pack Info folder:

  • Supplier – enter or select from the look up a supplier code.

    • The default value for this field is ******. When the default is entered, the Default Costing check box and the Supplier Product field are disabled.

    • When a supplier is entered, the SKU Default field is disabled.

    • If the product/supplier record is flagged for deletion in P/O Purchasing Information (ibis_popi.po13), the following message displays to the right of the supplier field: “Record flagged for deletion”.

  • Product - enter or select from the look up a product code to which to add GTIN and package details will be added.

    • If the product is flagged for deletion in Products (ibis_ici1.im13), the following message displays to the right of the notes icon(s): "Record flagged for deletion".

  • GTIN Type - select from the drop down list the "type" of GTIN or the EAN/UCC data structure to be scanned or entered into the GTIN field. GTIN is made up of the following four symbols:

    • EAN/UCC-8
    • UCC-12 UPC
    • EAN/UCC-13
    • EAN/UCC-14

    For more information on the GTIN, see Overview of GTIN.

  • Prefix - from the drop down list, select a number between 1 and 9. This field is only available when EAN/UCC-14 is selected as the GTIN type and when a 'Source' is selected in the Source field. The Prefix represents the first number or Indicator digit (packaging level) in the GTIN code.

    • If you leave the Prefix blank, the following message displays: "You must select a prefix within the range of 1 through 9. OK". Click OK to close the message window and then enter a number between 1 and 9 in the Prefix field.

  • GTIN - you have 5 options to input the bar code or number associated with the bar code on the Product or package:

    1. Scan the bar code.

    2. Enter the number associated with the bar code.

    3. Enter the first 7-digits of an EAN/UCC-8, 11-digits of a UCC-12 UPC, 12-digits of an EAN/UCC-13, or the first 13-digits of an EAN/UCC-14 and the system will automatically generate the check digit.

    4. If you are creating an EAN/UCC-14 from a Source, the GTIN automatically populates with the Prefix and Source entered, and the check digit is correctly calculated.

    5. The GEN button is available only when the GTIN Type is set to UCC-12 UPC.

      • The Generate option is password protected so when you click GEN the Password window opens. Enter the password defined in CC04 for IM23 and press Enter. A 14-digit UCC-12 code automatically displays in the GTIN field.

      • The GTIN number that is generated is based on the 'EAN UCC Company Prefix' field set in Company Entry (CC95). For example, when you click GEN, the 14-digit GTIN that is generated is comprised of the following: the first two digits will always be 00, followed by the EAN UCC Company Prefix from CC95, and the remaining digits are randomly generated.

      • For more information on the GTINs, see Overview of GTIN.

    Note: If you create a product that is associated with a second supplier but has the same GTIN, or if you create two different products with the same GTIN code, the following message displays: "This GTIN number is already assigned to another product/supplier code. Do you wish to assign it to this product/supplier as well? Yes/No".

    • If you click No, the GTIN information is cleared from IM23.

    • If you click Yes, you can continue to enter the remaining product pack information.

  • Measuring Units - from the drop down list, select the Measuring Units to be used on this folder for the current Product only. Valid options are:

    • U.S. - the US or Imperial system displays measurements in Inches (In), Pounds (Lb), Cubic Ft (CUft), etc.

    • Metric - displays measurements in Centimeters (Cm), Kilograms (Kg), Cubic Centimeters (CC), Cubic Meters (CuM), etc.

      Note: When the Measuring Units are set to Metric, the Measurement Grid contains an additional column for Cubic Meters (CuM).

      Note: The Measuring Units field defaults to the measuring unit associated with the Country selected in Company Entry (CC95) for the current company. For example, if the Country is set to Canada in CC95, then the Measuring Units field defaults to Metric. If the Country is set to United States of America, then the Measuring Units field defaults to U.S.

  • Source - select from the drop down list the 'GTIN' number to be used as the Common Base for the EAN/UCC-14 you are creating. This field is only available when the GTIN Type is set to EAN/UCC-14. This field contains GTIN codes already entered for the current Product.

    • This field is only available when the GTIN Type is set to EAN/UCC-14.

    • Note: You can create an EAN/UCC-14 without entering a Source GTIN.

  • GTIN Description - enter a description of the package, packaging level or item as required. You can enter a maximum of 30 alpha-numeric characters in this field. This is an optional field unless a WMS UOM is entered. Once a UOM is selected, the GTIN Description is mandatory.

    When the Elite WMS interface is in use and the GTIN is designated a UOM value, the GTIN description is sent to Elite WMS as the UOM description, with the following conditions:

    • If the Elite WMS interface is based on Elite WMS version 8.4 (as defined in the WMS Version field in CC00/WM), then the first 5 characters in the GTIN Description field are sent to Elite WMS as the UOM description.

    • If the Elite WMS interface is based on Elite WMS version 9.0 (as defined in the WMS Version field in CC00/WM), then the first 10 characters in the GTIN Description field are sent to Elite WMS as the UOM description.

    Note: If you have multiple UOMs for a product, each GTIN Description must be unique.

  • Transfer to WMS - this check box is automatically selected, indicating that this GTIN information will be transferred to a warehouse management system, such as Elite WMS or Accellos. You may de-select this option as required.

  • SKU Default - select this check box to set the SKU default for the Product to the current GTIN. The SKU default displays in the Measurements Grid on the Default SKU line for every GTIN record. The Weight and Volume from the GTIN flagged as the 'SKU Default' are displayed in the following programs:

    • Order and Quote Entry (ibis_oe30)
    • Invoice Direct Bill and Credit Entry (ibis_in41)
    • Retail Cash Counter Invoice Entry (ibis_rs41)
    • Shipping Documents Print (ibis_oe34)

    Note: If no GTIN is flagged as the 'SKU Default' record, the Weight and Volume used in these programs is zero and the SKU Quantity defaults to 1.

    • If the Product has only one GTIN associated with it, then select this check box. If multiple GTINs are applied to the Product, only one GTIN can be associated with the SKU defaults. Once this field is associated with a GTIN, it is unavailable or greyed-out.

    Note: The SKU Default flag is unavailable for EAN/UCC-14 GTIN Types.

    Note: If the 'Transfer SKUs GTIN from' flag in CC00/Warehouse Management Interface is set to 'Default SKU Record' and the current product contains inventory in any WMS warehouse:

    • You cannot remove the SKU Default flag from a GTIN record currently flagged as the SKU Default.
    • You cannot delete the GTIN flagged as the SKU Default.
    • You cannot add a GTIN to be flagged as the SKU Default.

  • Auto PS30 Update - when selected, the SKU weights and measurements for the GTIN are automatically applied to the Carton and display in the Weights and Measurements grid in PS30/Carton Details. GTIN records flagged as 'Auto PS30 Update' are also referred to as 'Predefined Standard Ship Packs'.

    • Note: You can flag multiple GTIN records for 'Auto PS30 Update'.

    • If the current product is type 'NI', then this flag is unavailable.

  • Default Costing – if the supplier/product record has only one GTIN associated with it, then select this check box. If multiple GTINs are applied to the supplier/product record, only one GTIN can have the cost factors applied. Once this field is associated with a GTIN, it is unavailable.

    The Default Costing field:

    • Identifies the GTIN to which the cube's or weight's rate from the cost factors are applied.

    • Identifies the default supplier product code to be displayed in the Supplier Product Code field in P/O Purchasing Information (ibis_popi.po13).

    • Displays the SKU quantity, weight and volume in P/O Proposed (ibis_po34).

    • Displays the SKU quantity in the master carton field in P/O Entry (ibis_po40) on the Detail Info folder and uses the weight and volume in the Weight and Volume fields in the PO40 Header record (PO40 displays the accumulated weight and volume).

    • Validates the order quantity to be a multiple of the SKU Quantity in PO40. If the ordered quantity in PO40 is not a multiple of the SKU quantity on the default costing GTIN record, the following message displays: "Quantity entered (the actual quantity entered displays) is not a multiple of the Master Carton as maintained in IM23. Valid quantities are ## and ##. Continue with this Quantity? Yes/No".

    Note: If the 'Transfer SKUs GTIN from' flag in CC00/Warehouse Management Interface is set to 'Default Costing Record' and the current product contains inventory in any WMS warehouse:

    • You cannot remove the default costing flag from a GTIN record currently flagged as the default costing record.

    • You cannot delete the GTIN flagged as the default costing record.

    • You cannot add a GTIN to be flagged as the default costing record.

  • Supplier Product – enter a supplier product code for the GTIN code. If the selected GTIN is flagged as the default costing record, the information entered in this field is copied to the Supplier Product Code field in P/O Purchasing Information (ibis_popi.po13) if the Supplier Product Code is blank.

  • OrderStream Transfer - you can only assign this flag to one GTIN code for the product. The GTIN that is flagged with the OrderStream Transfer is transferred to the inventory.tab files for the selected User IDs in e-Sales Customer and Inventory Export File Creation (ibis_es50).

  • WMS UOM # - enter or select from the drop list a UOM value. This field is only available when the 'Transfer to WMS' flag is selected and when the 'Transfer UOM 1-4 GTIN's' in CC00/Warehouse Management Interface is set to UOM GTIN Qty + Measurement.

    Note: Depending on the version of Elite WMS PFE interfaces to, you will have different UOM # options:

    • For Elite WMS versions 9.0 and lower, the interface can accommodate up to 4 UOMs for each product.

    • For Elite WMS version 9.1, the interface can accommodate up to 6 UOMs for each product.

    When a UOM is selected, the product/GTIN record's dimensions and weight are sent to the EliteSeries WMS Item Master.

    • Once a UOM is selected, the GTIN Description field becomes mandatory, and all dimensions must be entered for the GTIN record.

    • When WMS UOM 1 is selected, the SKU and Inner quantities must be set to 1.

    • When assigning multiple UOMs to a product, you must do so sequentially. For example, you must enter a GTIN with UOM1 followed by a GTIN with UOM2, and so on. If you skip UOM2 and attempt to add UOM3, the following message displays: "The product is missing UOM2. There may not be gaps in the UOM assignments. OK".

    • If you assign multiple UOMs to a product record, the SKU quantity must increase for each UOM.

    • The system does not allow duplicate GTINs with an assigned UOM to be sent to WMS.

      • If you enter a value in the GTIN UOM field and the GTIN record already exists (i.e. the GTIN is a duplicate) for a supplier/product record, the following message displays: "GTIN already exists with a UOM assigned. Do you wish to use this GTIN without a UOM? Yes/No".

      • If you click No, all of the information is cleared.

      • If you click Yes, the record is updated but the WMS UOM field is cleared. (The record is sent to WMS when you click Clear.)

In the 'Measurement Grid' section:

  • The following columns display information based on the original GTIN Source entered:

    • SKU Qty - the Stock Keeping Unit (SKU) represents the number of units at this packaging level. For GTIN Types UCC-12 UPC, EAN/UCC-8 and EAN/UCC-13, the SKU Qty is equal to the Inner Qty entered in the grid. For GTIN Type EAN/UCC-14, this column automatically updates based on the SKU Quantity entered for the original GTIN Source. For example, if the original GTIN Source has an SKU Qty of 15, and an Inner Qty of 4 is entered, then the SKU on this GTIN record is 60 (4 x 15). Note: If the GTIN has a WMS UOM assigned to it, the following rules apply:

      • For UOM1, the SKU Qty must be set to 1.

      • The SKU quantity must increase with every consecutive UOM.

    • Inner Qty - enter the smallest quantity you ship to your customers for this packing level. A minimum of 1 must be entered in this field. The Initial and Revised Estimate lines can be zero (0).

    • Weight - enter the Weight associated with the Product for this packaging level. The Weight is displayed in Lb (Pounds) or Kg (Kilograms) depending on the selection in the Measuring Units field.

    • Length - enter the Length associated with the Product for this packaging level. The Length is displayed in In (Inches) or Cm (Centimeters) depending on the selection in the Measuring Units field.

    • Width - enter the Width associated with the Product for this packaging level. The Width is displayed in In (Inches)or Cm (Centimeters) depending on the selection in the Measuring Units field.

    • Height - enter the Height associated with the Product for this packaging level. The Height is displayed in In (Inches) or Cm (Centimeters) depending on the selection in the Measuring Units field.

    • Volume - the Volume associated with the Product for this packaging level can be automatically calculated based on the Length, Width and Height entered or the Volume can be manually entered, if the Length, Width or Height are set to 0.

      • The Volume is displayed in CuFt (Cubic Feet) or in CC (Cubic Centimeters) and CuM (Cubic Meters) depending on the selection in the Measuring Units field.

      • If you manually enter the volume in CC, the system automatically populates the equivalent value in the Volume-CuM field. Similarly, if you manually enter the volume in CuM, the system automatically populates the equivalent value in the Volume-CC field.

  • On the Detail line in the Measurements Grid, enter the information for the current GTIN.

  • On the Initial Est. line, enter information that is used for comparision purposes only.

  • On the Revised Est. line, enter information that is used for comparision purposes only.

  • The Default SKU line displays the information from the GTIN record marked 'SKU Default' for this Product.

Below the Measurements Grid, the following Container Information fields are available:

    Note: These fields are for information purposes only and are associated with the current GTIN record.

  • Cases/Tier - enter the number of Cases per Tier. You can enter a maximum of 9999.

  • Tiers/Pallet - enter the number of Tiers per Pallet. You can enter a maximum of 9999.

  • Pallets/Truckload - enter the number of Pallets per Truck load. You can enter a maximum of 9999.

  • Units/Container - enter the number of Units per Container. You can enter a maximum of 999,999.

  • Container Volume - the calculated Container Volume automatically displays based on the Volume from the Detail line (in the Measurements Grid) and the Units/Container quantity. If no Volume is entered on the Detail line, the value will be calculated from the Revised Estimated Volume.

The GTIN List box at the bottom of the screen displays a summary of the GTINs entered for the Product. The following columns are included in the list box:

  • GTIN - the 14-digit GTIN code.
  • Flag - the Flag column is either blank, displays S to indicate 'SKU Default', T to indicate 'Transfer to WMS', A to indicate 'Auto PS30 Update', Y to indicate 'Order Stream', 1 to indicate 'WMS UOM' or a combination of 'S', 'T', 'A', 'Y', '1'.
  • Type - identifies the GTIN Type.
  • GTIN Description
  • SKU Qty
  • Inner Qty
  • Weight
  • Length
  • Width
  • Height
  • Volume
  • Supplier Product

If you recall a GTIN that is associated with an EAN/UCC14 record, the following message displays: "GTIN Code is associated with an EAN/UCC-14 record(s). The EAN/UCC-14 code(s) must be deleted before the Inner Qty can be accessed. Supplier GTIN of the associated record . OK". If you want to update the GTIN record that has been recalled, you can update every field but the inner quantity. In order to update the inner quantity field, you must delete the EAN/UCC14 record to which the original GTIN is associated.

The following table outlines the functionality of each button in Product Pack Info (ibis_im23):

Button Label Icon Functionality
Clear Clear Clears all of the fields, except the supplier field which returns to the default value of ******. If you integrate to an EliteWMS warehouse, when you click clear, the GTINs are sent to WMS.
Product Notes Product Notes Opens the Product Notes (ibis_imnot1) view allowing you to add a new note for the product.
Existing Product Notes Product Notes Opens the Product Notes (ibis_imnot1) view allowing you to modify an existing note for the product.
Update Update Updates the current GTIN information for the product entered in the header section.
Note: If you recall a GTIN EAN/UCC12 record that is associated with another GTIN record, you can update every field but the inner quantity. In order to update the inner quantity field(s), you must delete the record to which the original GTIN is associated.
Delete Delete Deletes the GTIN from the product entered in the header section.
Note: If you are deleting a GTIN UCC12-UPC, a password is required. If you want to delete a GTIN that is associated with another GTIN (for example, a GTIN EAN/UCC14 is associated with a GTIN EAN/UCC12, and you want to delete the GTIN EAN/UCC12 record), the following message displays: "GTIN Code Used as an INNER. The code must be disassociated from the MASTER(s) before the code can be deleted. OK". In this case, you must delete the GTIN EAN/UCC14 record before you can delete the GTIN EAN/UCC12 record.
Note: If the GTINs contain UOM designations, you must delete the GTINs in reverse order.
New New Clears the fields allowing you to enter another GTIN for the current product.