hi!
our client needs to be able to track workers comp codes by task and employee. they have a wage-tiered rate structure so depending on the rate of the employee, the WCC can vary.
For example: Employees work plumbing tasks that have two different WCC codes depending on their hourly wage rate:
- WCC 5183 (Plumbing Low Wage) applies when the employee rate is under $32/hr at 0.073981/hr
- WCC 5187 (Plumbing High Wage) applies when the employee rate is $32/hr or above at 0.038358/hr
The problem is that Acumatica's WCC source mapping only supports Project/Task or Labor Item as triggers, neither of which is wage-rate-aware. ExaCTIME has confirmed they do not pass WCC codes or any wage-tier differentiator — timecards come over with Project, Task, and Hours only.
We've looked at using labor items as the discriminator, but that doesn't work without ExaCTIME sending different pay codes. Employee-level WCC assignment won't work either since employees cross the $32 threshold regularly. We've looked at payroll calculation rules but haven't found a native way to conditionally apply a WCC code based on computed hourly rate. Our fallback is possibly default to the low-wage code and using a GI to flag paychecks for manual correction before release, but we'd prefer something cleaner.
has anyone had to work through a similar requirement? this client is on 25R2