Lookup item by GTIN in Sales Order Sales Line table

(3) 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!

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

YUN ZHU 95,597 Super User 2025 Season 2 on at

Like (4)

Report

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

Was this reply helpful? Yes No
Johny Be Good 61 on at

Like (3)

Report

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

Was this reply helpful? Yes No
Peter Waugh 145 on at

Like (3)

Report

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

Was this reply helpful? Yes No