Solved

Widget Sort Order Not Following GI Sort Order

  • 25 October 2022
  • 7 replies
  • 85 views

Userlevel 2
Badge

Hi I have a GI with one sort order (due date).  When adding to a dashboard as a data table widget and setting filters, it does not sort as per the GI.  Any suggestions? 

icon

Best answer by kirbygompf32 25 October 2022, 18:59

View original

7 replies

Userlevel 7
Badge +18

@kirbygompf32  Can you export and share the Pivot table here

 

 

Userlevel 2
Badge

@Naveen Boga Thanks for the reply!  ITs not actually a pivot table.  Just a Generic Inquiry underlyging a Data Table Widget.

Userlevel 7
Badge +18

@kirbygompf32  Sorry!

I just verified with a sample GI and the data table widget is showing according to the GI sort order.

If possible, can you please your GI, so that I can check from my end and let you know if I found anything.

 

 

 

Userlevel 2
Badge

@Naveen Boga Thanks the problem starts when you add a filter on the widget.  CAn you test that?

Userlevel 7
Badge +18

@kirbygompf32  Still working for me with the filters as well.

 

Tried with filters like Order Type and Order Total. Both are working fine.

 

 

Userlevel 2
Badge

@Naveen Boga Very strange, I cleared cache and removed and added the sort order and it seems to be working now.  THanks for hte help!

Userlevel 7
Badge +18

Great @kirbygompf32  Thanks for the confirmation.

Reply


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