Skip to main content



No record found.

Dynamics 365 Community / Forums / Finance forum / ORDERBY Function Query
Finance forum

ORDERBY Function Query

Posted on by 2
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!

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,835 Super User

Martin Dráb Profile Picture

Martin Dráb 225,526 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans