The Trial Balance being out of balance due to payroll timesheet entries is caused by a defect first identified in 6.2.0.20.
--First run queries to find all the affected register numbers
--then back up the affected register numbers
SELECT *
INTO #GL_Register_Backup
FROM GL_REGISTER
WHERE REGISTER_NUMBER IN (
???????, ????????, ???????
);
--Run below script after backup and it will auto correct all affected entries
update g set Account_Id = emp.Payroll_Account_Id
--Select emp.*
from #GL_Register_Backup bk
join SY_Employee emp on emp.Employee_Id = bk.Employee_Id
join gl_register g on bk.Register_Id = g.Register_Id
where g.Account_Id = 1 and g.Register_Type_Id = 11
and Payroll_Account_Id > 1
