Monday, March 21, 2011

More Payroll Troubleshooting Scripts, Enjoy!

More FUTA and SUTA fun to share.  The following scripts can help you track down inconsistencies in your set up to identify potential causes of incorrect FUTA and SUTA wages. Each can be run against your company database to identify records with possible issues.

--identifies employees without a default SUTA state (Cards>>Payroll>>Employee)

select EMPLOYID as EmployeeID from UPR00100 where SUTASTAT=''

--identifies employee pay code records (Cards>>Payroll>>Pay Code) that are not marked for FUTA, SUTA, or do not have a SUTA state although the pay code set up (Setup>>Payroll>>Pay Code) does.

select UPR00400.EMPLOYID as EmployeeID, UPR00400.PAYRCORD as PayCode, UPR00400.SBJTFUTA as SubjectToFUTA, UPR00400.SBJTSUTA as SubjectToSUTA, UPR00400.SUTASTAT as SUTAState from UPR00400 inner join UPR40600 on UPR00400.PAYRCORD=UPR40600.PAYRCORD WHERE (UPR00400.SBJTFUTA=0 AND UPR40600.SBJTFUTA=1) OR (UPR00400.SBJTSUTA=0 AND UPR40600.SBJTSUTA=1) OR (UPR00400.SUTASTAT='' AND UPR40600.SBJTSUTA=1)

Christina Phillips is a Microsoft Certified Trainer and Dynamics GP Certified Professional. She is a supervising consultant with BKD Technologies, providing training, support, and project management services to new and existing Microsoft Dynamics customers.

No comments: