Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Lookup item by GTIN in Sales Order Sales Line table

Posted on by 55

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!

  • Johny Be Good Profile Picture
    Johny Be Good 55 on at
    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 Profile Picture
    YUN ZHU 73,698 Super User 2024 Season 2 on at
    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/

    pastedimage1661904525574v1.png

    pastedimage1661904533568v2.png

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans