Skip to content

Feature - Support GTIN Based on Two Different UPC Codes

Date Released - 7/27/16

The purpose of this feature is to allow the user more flexibility when setting up GTIN codes.

GTIN (Global Trading Item Number) is a 14-digit UPC code with the package code as the first digit + a 13-digit UPC code. For a 12-digit UPC code, you will just add a leading zero to make it 13 digits. The package code will represent the number of boxes in a case. Typically, the inner boxes will be encoded with a UPC code (12 or 13 digits), and the outside box will be encoded with a GTIN (14 digits) based on the same UPC code.

Sometimes a vendor does not implement GTIN correctly. Instead of using the same UPC code base on the inner box to create the GTIN on the outer case, they choose to use two different UPC codes for the inner box and outer case. That is to say, they treat the inner box and outer case as two different products. Then, later on, they add the GTIN based on the outer case UPC code.

The GTIN maintenance application has been changed to allow for this situation. When launching the GTIN maintenance application, a list of the GTIN codes on file is displayed. This list now shows the user if the GTIN or UPC code was manually entered or if it based upon the UPC code in the Item Master file and what type of code was entered.

When adding a new UPC or GTIN code in the GTIN Maintenance application, the user will specify what type of code they are entering.

The valid options are: 8 for UCC-8, U for UCC-12, E for UCC-13, and G for GTIN.

If the user enters G for GTIN, they must indicate if the GTIN is linked or based off the UPC code found in the Item Master File.

If Y, the user will enter the package code and the quantity per case.

If the GTIN is not linked to the Item Master file, the user must manually enter the GTIN. The package code and UPC code associated with this manually entered GTIN are calculated and displayed on the screen. The user must also enter the quantity per case.

If the user enters anything other than G for the code type, the application will allow the entry of just a UPC number without it being associated with a GTIN. This gives the user more flexibility.

When the user presses return from the code list screen, they are able to view the code that was entered. In Change mode, only the quantity per can be changed. If the GTIN, UPC code, or package code needs to be changed, the user must delete the code and then add the correct information in a new record.

If the user changes the UPC code on the Item Master, only records that are linked will be changed and recalculated. Manually entered codes will not be changed.

If the user changes the UPC code on the Item Master to spaces, they will receive a prompt asking if related records should be deleted. If they answer Y, only GTIN records that are linked to the UPC on the Item Master file will be deleted. Manually entered records will remain on file.

If the user deletes the item from the Item Master file, all of the GTIN records on file for the item will be deleted.

Some applications in the system allow for scanning of the GTIN/UPC code and the quantity per case will be returned to the program for processing. With this new feature, if the user scans the UPC code on the Item Master, a quantity of 1 will be returned to the application. If the GTIN or the derived UPC code from a manually entered GTIN are scanned, the quantity per specified on the GTIN record will be returned to the application.


Feedback and Knowledge Base