When I create a generic inquiry, I am able to modify the order of columns in that inquiry.
Is this information stored in the database?
Thank You,
Abhijit
Best answer by Robert Sternberg
View originalWhere are GI customizations stored?
Userlevel 7
+4
Hi
Yes, if you set the sort order for the GI in the Sort Order tab in SM208000 screen it will be default sorting order of the results. For more information on it kindly refer,
https://help.acumatica.com/(W(1))/Help?ScreenId=ShowWiki&pageid=98a9f17d-59a3-4d5b-aeb9-b6753265a889
Hi
Yes, if you set the sort order for the GI in the Sort Order tab in SM208000 screen it will be default sorting order of the results. For more information on it kindly refer,
https://help.acumatica.com/(W(1))/Help?ScreenId=ShowWiki&pageid=98a9f17d-59a3-4d5b-aeb9-b6753265a889
Thank you for writing back to me. The sort order is stored in the GISort table. I am alluding to the order of columns and not the order of data in the grid. Where is that customization stored?
Acumatica lets me change the order of columns using drag and drop on the results grid.
I couldn’t locate that information.
Userlevel 7
+8
This is stored in GridPreferences the data is not human-readable by default.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.