The specified sequence of Group By and Order By fields is not supported.

(0) Share

Report

Posted on by itlabnarmi_ivoruk

135

When I debugged code the error is due to AddGroupByField() on query build data-source: qbds.addGroupByField(FieldId)

I have the same question (0)

All responses (7)

Answers (1)

Hana Xue Microsoft Employee on at

Like (0)

Report

The specified sequence of Group By and Order By fields is not supported.

Hi,
Before other development-savvy experts have any thoughts on this, based on the error message, you can check out this link:https://robscode.onl/d365-the-menu-item-with-name-could-not-be-opened/ And check if the fields support grouping and ordering, ensure that the field types used are compatible, and check if the order of grouping and ordering fields is correct.
Best Regards,
Hana

Was this reply helpful? Yes No
itlabnarmi_ivoruk 135 on at

Like (0)

Report

The specified sequence of Group By and Order By fields is not supported.

I already gone through this: https://robscode.onl/d365-the-menu-item-with-name-could-not-be-opened/

this is not the same case with me, my issue is due to AddGroupByField() method on data-source.

Was this reply helpful? Yes No
Layan Jwei 8,058 Super User 2025 Season 2 on at

Like (0)

Report

The specified sequence of Group By and Order By fields is not supported.

Hi,

Can you show us your full code? Where did you use orderBy?

Was this reply helpful? Yes No
Suggested answer

MuthukumaranAX 2,903 on at

Like (0)

Report

The specified sequence of Group By and Order By fields is not supported.

is this called from a form datasource or are you constructing the query via code?

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 8,973 Super User 2025 Season 2 on at

Like (0)

Report

The specified sequence of Group By and Order By fields is not supported.

Hi @ itlabnarmi_ivoruk,

It seems you're trying to do order by using group by field. You can't order by Aggregate group by, can you share your code in order to help you better?

Thanks

Waed Ayyad

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No
Verified answer

itlabnarmi_ivoruk 135 on at

Like (1)

Report

The specified sequence of Group By and Order By fields is not supported.

Thank you guys for your valuable responses, In my case it was some data issue due to which it was throwing this error.

Also I find this below line of code that it might be helpful if there is some sort of issue in group by on query through X++ code:

Was this reply helpful? Yes No
Hana Xue Microsoft Employee on at

Like (0)

Report

The specified sequence of Group By and Order By fields is not supported.

Hi,
Thanks for coming back and clarifying this issue, it will help others on the forum with the same problem.
Best Regards,
Hana

Was this reply helpful? Yes No