Script to Insert Microsoft Dynamics GP 2018 R2 Missing Security

Microsoft Dynamics GPEach version of Microsoft Dynamics GP which is introduced sees additional functionality introduced; often this additional functionality means new windows are created. This in turns means that the security roles and tasks required by Dynamics Gp change.

A fresh install of Dynamics GP includes all of this new functionality by default, but an existing implementation is not updated.

The reason it isn’t automatically updated is to allow the client to decide if the new functionality should be updated or not. To facilitate this, the Dynamics GP Support and Services Blog provides a script for each version with SQL insert statements for the new roles and tasks.

I’ve previously had a post which I updated with this information, but have now created a permanent page linking to the scripts.

I’ll be keeping this page updated in future for all new versions.

MDGP 2018 R2 Feature of the Day: New Totals Print on the Payroll Check Register report for FICA

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 R2 on which I am following and adding commentary. The series index for this series of posts is here.

The seventeenth Feature of the Day is new totals print on the Payroll Check Register report for FICA.

This feature adds totals to the print of the Payroll Check Register report for FICA. A new Total FICA Owed, Total Employee FICA owed, and totals for both FICA Medicare and FICA Social Security all print on the payroll check register report:

Payroll Check Register report for FICA

Click to show/hide the MDGP 2018 R2 Feature of the Day Series Index

MDGP 2018 R2 Feature of the Day: shared maximum benefit and deduction code in Payroll.

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 R2 on which I am following and adding commentary. The series index for this series of posts is here.

The sixteenth Feature of the Day is shared maximum benefit and deduction code in Payroll..

Thsi feature is a shared maximum benefit and deduction code in Payroll. A new Ded/Ben Shared Limit Setup window allows you to setup a calendar year maximum for multiple benefit and deduction codes. When the check run is processed, it will look at the year-to-date amount and compare it to the calendar year max in this new window.

Ded/Ben Shared Limit Setup

Click to show/hide the MDGP 2018 R2 Feature of the Day Series Index

MDGP 2018 R2 Feature of the Day: Start Date and End Date for Each Pay Code

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 R2 on which I am following and adding commentary. The series index for this series of posts is here.

The fifteenth Feature of the Day is a new Start Date and End Date for each pay code.

This feature adds a new Start Date and End Date for each pay code in the Employee Pay Code Maintenance window. This is used when building the check run as to whether to include the selected pay codes; so if the check run is before the start date or after the end date, that pay code will not be included.

Employee Pay Code Maintenance

Click to show/hide the MDGP 2018 R2 Feature of the Day Series Index