web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to save starting d...
Small and medium business | Business Central, N...
Suggested answer

How to save starting date descending list in a currency exchange rate list page

(1) ShareShare
ReportReport
Posted on by SR-23070510-1 26
Hi All, 
 
When I open exchange rate, the data shows ascending. Each time, i need to click on starting date and descending. 
Is there any way to save it so that when I open currency exchange rates, the starting date directly shows in descending order 
There's no way to save this as well.
Please help.
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 60,847 Super User 2025 Season 2 on at
    How to save starting date descending list in a currency exchange rate list page
    You have to write code in OnOpenpage trigger to sort it
    Rec.Ascending(false);
  • Suggested answer
    Jeffrey Bulanadi Profile Picture
    Jeffrey Bulanadi 6,963 on at
    How to save starting date descending list in a currency exchange rate list page

    Hi,

    The default sort behavior on list pages like Currency Exchange Rates can be frustrating when it doesn’t match your workflow.

    Out of the box, BC doesn’t let you persist a sort order like “Starting Date descending” unless you save it as a personal view. Here’s how you can do that without customization:

    • Open the Currency Exchange Rate list page
    • Click the Starting Date column to sort descending
    • Press Shift+F3 or click the filter pane icon
    • Choose Save as… at the top of the filter pane
    • Name your view (e.g., “Latest Rates First”) and press Enter



    Once saved, this view will appear in your dropdown list at the top of the page. You can select it anytime to load the descending sort automatically. Unfortunately, BC doesn’t let you set this saved view as the default for all users unless you create a custom page extension or use AL to define a SourceTableView property, which isn’t possible on existing system pages.

    If you’re managing multiple currencies or updating rates frequently, this saved view method is the cleanest workaround for now.

    Helpful Reference
    Update currency exchange rates – Microsoft Learn
    Set and change default sort order – Dynamics 365 Lab
    SourceTableView property – Microsoft Learn
    Save list views and filters – Microsoft Learn
    Fix Exchange Rate Amount default – Dynamics Community thread


    If you find this helpful, feel free to mark this as the suggested or verified answer.

    Cheers
    Jeffrey

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 3,666

#2
Sumit Singh Profile Picture

Sumit Singh 2,885

#3
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 2,293

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans