Skip to main content

Notifications

Announcements

No record found.

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

ORDERBY Function Query

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!
Categories:

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 . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 225,526 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans