Resource Center Home
Resource Center Home

HR and Payroll for Dynamics GP

HR and Payroll for Dynamics GP

Resolving Message: “Payroll Forecast Cannot Be Run”

KB11-001

How to resolve the message: “A Payroll Forecast cannot be run when the system is actively processing a Forecast.” Or “A Payroll Forecast cannot be run when the system is actively processing payroll.”

This message indicates that Paycheck “What If” Calculator or a payroll is being processed. If you do not expect the system to be processing a forecast or payroll, then you can run the following select statements to see what records are being processed. If these records are invalid, you can highlight and run the Delete statement to remove the data.

select * from UPR10203 where USERID = ‘WHATIF’
select * from UPR10200 where USERID = ‘WHATIF’
select * from UPR10301 where BACHNUMB =’WHATIF’
select * from UPR10302 where BACHNUMB =’WHATIF’

–Replace DYNAMICS with system database if you use a different database name.
select * from DYNAMICS..UPR10300 where USERID = ‘WHATIF’
select * from DYNAMICS..UPR10304 where USERID = ‘WHATIF’
select * from UPR10201 where USERID = ‘WHATIF’
select * from UPR10202 where USERID = ‘WHATIF’
select * from UPR10204 where USERID = ‘WHATIF’
select * from UPR10205 where USERID = ‘WHATIF’
select * from UPR10206 where USERID = ‘WHATIF’
select * from UPR10207 where USERID = ‘WHATIF’
select * from UPR10208 where USERID = ‘WHATIF’
select * from UPR10209 where USERID = ‘WHATIF’
select * from UPR10213 where USERID = ‘WHATIF’

/*
–Replace DYNAMICS with system database if you use a different database name.
delete from UPR10203 where USERID = ‘WHATIF’
delete from UPR10200 where USERID = ‘WHATIF’
delete from UPR10301 where BACHNUMB =’WHATIF’
delete from UPR10302 where BACHNUMB =’WHATIF’

Delete from DYNAMICS..UPR10300 where USERID = ‘WHATIF’
Delete from DYNAMICS..UPR10304 where USERID = ‘WHATIF’
Delete from UPR10201 where USERID = ‘WHATIF’
Delete from UPR10202 where USERID = ‘WHATIF’
Delete from UPR10204 where USERID = ‘WHATIF’
Delete from UPR10205 where USERID = ‘WHATIF’
Delete from UPR10206 where USERID = ‘WHATIF’
Delete from UPR10207 where USERID = ‘WHATIF’
Delete from UPR10208 where USERID = ‘WHATIF’
Delete from UPR10209 where USERID = ‘WHATIF’
Delete from UPR10213 where USERID = ‘WHATIF’
*/

Questions / Resources

If you have questions or comments please email Support@integrity-data.com.

If you would like to search for information and resources for Integrity Data products check out the following sites:

Last Review: 3/14/2014 – Revision: 1.0

Applies To: Paycheck “What If” Calculator

Was this article helpful?
Views: 37