New Security Roles and Tasks missing after upgrading to Microsoft Dynamics GP and Year-End Update (18.2.1007 or later)(Updated)

With the release of Microsoft Dynamics GP in October 2019, there are new security roles and security tasks that are added with the new release.   Because of this, if you are upgrading to Microsoft Dynamics GP or the 2019 U.S year-end update (18.2.1007 or later), 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 or Security Task Master table. These records are for new functionality that is available in this new Microsoft Dynamics GP release.

That being said, 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.

18.2.1007SecurityRolesandTasks.txt for Microsoft Dynamics GP (18.2.1007 and later) security roles and security tasks.

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.

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 or through a support case, so we can verify it one way or the other.

Thank you and Happy Upgrading!!!!

Derek Albaugh

Microsoft

**Update: We've found that when inserting the records into the SY10800 table, it caused the alternate/modified forms and reports window to show objects with neither the default, alternate or modified options selected, which has caused customers to see 'dictionary not found' errors.

  To prevent this, we've modified the SY10800 scripts to only add those records that have an ALTDICID value of 1493 and 2277, which is the core 'SmartList' and 'Purchase Order Enhancements' modules. These are included in the attached scripts above.

   For additional modules, we have these:

>If you have 258/Project Accounting installed for Dynamics GP 2018 R2, run these scripts as well:

SY10800_5F00_ProjectAccounting_5F00_18_5F00_2.txt

>If you have the 1911/HRM Solution Series module installed for Dynamics GP 2018 R2, run these scripts:

SY10800_5F00_HRM_5F00_Solution_5F00_Series_5F00_GP18_5F00_2.txt

>If you have the 2788 / Enhanced Intrastat module installed for Dynamics GP 2018 R2, run these scripts:

SY10800_5F00_Enhanced_5F00_Intrastat_5F00_GP18_5F00_2.txt

>Lastly, if you have the 3096 / VAT Daybook module installed for Dynamics GP 2018 R2, run these scripts:

SY10800_5F00_VAT_5F00_Daybook_5F00_GP18_5F00_2.txt

This will keep the SY10800 table from getting records for ALTDICID values for features that are not installed, which will resolve the 'dictionary not found' messages after the security scripts are run.

Thanks again!!