Why does ROE not bring in data for box 15c for some employees, but does for others?

I've been working with Sage 300 Canadian Payroll for over a decade and this is the first I have seen this.

When generating ROE for a particular employee, usually it will auto populate Box 15C with all their pay periods starting at the most recent one.

In the past week, we have had some employees have worked fine, but we have now had 2 employees that have not worked and we needed to manually enter the data into Box 15c.

There is clearly data there that should be brought in - and it works for other employees with the same job codes so that shouldn't be the issue.

I am just not sure what I am missing, and of course, I'm training a new person - trying to show her how easy ROE's can be on here, and the first two haven't worked.

I have tried on 2 different computers so it is not directly related to a particular machine.

Employees do say ROE pending in status so that should not be the issue either.

Anybody have any ideas that might help me figure this one out?

  • 0

    all the other data seems to populate fine, just not Box 15 figures.

  • 0

    Hi Jody, 

    Most likely the reason is either 

    1. the employees don't have any EI Insurable Earnings for the preceding 27 weeks.. or

    2. the employees already had an ROE generated for the respecitive fields.

    To know for you, you can run query SQL Management Studio on the table CPEUIC and see if there are records for those employees and if the fields ESTATUS has a value other than '1'  and ESTATDATE date entered in the records.. 

    If you're comfortable running SQL queries, open SQL Management and start a new query and type the following:

    use 'enterdatabasenamehere'

    select EMPLOYEE,ESTATUS,ESTATDATE from CPEUIC where EMPLOYEE = 'enteremployeenumberhere'

    If you like you can open a ticket with Customer Support.

    Regards,

    David Crampton