Resource Center Home

HRP for GP Solutions Resources

How to edit the Microsoft Dynamics GP pay stub to include Comprehensive Leave Manager Leave Code and a variety of leave balance information instructions.

You are here:
Estimated reading time: 4 min

KB01-029

This is one of three options to display Comprehensive Leave Manager leave time on the check stub.  To review all options or to review options for Mekorma check stub click here.

This option is unsupported using the E-Mail Earnings Statements product. See the other two options if you are using E-Mail Earnings Statements and Comprehensive Leave Manager.

This option uses the Pay Stub Settings from the Comprehensive Leave Manager Pay Stub Settings window. In this window, you can select which fields to calculate. We recommend only selecting the fields you wish to display on the check to calculate. This will calculate the amounts in array fields in the APR_PTO_WORK_Check table during the print checks process.

029 1
Calculate Amount – Select if you want to start calculating the amount for the Column selected.

Maximum Hours To Display – if an amount is entered in this field the check would never display an amount over this maximum even if the employee had more time than this maximum.

Earned – This is the amount earned this pay period.

Earned YTD – This is the year to date amount earned. This amount can be based on Accrual year (Hire Date, Adjusted Hire Date or Other Date), Waiting Period, Other or Carryover date. See YTD Value Based On for further information on each YTD option.

Taken – This is the amount taken this pay period.

Taken YTD – This is the year to date amount taken. This amount can be based on Accrual year (Hire Date, Adjusted Hire Date or Other Date), Waiting Period, Other or Carryover date. See YTD Value Based On for further information on each YTD option.

Adjusted – This is the amount adjusted this pay period. Typically, this would be maximum balance adjustments.

Adjusted YTD – This is the year to date amount adjusted. This amount can be based on Accrual year (Hire Date, Adjusted Hire Date or Other Date), Waiting Period, Other or Carryover date. See YTD Value Based On for further information on each YTD option.

Pending – This is the amount accrued as pending this pay period.

Pending YTD – This is the year to date amount pending. This amount can be based on Accrual year (Hire Date, Adjusted Hire Date or Other Date), Waiting Period, Other or Carryover date. See YTD Value Based On for further information on each YTD option.

Available – This is the amount currently available this pay period. It does include the earned, taken and adjusted this pay period.

YTD Value Based On – If a YTD field is selected the system will calculate the Year To Date amount based on the YTD Value Based On selected. If you use YTD be cautious in the date and adjustment entry used for any manual adjustment entries.

029 2

Calendar Year – The system uses the Calendar Year to determine the year. It then calculates for transactions based on the created date in the Employee Leave Transactions window.

Accrual Year – The system uses the Leave Code Accrual Based on Date on the Employee Leave Maintenance window to determine the year. It then calculates for transactions based on the created date in the Employee Leave Transactions window.

Carry Over Year – The system uses the Carry Over Year Date on the Employee Leave Maintenance window to determine the year. It then calculates for transactions based on the created date in the Employee Leave Transactions window.

Other Date– The system enables you to specify a Day/Month and the current system date year to determine the year. It then calculates for transactions based on the created date in the Employee Leave Transactions window.

Waiting Period– The system uses the Waiting Period Date on the Employee Leave Maintenance window to determine the year. It then calculates for transactions based on the created date in the Employee Leave Transactions window.

Copy to all leave codes – Select this button to copy the Pay Stub Settings to all leave codes. If you do not copy to all leave codes, you will need to set up the options for each leave code.

After you have setup, the Pay Stub Settings select ok then save the Leave Code Setup record.

Report Writer Instructions

Now that we have identified the items to calculate, we will login to Report Writer to add the fields to the check. If you are not familiar with Report Writer here is a Microsoft u