Using the Payroll Code Modifier in GP 2013

Thoughtware Article Published: May 27, 2014
Hands holding a smart phone

As you use GP Payroll, your company’s needs may change with regard to the payroll codes you use. There are several reasons the payroll codes you’ve been using may no longer be valid, including the following:

  1. The code was set up incorrectly at the beginning.
  2. The code was set up based on your needs at the time, but your needs have changed.

Whatever the reason, Dynamics GP 2013’s Payroll Code Modifier feature gives you the ability to change old codes to new. The tool can be used to change one code at a time or change multiple codes. The tool will change the code, including all history tied to the code.

With this tool, you can change the following types of codes:

  • Pay Codes
  • Deduction Codes
  • Benefit Codes

Using the Tool

Log in to Dynamics GP 2013 as “SA” and go to the HR & Payroll area. In the “Utilities” menu, select “Payroll Code Modifier.”

payroll code modifier

Notice the “Method” radio buttons. You can make one change at a time (Single) or update multiple records at a time (Batch). This tool works similarly to the Professional Services Tools Library (PSTL). (See our other articles and webinars about PSTL for more information.)

To use the batch method, you can create a tab-delimited file with two columns. In Column 1, enter the old value. In Column 2, enter the new value. Do not enter column headers. Once you select the “Batch” radio button, you can select the file you want to use. Click the “Validate” button to make sure the file has valid information; invalid data could include the old column containing a code not in GP.

If you’re using the Single method, enter or select the code you want to change and enter a new code.

code - 2

Make sure no users are running Payroll processes when updating, and make sure you have a verified backup of your database.

Click the “Update” button.

If the update is successful, you should see a report similar to the image below.

code - 3

That’s it! Any GP tables referencing the old pay code will now have the new code.

If you have any questions about this tool, please contact us. Thank you!

Related Thoughtware

Kate & Ben — How can we help you? Contact Us!

How can we help you?