Skip to main content
Question

GI Sort by Results Grid function

  • August 22, 2023
  • 2 replies
  • 52 views
ketiller
Jr Varsity III
Forum|alt.badge.img

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
Captain II
Forum|alt.badge.img+15

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⚡Freelance Acumatica Developer (MVPx2🏆) for hire ⏩ linkedin.com/in/darylbowman
Chris Hackett
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • September 18, 2023

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*.
Terms & ConditionsCookie settingsAccessibility statement
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