Microsoft Dynamics vendors provide comparisons and opinions to professionals in the ERP/Accounting software selection process


Crestwood Associates

Payroll Transaction Start / End Date Feature in Dynamics GP 2018 R2

Email | Print

You can now limit the use of the pay code during the Build Payroll Batch process and the Payrol Transaction Entry, with the release of Microsoft Dynamics GP 2018 R2. This software includes two additional fields for a Start Date and an End Date on the employee pay code maintenance window. If you’re acquainted with the way the start/end dates work in the benefits and deductions entry in the Payroll module, this has similar functions to it.

This new feature will allow users to setup new pay codes without having to worry about when to start using them, or when to inactivate those they no longer wish to use.  This will be very useful to you when you are activating a new hire and terminating an existing salary employee.

In prior versions of Microsoft Dynamics GP, it was not possible to restrict whether a pay code is included in a pay run via start and/or end dates.  Instead, users would generally ‘inactive’ a pay code (most often a salary type pay code) to ensure it’s not included in a pay run.” – Andrea Melroe of Microsoft [source]

Here’s how it works…

In this example, the start date for employee BUCH0001 and pay code COMM was updated to 1/1/2029 after it was already included in a payroll transaction:
Dynamics GP Payroll Start and End

I’ll build the payroll batch for pay period 12/1/2028-12/15/2028 and include the transaction entry batch for COMMISS that already includes this employee and will receive a warning on the check file report:

Dynamics GP Payroll Start and End

Dynamics GP Payroll Start and End

Dynamics GP Payroll Start and End

To continue, I will need to update the start date for this pay code or remove this employee from the payroll transaction.

This feature also prevents users from unintentionally including employees in a transaction if the pay code is not within the period. This pay code is not available during transaction entry:

Dynamics GP Payroll Start and End

This new feature helps confirm that the pay runs function smoothly, with no added steps or mistakes. If you have any issues with this new feature (or any other during your upgrade to Dynamics GP 2018 R2), please reach out to us at

For more helpful tutorials, check out our training videos.

Ask This Expert a Question / Leave a Comment