Skip to main content
Dynamics 365 Community / Forums / Finance forum / Default date sorting o...
Finance forum

Default date sorting of tables in D365FO

editSubscribe (0) ShareShare
Posted on by 276
Why are tables sorted to show oldest to newest by default? Is this possible to change?
I have received questions about this from many users, who argue that it doesn't make sense to show old records first.
I am fully aware that one can click on the column to change the sorting, but I am wondering if it is possible to change the default sorting for the entire system.
  • Verified answer
    Komi Siabi Profile Picture
    Komi Siabi 12,241 Super User on at
    Default date sorting of tables in D365FO
    There is no parameter that will auto change the sorting on grid across the entire system. You can either applying filter using saved views, or use query with range on the menu item of the form via Visual studio.
  • Verified answer
    Layan Jwei Profile Picture
    Layan Jwei 2,801 Super User on at
    Default date sorting of tables in D365FO
    Hi Gaute_K,

    One option is to save a new view and pin it as default.

    Open the form - click on "Date" field and sort newest to oldest - save the view as - tick "pin as default view"

    Layan Jweihan
    Please mark the answer as "Verified" if it solved your question. In order to help others as well

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…


Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,068 Super User

Martin Dráb Profile Picture

Martin Dráb 222,591 Super User

nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans