Resource Center Home
Resource Center Home

HR and Payroll for Dynamics GP

HR and Payroll for Dynamics GP

Comprehensive Leave Manager Transaction Adjustments


There are three options to make transaction changes for employees and leave codes. First, you can make a Leave Transaction Entry for a single employee and leave code. Second, you can enter a mass transaction for one leave code and several employees. Third, you can use SQL scripts to edit transactions directly in SQL Server.

Both the Leave Transaction Entry or the Mass leave transaction entry allows you to enter different types of transactions. For details on each type review the Comprehensive Leave Manager User Guide:User Guide (

The system does allow you to create a transaction for each leave option; Earned, Pending, Taken and Adjusted.

Trx 1

If a user is familiar with SQL Server Management Studio, they could create SQL Scripts to edit the existing transactions.  We recommend you work with your IT staff if you want to edit the data directly in SQL.  The transaction table is APR_PTO20200.  After the edits have been made in SQL the Comprehensive Leave Manager Reconcile SQL script will need to be executed to recalculate the transactions and update the Summary table.

Trx 2

Trx 3

Trx 4

Questions / Resources

If you have questions or comments please email

Last Review: 11/10/2022– Revision: 1.0

Applies To:
Comprehensive Leave Manager for Microsoft Dynamics GP 2015 R2
Comprehensive Leave Manager for Microsoft Dynamics GP 2013 R2

Was this article helpful?
Views: 50

Leave A Comment