PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 03/21/2017 3:32 PM by  Jason
GTIN-A Field not in ICITEMGTIN
 0 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Jason
Application Support Specialist
Sanford
(9 points)
Posts:5


Send Message:

--
03/21/2017 3:32 PM

    Hello, we have recently started uploading GTIN's to our item master and I am trying to create a SQL report to validate the information. The problem I am running in to is the IC11.7 field that the GTIN is put into does not seem to exist in the ICITEMGTIN table that a Cntrl+Shift+O reveals. Cntrl+Shift+O shows that the GTIN as a text string is located in ICITEMGTIN.GTIN-A. The Addins Upload that we use to populate the information is also pointed at GTIN-A. In the actual table and in Addins query however, all I am seeing is a field called GTIN. GTIN is numeric so it trims the leading zero's. I need to find where this GTIN-A field is hidden so I can pull the GTIN's as text and retain the leading zero's for verification purposes. If anyone knows where this GTIN-A field is actually stored I would really appreciate the treasure map

    You are not authorized to post a reply.