KB01-002

How to resolve the message: “A payroll build cannot be processed because there are unposted leave transactions.”

This message indicates the payroll process unexpectedly stopped and the system has records in the work tables. If you had to run the SQL script to remove data from the Dynamics GP Payroll Work records, then you need to run the SQL script for Comprehensive Leave Manger Work records.

Run the Select statements first to verify the records being removed. If unexpected records exist in the tables, check to see if another user is building payroll. Once you verify/ confirm that the data should be removed, highlight the Delete statements, then execute.

–Execute this against the company database
USE TWO — Replace ‘TWO’ with your company database name

–This section checks for leave work records
SELECT * FROM APR_PTO10120 — LEAVE EE CODE WORK
SELECT * FROM APR_PTO10200 — LEAVE EE TRX WORK
SELECT * FROM APR_PTO10300 — LEAVE C/O BUILD TRX WORK
SELECT * FROM APR_PTO10500 — LEAVE CALC WORK
SELECT * FROM APR_PTO10600 — LEAVE C/O BUILD WORK

/*
USE TWO — Replace ‘TWO’ with your company database name 

DELETE FROM APR_PTO10120 — LEAVE EE CODE WORK
DELETE FROM APR_PTO10200 — LEAVE EE TRX WORK
DELETE FROM APR_PTO10300 — LEAVE C/O BUILD TRX WORK
DELETE FROM APR_PTO10500 — LEAVE CALC WORK
DELETE FROM APR_PTO10600 — LEAVE C/O BUILD WORK

*/