Creating/Modifying/Deleting EAN/UCC-14

Creating an EAN/UCC-14 in PO13:

  1. In the Header section of PO13:

    • Enter or select from the query a Supplier in the Supplier field.

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

  2. Go to the Pack Information folder.

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

  4. 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, 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. If the 'Include IM13 GTIN for EAN/UCC-14 Source' check box is selected in Company Control Initialization (CC00/Purchasing), the drop down list will contain all GTIN codes created for this Product, including GTIN codes created in Maintain Inventory Master (IM13). GTINs created in IM13 are denoted by an * to the left of the GTIN number.

      • 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 or with another Product in Maintain Inventory Master (IM13), 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.

  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. If 'Default Costing' has not been assigned to any other GTINs for this Supplier/Product record, then the Default Costing field is available. If 'Default Costing' has been assigned to a GTIN, then this field is unavailable or greyed out.

  9. Enter a code in the Supplier Product Code for this GTIN. This is an optional field. When the GTIN is set up as the 'Default Costing' GTIN, the Supplier Product Code entered also displays in the 'Supplier Product Code' field on PO13/Purchasing.

    Note: If a Supplier Product Code is entered in PO13/Purchasing, the Supplier Product Code entered for the Default Costing record will override it.

  10. 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 Supplier/Product record for this packaging level.

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

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

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

    • The Volume associated with the Supplier/Product record 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.

  11. On the Initial Est. line in the 'Measurement Grid', enter the information Estimated by the Supplier for the current GTIN.

    • When all of the Initial Estimate information is entered and this record is flagged as the Default Costing record, the Est. Unit Cost field automatically displays. If there are no Cost Factors set up for this Supplier/Product record in PO13/Cost Factors, the Est. Unit Cost is equal to the Landed Cost.

    • When all of the Initial Estimate information is entered and this record is flagged as the Default Costing record, the %Change automatically displays the percentage change between the Initial Estimate Unit Cost and the Landed Cost. The Replacement Cost is calculated as the Landed Cost for the Primary Supplier.

  12. On the Revised Est. line in the 'Measurement Grid', enter the Revised Estimates provided by the Supplier for the current GTIN.

    • When all of the Initial Estimate information is entered and this record is flagged as the Default Costing record, the Est. Unit Cost field automatically displays. If there are no Cost Factors set up for this Supplier/Product record in PO13/Cost Factors, the Est. Unit Cost is equal to the Landed Cost.

    • When all of the Initial Estimate information is entered and this record is flagged as the Default Costing record, the %Change automatically displays the percentage change between the Revised Estimate Unit Cost and the Landed Cost. The Replacement Cost is calculated as the Landed Cost for the Primary Supplier.

  13. The Default SKU line displays the information from the GTIN record flagged 'SKU Default' for this Product in IM13/Pack Info.

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

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

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

Modifying an EAN/UCC-14 in PO13:

  1. In the Header section of PO13:

    • Enter or select from the query a Supplier in the Supplier field.

    • Enter or select from the query a Product in the Product 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. Make changes as required and click Update (on the folder) 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 PO13:

  1. In the Header section of PO13:

    • Enter or select from the query a Supplier in the Supplier field.

    • Enter or select from the query a Product in the Product 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 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