Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

DropDown Sort change

Posted on by 100

Hi,

Fellow NAV/BC Developers, I hope your all doing good. 

I have a requirement were I want to sort and display the dropdown for the Item Number on the Sales Line based on the Description from A-Z.  

Right now, it gets sorted and shown on the dropdown by Item No. I want to change that to Description.

DropwDown-Sales-Line.PNG 

Thanks in advance. 

Johnson Patrick

  • pankaj.k Profile Picture
    pankaj.k 962 on at
    RE: DropDown Sort change

    Please verify my answer it will helps to community.

  • Johnson_Patrick Profile Picture
    Johnson_Patrick 100 on at
    RE: DropDown Sort change

    Hi Manan,

    Thanks for your reply. The users want it to already sorted and i have already taken care of the requirement. :)

    Thanks

    Jp

  • Johnson_Patrick Profile Picture
    Johnson_Patrick 100 on at
    RE: DropDown Sort change

    Hi Pankaj,

    It worked like a charm! Thank you so much for finding solution so quick. Appreciate it :)

  • Suggested answer
    pankaj.k Profile Picture
    pankaj.k 962 on at
    RE: DropDown Sort change

    Hi Johnson_Patrick

    you need to create "Item Lookup" page extension and write some code for the sorting as below.

    1321.Capture2.PNG

    pageextension 50199 ItemLookUpPKPageExt extends "Item Lookup"
    {

        trigger OnOpenPage()
        begin
            Rec.SetCurrentKey(Description);

        end;
    }
    8585.Capture1.PNG
    Please check its working... :-)
    Thanks 
  • Suggested answer
    Manan_Shah Profile Picture
    Manan_Shah 1,457 on at
    RE: DropDown Sort change

    Hi Johnson,

    To achieve need to do development, please ask your development partner to develop functionality for it. Like when user open item look up page it's default apply filter on Description. 

    Without development. User can follow below process. 

    1) On Sales Line click on Item no. field. on item selection page, user have click on description field down arrow. On this User need to select Descending. 

    pastedimage1670501428539v1.png

    After this all record are sorted with description field. 


    Hope this will help.

    Many Thanks,
    Manan

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans