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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

ORDERBY Function Query

(1) ShareShare
ReportReport
Posted on by 2
Hi,
 
I have an ER configuration with an invoice line range. I want to sort the lines by line number. I tried using ORDERBY function but it is not working as expected. Here's an example of the current report:
And here's the invoice lines in F&O:
 
As you can see, the report is not sorted by Line number.
 
I tried putting ORDERBY in the range in ER configuration:
 
But here's the result:
 
Can you please teach me how to fix this as I am new to ER.
 
Thank you in advance!
I have the same question (0)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 521 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 438

#3
Adis Profile Picture

Adis 261 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans