Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / hoping for a Canadian ...
Microsoft Dynamics GP (Archived)

hoping for a Canadian Payroll expert - ROE question

(0) ShareShare
ReportReport
Posted on by iruser2 2,046

Hi folks (payroll folks)

Client is on the GP2013 January hotfix for payroll. ie. GP12.00.2084 and payroll 12.00.1327.  They are trying to generate an ROE.

When they go to the Payroll ROE Amounts - Canada screen only pay period 1 populates automatically.  The employee should have data in at least the last 27 periods.

Reading the manual it says "Enter the employee's insurable earnings for each of the last 27 weeks in the corresponding fields. The sum of the 27 weekly earnings will be calculated and displayed."

Does the user really have to key these fields, or should the system populate them from payroll data?

If it should auto populate what setting has been missed that it is not?

thanks!

*This post is locked for comments

  • iruser2 Profile Picture
    iruser2 2,046 on at
    RE: hoping for a Canadian Payroll expert - ROE question

    as a mere accountant I would have no idea.  Any HR experts out there?

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: hoping for a Canadian Payroll expert - ROE question

    In a response above you stated :

    _____

    If you create your ROE and boxes 1-27 are not populated, this is the result of a change from the Human Resources Development of Canada that states, “If you have an employee who has been paid in all of your pay periods, only box 15C will be filled in. Boxes 1-27 will be left blank. If the employee did not receive any pay in one or more of your pay periods, then boxes 1-27 will be filled in.”

    _____

    In my case the employee worked all the pay periods - only the last record populates - is that what is expected by HRDC - just wondering?

  • iruser2 Profile Picture
    iruser2 2,046 on at
    RE: hoping for a Canadian Payroll expert - ROE question

    My client was similar except the ROE was issued in 2015 when he went on sick leave, returning in 2016.  In 2016 he was being laid off and needed another ROE.

    Your question re what to populate on the ROE is an HR question not a GP question.  

    I would think you need to show only the pay since July 17 as the government already has an ROE on file for pay periods prior to that.

    I would say there is potential for this being a bug since in both cases GP populated nothing onto the ROE when it clearly should have populated something.

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: hoping for a Canadian Payroll expert - ROE question

    What made this different for us was that (1) the employee had gone back to school earlier in the year so received an ROE for the prior two year period ending in April.  And then in July (2) the employee returned to work - apparently working and getting paid for all the periods available for that time frame.

    So when the ROE is generated on the last period is presented from the CPY30250 and nothing else.  When I looked at the CPY30250 in detail, I was able to find all the periods and their data from the July 17th payroll forward.

    Now, should the client then use that data to manually populate the ROE to show all that data, or can they leave it blank?

  • iruser2 Profile Picture
    iruser2 2,046 on at
    RE: hoping for a Canadian Payroll expert - ROE question

    Hi Bill

    I ended up with a support case at MSFT.

    and got this

    The ROE amounts and hours will pull from the Payroll Employee Summary Expand – Canada window (click Cards, click Payroll – Canada, click Employee, and then click Calculated). When the ROE is created it will also look at the Calculated field under the LY Calculated window as well (Inquiry | Payroll - Canada | Employee Last Year Information, and then click Calculated) to collect any LY information it needs to complete the ROE.

    Within SQL this information is held in the CPY30250 (Payroll Calculation MSTR File) and CPY50250 (Payroll Calculation MSTR File LY)

    • The ROE Total Insurable Earnings information will pull from the PEIInsEarnings24 field in the CPY30250/CPY50250.
    • The ROE Total Insurable Hours information will pull from the PEIInsHours field in the CPY30250/CPY50250.

    If you create your ROE and boxes 1-27 are not populated, this is the result of a change from the Human Resources Development of Canada that states, “If you have an employee who has been paid in all of your pay periods, only box 15C will be filled in. Boxes 1-27 will be left blank. If the employee did not receive any pay in one or more of your pay periods, then boxes 1-27 will be filled in.”

    Note: The ROE generated from Canadian Payroll is a ‘best estimate’ based on the information that exists in the system. You may have to manually update the Total Insurable Hours and Earnings on the ROE form.

    To determine why the system isn't pulling in the employee information from 2005 (Nov and Dec), check to see if this employee has information in the CPY50250 table or the Calculate LY window for November and December.

    Also check to see if these pay period boxes (1-27) aren't being filled in because the employee was paid for all the pay periods.

    I had data on the applicable tables but the ROE would not fill in.  It was only for one employee so MSFT deemed it not to be a bug.  The client could not / would not pay for further research so manually completed the ROE and the incident closed.

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: hoping for a Canadian Payroll expert - ROE question

    Has anyone got a comment for this ?  We are encountering the same issue.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans