New Security Roles and Tasks are missing when upgrading to Microsoft Dynamics GP - Fall 2023

As with prior releases, with the release of Microsoft Dynamics GP Fall 2023 (18.6), there are new security roles and security tasks that have been added with this new release.   Because of this, if you are upgrading to Microsoft Dynamics GP 18.6 from a prior release, you will need to run the attached scripts to make sure all of the security records are present in the new Microsoft Dynamics GP.

Out of the security tables we add records to during upgrades: SY10600, SY10700, SY09000, SY09100 and SY10800 security tables, with this new update, we’re only adding some new operations to the SY10700 table. These records are for new reports and a form/window that are added in this new Microsoft Dynamics GP release.

Regardless of what version you’re upgrading from for Microsoft Dynamics GP, once the upgrade of all system and company databases have been completed successfully and you’ve made backups, you will need to run these scripts against your system database for Microsoft Dynamics GP.

This is by design in that we would not roll down new security roles to an existing Microsoft Dynamics GP environment, which may cause issues with your current security design. Therefore, we have chosen to release these new security records as an INSERT script, even though we do not recommend making any modifications to our default security roles or security tasks, but instead create custom security roles and security tasks to use and make changes to.

A new installation of Microsoft Dynamics GP at this new version/release will already have all of these security records in the system tables, it is only when upgrading from a previous version/build that this issue will occur and require the running of these security record scripts.

 Here are the scripts for Microsoft Dynamics GP (18.6.xxxx) security roles and security tasks:

GP_OCT2023_SecurityTableInserts.txt

These scripts include the tables SY10600, SY10700, SY09000, SY09000 and SY10800.

If you are upgrading from a previous version of Microsoft Dynamics, you do not need to run any other insert scripts for missing security roles or security tasks for prior versions, you only need to run these scripts for Microsoft Dynamics GP, which includes all security records for the 5 security tables mentioned above.

***NOTE: When you run these insert scripts against your system database for Microsoft Dynamics GP, it is normal that you will see PRIMARY KEY error messages referencing duplicated records trying to be inserted into the security tables. This can be ignored as it means that the record(s) already exist in that table and the script will not overwrite anything that is already present.

For the SY10800 table, we found that inserting records into this table caused issues with the alternate/modified forms and reports window to show objects with neither the default, alternative or modified options marked, which then causes 'dictionary not found' messages when users attempted to access windows or reports in the Microsoft Dynamics GP application.

To prevent this, we've modified the SY10800 script above to only add those records that have an ALTDICID value of 1493 (SmartList) or 2277 (Purchase Order Enhancements), both of which are core modules installed with the Microsoft Dynamics GP application.

For additional modules, we have the following scripts:

>>If you have Project Accounting (258) installed for Microsoft Dynamics GP 18.6, run these scripts as well as the attached script file above:

OCT2023_ProjectAccounting_SY10800InsertScripts.txt

>>If you have Enhanced Intrastat (2788) installed for Microsoft Dynamics GP 18.6, run these scripts as well as the attached script file above:

OCT2023_EnhancedIntrastat_SY10800InsertScripts.txt

>>If you have VAT Daybook (3096) installed for Microsoft Dynamics GP 18.6, run these scripts as well as the attached script file above:

OCT2023_VATDaybook_SY10800InsertScripts.txt

>>Finally, if you have Canadian Payroll (7131) installed for Microsoft Dynamics GP 18.6, run these scripts as well as the attached script file above:

 OCT2023_CanadianPayroll_InsertSecurityScripts.txt

This will keep the SY10800 table from getting records for ALTDICID values for features that are not actually installed for your Microsoft Dynamics GP application, which should prevent the 'dictionary not loaded' messages from occurring after these security scripts are run.

If you believe you are experiencing an issue due to running these scripts, please make us aware of it via the comments on this blog, let us know through the Microsoft Dynamics GP Community Forums or through a support case, so we can verify it one way or the other.

We’re excited about the new release as it has a lot of features asked for by our customers so we’re hoping you enjoy it as well. Good luck and Happy Upgrading!!