we are about to go live on Kinetic 2022.2 and I need to get all the new security groups that have been set up on menu items.
What table in SQL can I pull all this info out of? I tired a few ice.menu table but I don’t see security groups.
Thanks Kim
Look at Erp.Security. It links to Ice.Menu via the SecCode field.
1 Like
So i was able to get my security groups. But now I am getting errors when I DMT. Keeps telling me
SecCode SEC1600 Record not found.
Record not found.
EDIT: I fixed my DMT and it ran no errors but did not update anything… UGH!!
Anyone know how to update the menu items with security gorups.
The simplest method of troubleshooting this is to MANUALLY update one of the menu items, create a BAQ to query out the updated table, then format your DMT upload file that same way.