web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Canadian Payroll - R1 ...
Microsoft Dynamics GP (Archived)

Canadian Payroll - R1 form printing

(0) ShareShare
ReportReport
Posted on by Bill Campbell 12

We have a situation and we need to clarify right now.

When client enters data for the generation of the Canadian payroll R1 form

Completed_5F00_R1.GIF 

including the corect R1 authorization codes

Entry_5F00_R1.GIF

we would expect that the system will then generate the correct RL number - which according to Rev Quebec should be 8 characters long.  In all the forms we generate we get 9 and when we look at the R1 Electronic, we can not determine where the number is coming from.  In most cases the number appears to start out as the first 6 characters, but then deviates and adds extra characters, in other cases it comes up with a totally random value that starts with a -2411 value - not in the sequence that the others are at least following - wrong, but following some pattern.

I need to talk to someone that knows the R1 process - we have a single client here in Alberta and they have 6 employee's in Quebec and this is the first time in years that we have had any issues.  Each year in the past we have entered the data, printed the paper and sent the file - no issues.

Help as soon as possible, the deadline for filing is fast apporaching and the client's boss is getting a bit unimpressed.

*This post is locked for comments

I have the same question (0)
  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Is there anyone from Canadian Payroll at Microsoft monitoring this forum.  This is a problem that is halting Payroll processing and this needs to be resolved as soon as possible.

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at

    I saw an canadian payroll update released late january...

    Do you have the latest update?

    mbs.microsoft.com/.../cagptuye2015

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Tami, thanks for the note, I was in the middle of downloading the update when you posted.

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Update

    We completed the latest update to GP and are now on 12.00.2084 (R2) and 12.00.2071 Canadian Payroll

    When we recreated the R1 documents we were able to remove the 'weird' RL Control number appearing in the file.

    However, we are still getting the record to show with an extra character at the end of the expected RL control number.

    According to the letter from Quebec Revenue the number should be 8 characters and should be between 16791121 and 16791171

    The first record in the system appears as 167911214, then next 167911225, 167911236, 167911240, 167911251

    If you were to strip off the last digit, which appears to be a counter of sorts, the record RL control value would be correct.

    Microsoft Tech - this is up to you now.

  • Derek Albaugh Profile Picture
    Derek Albaugh on at

    Hello Bill,

    You probably have already done this, but if not, I'd recommend creating a support case regarding this issue with Canadian Payroll if it is still an issue and keeping you from your deadline and causing unhappiness with the customer.

    Unfortunately, I don't support the Canadian Payroll side, but I just wanted to mention that while we do try and monitor the partner and customer forums as much as possible, support cases where you have a dedicated engineer assisting you is probably the best option for more urgent or complex matters when timelines are fast approaching and/or we may need to actually do a remote session and look at the Dynamics GP environment itself.

    Thanks,

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Derek I took the step of opening a case and am working on this at this time with the client, Microsoft and Revenue Quebec.

    I understand that Microsoft is not able to monitor all the transaction on this site, but I think it a good idea that someone is scanning them for incidents where no one is replying and at least reaching out.

  • Derek Albaugh Profile Picture
    Derek Albaugh on at

    No, I completely understand and agree with you, and I figured you had already created a support case. Thanks again.

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 12 on at

    So the resolution as supplied by Microsoft and by Revenue Quebec is that RQ was wrong when they first reviewed the document submitted by the client.  They information produced on the report is correct and it is as expected.

    The client did not understand what they were looking at when they were talking to Rev Quebec and so they were talking around in circles and they both convinced each other that Microsoft software was to blame, not either of them, as they could not communicate what they were seeing.

    So for the future :

    The RL number is 8 characters with an additional character as a counter for the sequence.

    When GP generates the R1 and print the RL they do not sort in SEQUENCE order, but in Employee ID order, so unless you spend the time to re-order the paper, you will not notice that they counter on the end goes from ZERO to SIXTY-SIX - the number of employees on R1 payroll.

    We opened a case with Microsoft and they told us it was right, but we had to wait to get the 'official' letter from Rev Quebec.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans