Creating/Modifying/Deleting EAN/UCC-14

Creating an EAN/UCC-14 in IM23:

  1. In the Header section of IM23:

    • In the Supplier field, enter or select from the query a required supplier code.

    • In the Product field, enter or select from the query the required product code.

  2. In the GTIN Type field, select EAN/UCC-14 from the drop down list.

  3. You have four options to input the EAN/UCC-14 code into the GTIN field:

    • Scan the EAN/UCC-14 code.
    • Enter the EAN/UCC-14 code.
    • Enter the first 13 digits and the system will automatically generate the check digit.
    • In the Source field, scan or select from the drop down list the base number for EAN/UCC-14 code. The base number can be any existing GTIN code from the list. The drop down list contains all GTIN codes created for this Product in IM23.

      • Once the Source is entered, the Prefix field becomes available allowing you to select an indicator digit that represents the packaging level. From the drop down list, select a number between 1 and 9. Note: The same source can be selected for an EAN/UCC-14 up to 9 times, as long as the prefix is different each time.

      • The GTIN field automatically populates with the prefix and source entered, and the check digit is correctly calculated.

    If the GTIN number is already associated with another supplier/product record, 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". Select 'Yes' to add this GTIN number to the current Supplier/Product record. Select 'No' to close the message window and add a new EAN/UCC-14 code.

    Note: The GEN icon is disabled when the GTIN Type is EAN/UCC-14.

  4. If you want to change the Measuring Units, select the appropriate option from the drop down list. Valid options are:

    • U.S. (Imperial)
    • Metric

  5. The GTIN Description field an optional field. 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.

  6. The Transfer to WMS check box is automatically selected. The information for this GTIN will be transferred to a warehouse management system, such as Elite WMS. You can de-select this option as required.

  7. The SKU Default check box is unavailable for EAN/UCC-14 GTIN codes.

  8. On the Detail line in the 'Measurement Grid':

    • Enter the Inner Qty or the smallest quantity you ship to your customers for this packing level. A minimum of 1 must be entered in this field.

      Once the Inner Quantity is entered, the SKU Qty field automatically updates to a value based on the SKU Qty 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).

    • Enter the Weight associated with the Product for this packaging level.

    • Enter the Width associated with the Product for this packaging level.

    • Enter the Length associated with the Product for this packaging level.

    • Enter the Height associated with the Product for this packaging level.

    • 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 and Height fields on the Detail, Initial Estimate or Revised Estimate lines are all populated, the Volume field for all lines will not be available for manual input. The Volume can be manually entered only if one of the Length, Width or Height fields is set to zero on all three lines (it does not have to be the same field on all three lines).

      Note: All measurements in the Grid are displayed in the Measuring Units identified in the Measuring Units field on this folder.

  9. On the Initial Est. line in the 'Measurement Grid', enter information used for comparison purposes only.

  10. On the Revised Est. line in the 'Measurement Grid', enter information used for comparison purposes only.

  11. The Default SKU line displays the information from the GTIN record flagged 'SKU Default' for this Product.

  12. The Container Information is optional. Complete the following fields as required:

    • Enter the number Cases/Tier for this packaging level. You can enter a maximum of 9999.

    • Enter the number of Tiers/Pallet for this packaging level. You can enter a maximum of 9999.

    • Enter the number of Pallets/Truckload for this packaging level. You can enter a maximum of 9999.

    • Enter the number of Units/Container of this packaging level. You can enter a maximum of 999,999.

    • The Container Volume is automatically calculated based on the Volume from the Detail line (in the Measurements Grid) and the Units/Container quantity. If the Volume on the Detail line is zero, the Container Volume is calculated from the Revised Volume, if available.

  13. When all of the information is entered, click Update Update to add the information to the supplier/product record.

  14. The GTIN List box at the bottom of the screen displays a summary of the GTINs entered for the supplier/product.

Modifying an EAN/UCC-14 in IM23:

  1. In the Header section of IM23:

    • In the Supplier field, enter or select from the query a required supplier code.

    • In the Product field, enter or select from the query the required product code.

  2. In the GTIN list box at the bottom of the screen, select (i.e. double-click) on the GTIN record you wish to modify. The information automatically displays in the fields, the Grid and the list box.

  3. Make changes as required and click Update Update to update the GTIN record.

    • If the EAN/UCC-14 selected for modification is the Source of an EAN/UCC-14, the following message displays: "GTIN Code 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 (the Supplier Code displays) GTIN (the GTIN record displays) . OK".

      • Click OK to close the window. You can make any changes to all fields for the EAN/UCC-14 code with the exception of the Inner Qty field in the Grid for the Detail line, Initial Estimate Line and Revised Estimate line. When the changes are complete, click Update.

      • If you want to update the Inner Qty in the Grid, you must first delete the EAN/UCC-14 record(s) that contains the EAN/UCC-14 as its Source. Once this is done, you can recall the EAN/UCC-14 record and make modifications to the Inner Qty information in the Grid.

Deleting an EAN/UCC-14 in IM23:

  1. In the Header section of IM23:

    • In the Supplier field, enter or select from the query a required supplier code.

    • In the Product field, enter or select from the query the required product code.

  2. In the GTIN list box at the bottom of the screen, select (i.e. double-click) on the GTIN record you wish to delete. The information automatically displays in the fields and the grid.

  3. Click Delete Delete to delete the GTIN from the supplier/product record.

    • Note: You cannot delete an EAN/UCC-14 if it is the Source code for another EAN/UCC-14. If the EAN/UCC-14 Is the Source code for another EAN/UCC-14, 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." Click OK to close the message window, and then delete the EAN/UCC-14 record(s) that contain the EAN/UCC-14 as its Source. Once this is done, you can recall and delete the EAN/UCC-14 code.

  Back