Ok, so it turned out that we were re-submitting the time sheets (Time screen) in the payroll module. So it kept adding to the the hours each time we did that. So to resolve the issue we put negative numbers in the Time Screen to make the numbers being calculated accurate. Then we started to see another error in the log file there were 3 entries like this:
================================================================================
Processing: Employee: 'XXXX'
System Message 6104: Deduction: 'NCFPAT' does not specify a payroll table.
System Message 6127: Error occurred during an abortable transaction. Processing
will continue.
================================================================================
This was occuring for 3 employees, which didn't really make sense and it still doesn't, but to resolve that issue, we went into the deduction screen and changed the NCFPAT deduction from type "Gross Earnings" to "No Base" and it worked. I have no idea why that would come up and especially for only 3 employees. It was very strange. But finally we got those issues resolved and successfully ran payroll ... whew!