web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... ORDERBY Function in ER

Finance | Project Operations, Human Resources, ...

Unanswered

ORDERBY Function in ER

(3) Share

Report

Report

Posted on by JN-21051238-0

6

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:

Dynamics 365 Finance

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

CU31030925-0 2 on at

Like (0)

Report
Copy link

Link copied!

Have you got the solution?

Was this reply helpful? Yes No
ERZeppelin 47 on at

Like (0)

Report
Copy link

Link copied!

I would start with creating calculated field in your mapping, that contains your ORDERBY expression. Then you should map it to your range InvoiceLines, not InvoiceLines_Values. What is happening here: currently the elements are iterated on upper level (InvoiceLines) on non sorted list of lines, but then on lower level you are ataching ORDERBY clause, which is filling only first record from all ordered lines. To visualise - with your mapping you have an output:
1) model.LineItem.Line1 for line range, ORDERBY(model.LineItem).Line1 for values

2) model.LineItem.Line2 for line range, ORDERBY(model.LineItem).Line1 for values

3) model.LineItem.Line3 for line range, ORDERBY(model.LineItem).Line1 for values

.....

That happens, because on every line - clause ORDERBY is iterated from the beginning. Because only first record from ORDERBY is taken - your values are repeating over all rows.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

Giorgio Bonacorsi 681

#2

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

#3

Syed Haris Shah 218 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans