Share This Post

GP Updates

Microsoft Dynamics GP Payroll Extensions and Reports

Microsoft Dynamics GP Payroll Extensions and Reports is easy to use, has intuitive features such as advanced consolidation, robust business intelligence, rich reporting, forecasting and budgeting aid in smooth operations.

MS Dynamics Great Plains software is a business management system that delivers growing and medium sized businesses with total financial and operational solutions.

Attain prominent control over financials, better management of inventory and operations and take proper decisions to assist in growth ambition. Maximize employee productivity with familiar applications to merge documents, data and information.

Microsoft Dynamics GP Payroll Extensions and Reports Overview

1. Payroll Extension Essentials

Payroll Integration to Payables

Payroll Integration to Payables provides a time-saving tool for creating purchasing transactions for standard payroll generated expenses. As part of the payroll process, businesses need to generate checks to vendors to pay for the various deductions applied to employee checks during payroll processing.

The Payroll Vendor Setup window will allow the user to assign types of deductions to a vendor. During the posting process of the payroll processing, the system will create Payables Voucher Transactions automatically. The user can then cut checks or do EFT’s utilizing the standard Microsoft Dynamics GP Payables Management features.

With the automation of creating these purchasing transactions, you can quickly print checks and post a batch, without manually keying all the payables transactions required to complete payroll.

Payroll Integration to Payables allows you to set up Payroll Vendor selections for each transaction type available. The selections and Payroll Vendor Setup records created will determine the details of all purchasing transactions creating by Payroll Integration to Payables during the payroll posting process.

If no Payroll Vendor Setup record exists for a particular tax or deduction code, no payables transaction will be created for that amount. Payroll Integration to Payables also provides some additional Payroll Reporting options:

  • Print Distribution Reports
  • Print Period End Payroll Reports
Overtime Rate Manager

Many methods are utilized to calculate overtime hours and overtime pay rates to apply to those hours. The methods are framed by federal law, state law, corporate policies, collective bargaining agreements and rules according to certain positions and employee classifications.

Overtime Rate Manager provides enhanced overtime calculation methods, allowing you to set up calculation methods that meet requirements of law as well as requirements based on your unique company policies. The flexibility provided in this tool allows you to apply blended rates where needed and make exceptions based on certain pay scenarios such as shift codes, positions or departments.

Each calculation method can be applied at an employee level and rolled down from the company level via the Pay Code Setup window. With the ability to assign the calculation methods you define to employee levels, you can easily manage overtime calculation variables due to multiple employee types.

Overtime Rate Manager allows you to set up one or more calculation methods that can be assigned to pay codes at both the company (Pay Code Setup window) and employee (Employee Pay Code Maintenance window) levels.

The calculation method selected will determine what calculation will be used, as well what average calculations and exclusions will be applied for transactions entered for that pay code.

If no calculation method is selected for the employee pay code, no rate adjustments will take place to transactions with those pay codes. Any number and configuration of calculation methods can be created and used with Overtime Rate Manager.

Deduction In Arrears

The Deductions In Arrears module enables the tracking of deduction balances when the employee’s net pay is not sufficient to meet all deductions or collect mandatory arrears for employee deductions where the employee does not receive a pay check.

Microsoft Dynamics GP Payroll or Human Resources users often need to track deduction amounts that the system was unable to collect during a specific pay run or that originated outside of a standard deduction.

The Deductions In Arrears module has been designed to allow the uncollected deductions to be tracked, edited, added to or deleted providing activity level tracking of all arrear transactions.

Deductions In Arrears combines with the Microsoft Dynamics GP Payroll module to provide a seamless solution. When processing your payroll in Microsoft Dynamics GP, Deductions In Arrears calculates and attempts to take any deductions that are currently in arrears.

Any new deductions that cannot be collected during that payroll processing are then assigned as new arrears records for that employee.

2. Reports

The objectives are:

  • Understand the options available for printing reports in Payroll Extensions.

Payroll Extensions provides the ability to print window level reports, Deduction in Arrears Build report and Differential Build Edit Report.

The Payroll Extensions module provides printing capabilities by using the printer icons on the individual windows. For example, pulling up the Calculation Method Setup window and selecting the printer icon (without making any Calculation Methods selections) will print a report giving all of the Calculation Methods currently set up.

Deduction In Arrears Build Report

After the Build processing has completed, the user will be prompted with the option to print the DIA Deduction Build Report.

The report is comprised of the following data elements for each Employee/Deduction included in the Build:

  • Standard deductions –The pay period deductions Microsoft Dynamics GP is set up to take from the employee either as Transactions entered or as automatic transactions created during the build process.
  • Arrear Transaction deductions –The deductions that have been put into Arrears. There may be multiple arrear transactions for the same deduction. The system will track each missed or uncollected arrear separately and attempt to take that arrear until the total remaining has been completely collected. These rows are identified by the text “(DIA)” prior to the Code on the report.
Differential Build Edit Report

The Differential Build Edit Report prints after the calculate checks process and details the differential transaction which was responsible for adjusting any pay codes in the build.


Payroll Extensions provides reporting capabilities by using history windows,the Percent Current Inquiry window, and the use of printer icons on individual windows.

Key points to remember are that Reports are provided by using printer icons. For more information on Microsoft Dynamics GP Payroll Extensions and Reports, please contact us.

Share This Post

Leave a Reply

Notify of
Skip to toolbar