Maintain Inventory Master (IM13)

Creating/Modifying/Deleting EAN/UCC-8 and EAN/UCC-13

Creating an EAN/UCC-8 or EAN/UCC-13 in IM13:

  1. In the Header section of IM13:

    • Enter or select from the query a Product in the Product Code field.

  2. Go to the Pack Information folder.

  3. In the GTIN Type field, select EAN/UCC-8 or EAN/UCC-13 from the drop down list.

  4. You have three options to input the EAN/UCC-8 or EAN/UCC-13 code into the GTIN field:

    • Scan the EAN/UCC-8 or EAN/UCC-13 code.
    • Enter the EAN/UCC-8 or EAN/UCC-13 code.
    • Enter the first 7 digits of the EAN/UCC-8 or enter the first 12 digits of the EAN/UCC-13 and the system will automatically generate the check digit.

    Once you Tab out of the GTIN field, the 8 or 13 digit number is automatically converted to a 14-digit code (right justified; zero filled).

    • If the GTIN number is already associated with another Product or with another Supplier/Product record in Maintain Purchasing Info (PO13), 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 UCC-12 UPC code.

    Note: the GEN icon is disabled when the GTIN Type is EAN/UCC-8 or EAN/UCC-13.

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

    • U.S. (Imperial)
    • Metric

  6. 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.

  7. The Transfer to Third Party check box is automatically selected. The information for this GTIN will be transferred to a Third Party, such as Radio Beacon. You can de-select this option as required.

  8. The SKU Default can be assigned to only one GTIN per Product. The SKU Default check box only applies to UCC-12 UPC and EAN/UCC-8 and -13 GTIN Types. This check box is available when no other GTIN has been defined as the 'SKU Default' record for the current Product. The values in the Measurements Grid associated with the SKU Default record display in the Grid on the Default SKU line for every GTIN record associated with this Product.

    Note: The Product's Weight and Volume per the Default SKU are stored in the Product Master File record (both U.S. and Metric values are stored). These values are used to calculate an Order's weight and volume, which are displayed in the OE30/Totals and IN41/Totals folder and are printed on the picking slip. If a SKU Default is NOT assigned, then no weight or volume will be accumulated for that Product on the Order. If none of the Products on the Order have a Default SKU assigned, then no weight or volume at all will be printed on the picking slip.

  9. 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 equal to the Inner Qty.

    • 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.

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

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

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

  13. 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.

  14. When all of the information is entered, click Update (on the folder) to add the information for the GTIN to the Product.

  15. The GTIN List box at the bottom of the screen displays a summary of the GTINs entered for the Product.

Modifying an EAN/UCC-8 or EAN/UCC-13 in IM13:

  1. In the Header section of IM13:

    • Enter or select from the query a Product in the Product Code field.

  2. On the Pack Information folder, click on the appropriate GTIN line in the GTIN list box at the bottom of the screen. The information automatically displays in the fields, the Grid and the list box.

  3. Make changes as required and click Update (on the folder) to update the GTIN record.

    • If the EAN/UCC-8 or EAN/UCC-13 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-8 or EAN/UCC-13 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-8 or EAN/UCC-13 as its Source. Once this is done, you can recall the EAN/UCC-8 or EAN/UCC-13 record and make modifications to the Inner Qty information in the Grid.

Deleting an EAN/UCC-8 or EAN/UCC-13 in IM13:

  1. In the Header section of IM13:

    • Enter or select from the query a Product in the Product Code field.

  2. On the Pack Information folder, click on the appropriate GTIN line in the GTIN list box at the bottom of the screen. The information automatically displays in the fields and the grid.

  3. Click Delete (on the folder) to delete the GTIN from the Product.

    • Note: You cannot delete an EAN/UCC-8 or an EAN/UCC-13 if it is the Source code for an EAN/UCC-14. If the EAN/UCC-8 or EAN/UCC-13 is the Source code for an 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-8 or EAN/UCC-13 as its Source. Once this is done, you can recall and delete the EAN/UCC-8 or EAN/UCC-13 code.

  Back