Question

GI Sort by Results Grid function

  • 22 August 2023
  • 2 replies
  • 32 views
K
Rank
Userlevel 4
Badge

Hello,

Is it possible to sort on a GI by a formula in the results grid?

GI Details:

Tables: PMProject,PMHistory

Parameters: PMproject.Default Branch, PMHistory.PeriodID

Grouping: PMProject.ContractCd

Sorting formula:

The formula works in the results grid but when I turn on the sorting, I get the following error:

Thank you,

KT

2 replies

darylbowman
Rank
Badge +11

I believe I’ve run into similar issues when trying to use an aggregate function in a Sorting formula. I’ve not found a solution.

Daryl ⚡Contract Acumatica Developer (MVP🏆) for hire ⏩ linkedin.com/in/darylbowman
Chris Hackett
Rank
Userlevel 7
Badge

Hi @ketiller were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved