The error message for ''An error occurred while updating Employee# XX for payroll record xxx. The UPDATE statement conflicted with the CHECK constraint "CK:employ.accvac[or accsck]"'' generally only occurs when a company tracks accrued vacation outside of the program, or otherwise does not use the accrued vacation/sick fields in 5-2-1 employee records, but still records vacation hours in 5-2-2 Payroll Records.
As the fields for Accrued Vacation and Accrued Sick in 5-2-1 Employees can never contain a value lower than -99.99, mentioning this in the error message (and perhaps the option of 'if you track accrued vacation time outside of Sage 100 Contractor you may enter 0 in these fields) would enable the user to resolve this issue on their own much more easily.
Alternately, the error message could simply reference the appropriate knowledge base articles, 84528 and 84529 respectively.

by: Jess B. | over a year ago | Payroll