Skip to main content

Notifications

Announcements

No record found.

Business Central forum
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

Categories:
  • pankaj.k Profile Picture
    pankaj.k 960 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 960 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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans