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
Solved
Where are GI customizations stored?
Best answer by Robert Sternberg
This is stored in GridPreferences the data is not human-readable by default.
+5Hi
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.
+7This is stored in GridPreferences the data is not human-readable by default.
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.