How to edit the Microsoft Dynamics GP pay stub to include Comprehensive Leave Manager Leave Code, per pay period earned, per pay period taken and current available balance Instructions.

Resource Center
HRP for GP
Knowledge Base GP
Comprehensive Leave Manager
How to edit the Microsoft Dynamics GP pay stub to include Comprehensive Leave Manager Leave Code, per pay period earned, per pay period taken and current available balance Instructions.

KB01-028

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.

Complete the following steps to add the leave code, per pay period earned, per pay period taken and available balance to the Employee Check and Earnings Statement.

Note: Using this option, you do not setup the pay stub information from the Leave Setup window. To use the options available on the Leave Code Pay Stub setup window click here.

1. Open Report Writer.
Microsoft Dynamics GP > Tools > Customize > Report Writer

2. Select Comprehensive Leave Manager for the Product and then click on the Reports button. You can use the standard Microsoft Dynamics GP report in Comprehensive Leave Manager. Any modifications to the Microsoft Dynamics GP report will need to be completed again on this report. Typically, this is masking the SSN or Bank Account number. To proceed with this option complete Using Comprehensive Leave Manager standard report instructions below.

Using Comprehensive Leave Manager standard report instructions

The user may select the standard Microsoft Dynamics GP form to insert and modify by completing the steps below.

Within the Original Reports section, select the Employee Check and click the Insert button to move the report to the Modified Reports section.
Select the inserted report, click the Open button
Select the Layout button
The Direct Deposit Statement comes with three Leave Code Balance fields on the Statement. To add more Leave Codes to the Direct Deposit Statement complete the following steps:
Within the Toolbox window, select the Calculated Fields from the drop down list.
Select Leave Code Balance 4 and drag it into the visible area of the check.
14. Select additional Leave Code Balance fields based on the number of leave codes to print on the check. Ensure to select the appropriate incremented Leave Code. For example, Leave Code Balance 4 and then Leave Code Balance 5.
Close and Save the Modified Report.The check will need more information added than the direct deposit statement. You will need to add text fields for the Code, Earned, Taken and Remaining field and add lines to create the boxes. You may need to remove Pay Code Array’s and edit the check layout to incorporate the Leave Balance information.
Log into Microsoft Dynamics GP and set Security to the new Comprehensive Leave Manager Modified Form.

Adding Calculated Fields

If you do not have the options for Leave Code Balance 1 through 10 already under calculated fields you can create them using the steps below. Ensure the constant starts at 1 instead of 11.

If the user has more than 10 leave codes assigned to an employee they may add additional calculated fields to display on the Employee Check and Earnings Statement. Complete the following steps to create additional calculated fields:

Within the Toolbox window, select Calculated Fields from the drop down list and then select New.
The Calculated Fields Definition window will open; enter Leave Code Balance 11 as the Name.
Select String for the Result Type and then select the Function Tab.
Select System for Core and then select rw_leave_codes for the Function.
Click the Add button.
Select the Fields tab and then select Payroll Master for the Resources.
Select Employee ID for the Field and then click the Add button.
Select the Constants tab and then select Integer for the Type.
Select 11 for the Constant. If there are, no calculated fields in report writer enter one instead of 11 on this step.
The integer will need to increase for each calculated field added.
Select the Add button.