Lookup item by GTIN in Sales Order Sales Line table

(2) Share

Report

Posted on by Johny Be Good

Hello guys,

I have added a GTIN column to the Sales Line table in the Sales Order page

Screen-Shot-2022_2D00_08_2D00_30-at-23.35.47.png

What would be the proper way to add ability to search an items by typing a GTIN value as it is possible in No. column? I made this column 'Lookup = true', but it seems to be not enough.

And another question: if I found some item by its number, what do I need to do to autofill GTIN column with item's GTIN value?

Thanks in advance for your reponses!

All responses (3)

Answers (1)

Peter Waugh 131 on at

Like (2)

Report

Lookup item by GTIN in Sales Order Sales Line table

Does this mean Sales Lines can also use FlowFields to link item references for Unit of Measure Reference type "Bar Code"

Type Item > GTIN Number

Unit of Measure Code > Bar Code Reference ?

Thank you

Peter
Johny Be Good 61 on at

Like (2)

Report

RE: Lookup item by GTIN in Sales Order Sales Line table

It works like a charm! Thanks for the article, it is really helpful.
Verified answer

YUN ZHU 81,360 Super User 2025 Season 1 on at

Like (3)

Report

RE: Lookup item by GTIN in Sales Order Sales Line table

Hi, The easiest way is to use Flowfields

More details: https://yzhums.com/5802/

And there is another way to use trigger of No. field or Sales Lines table.

When inserting and modifying No., autofill the GTIN number at the same time.

Hope this helps.
Thanks.

ZHU