Skip to main content

I have custom data fields in my results grid that categorize my AR data into different timeframes. 

 

I want to sort my data by the “Overdue total” data field, but it does not appear as an option in the sort order dropdown. I’ve tried to copy and paste the same formula into the sort order tab, but the data does not sort correctly. 

I have no idea what step I’m missing. 

@ElvinT I’m not really sure the GI sort field is meant to be that robust, so it may not be able to do that function.

A couple options might be to create a SQL view of this output and then use this in the GI, or it might actually work better as a report.

Check and see if it sorts correctly ungrouped

How would i go about creating a SQL view?

Hi @ElvinT 

Please refer to the post below.

https://www.acumatica.com/blog/technical-tuesday-report-from-sql-view/

 

Best Regards,

NNT

 

Hi @ElvinT 

I’ve created a quick GI with some data I had nearby. The sorting formula makes no sense, but it shows that it clearly supports formulas:

This pencil icon means the field supports Formulas
Sorting logic. Formula: Day from Date Field in DAC - Today’s Day
Result is sorted according to the field

So I’d suggest looking at your formula. You can troubleshoot it by decomposing it into parts, which you can show as a separate column. And then visually check if there are any problems with showing the value for it.

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