Does anyone know the table where the Preferences “Form To Use” field can be found? I want to use a BAQ to find out how this is set for each users.
Looks like it could be Ice.SysUserMenuPreference
The Ice.SysUserMenuPreference appears to be menu id specific. The field I am looking for is under General Options > Preferences per user
Ice.SysUserFile - DefaultFormType
2 Likes
Ok so that is the table…which I had tried but the values returned in the BAQ for DefaultFormType threw me off as it returns Base, Default, URL where the drop down options on the screen are User Choice, Classic, Kinetic I tested and figured out that…
Base = Classic
Default = User Choice
URL = Kinetic
Love it when Epicor can’t use the same values in drop downs vs. tables!
3 Likes
does anyone know, what is this menu’s name in window epicor in epicor kinetic 2021?
1 Like
Are you looking for SysUserFile.DefaultFormType? This is the Preference selected by the User under General Ops. I had to add a calculated field to my BAQ to translate to the values you see under General Ops vs. the backend table.
Case when SysUserFile.DefaultFormType = ‘Base’ then ‘Classic’
when SysUserFile.DefaultFormType = ‘Default’ then ‘User Choice’
when SysUserFile.DefaultFormType = ‘URL’ then ‘Kinetic’
else null
end