I am currently working on printing the Purchase Order in line sequence based on Sort Order instead of Line Number.
I attempted to use POLine.SortOrder with ascending sorting in the report; however, the sorting does not appear to be working as expected.
Could you please advise if there are any additional configurations required or if there are any limitations with using SortOrder for this purpose?
Thank you in advance for your guidance.
Best answer by KrunalDoshi
Hi
You need to modify the second group “groupPOLine” in your PO Report (PO641000), add another grouping for [POLine.SortOrder] and move it to top. This should fix your issue. Hope this helps!
+6
Hi
You need to modify the second group “groupPOLine” in your PO Report (PO641000), add another grouping for [POLine.SortOrder] and move it to top. This should fix your issue. Hope this helps!
+12Hi
You need to modify the second group “groupPOLine” in your PO Report (PO641000), add another grouping for [POLine.SortOrder] and move it to top. This should fix your issue. Hope this helps!
I had to do this yesterday. Sorting in report designer is not easy or intuitive.
The rules defined in the sorting tab in the schema builder do nothing. Any changes to sorting must be defined by changes to the grouping.
Thanks
+12Thank you
Krunal gave the answer. You should mark his answer as the best answer :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
