cancel
Showing results for 
Search instead for 
Did you mean: 

Add gtin field when itemcode and barcode field used for other details

jbrotto
Active Contributor
0 Kudos

Hi,

We are being required to send documents by EDI and in some cases we might need to use the GTIN and UNSPSC with something called an EDI product code.

From my understanding our item code will be the EDI code. But this is where it is odd the barcode field we in the past many years ago made into the UNSPSC field, so when we make an invoice the barcode field shows UNSPSC information. Now the issue is how do we store GTIN information? I was thinking as in most cases it is 12-14 digit number (UPC or EAN) stored on GS1.

I not sure if there is a better way, but thinking of a UDV in the item master data. Then take UDF on a line item such as INV1 with a formatted search to fetch the data based on the item code.

Accepted Solutions (1)

Accepted Solutions (1)

former_member465537
Participant
0 Kudos

Hi,

FMS :

SELECT * FROM OITM T0 WHERE T0.[ItemCode] = $[$38.1.0]

You have to put UDF name at place of *.

Rgards,

Viral Prajapati

Answers (1)

Answers (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

If your GTIN information unique, then create UDF field in item master data and store GTIN information and then pull this information into AR Invoice line level based on item code.

Let me know if you need FMS query.

Regards,

Nagarajan

jbrotto
Active Contributor
0 Kudos

Yes how would we do the FMS?