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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Canadian Payroll T4 Amended

(0) ShareShare
ReportReport
Posted on by 12

Greetings all,

So, back in February we did our client T4's generate, review and submit.  Then we learned of the error on the printing of the T4 amounts in box 24 and 26 and we were provided a patch.  We applied the patch, but the values in the already generated T4's were incorrect - so - we tossed those and re-created the T4's for 2019 with the new code.

We then proceeded to print electronic copy and submit, for a second time, to the CRA.

All good.  So we thought.  Today got a call from the CRA telling the client that, while the numbers are all correct and that they can see the difference between the two submissions is just the corrected max for the box 24 / 26 - the second submission will not be accepted as it was submitted as original and should have been sent as AMENDED.

There is a button on the T4 edit window that, once you make a change on one of the values, you can select AMENDED - but we did not change any values, we generated totally new documents - I do not want to tell the client that for 659 records they have go one by one and flip the flag to call it AMENDED and then reprint electronic and resend to CRA.

So, I need to have someone out there tell me the TABLE and FIELD Name to change - what to change it to - so that I can use my friend SQL to make the mass change in like 10 seconds.

I then want to be able to print electronic copies and send to CRA.  

I know it can be done - I just don't really want to spend the next 40 hours looking for the answer.

Have a great weekend all - it is sunny and the snow is melted and gone - we might get to be out side ( by ourselves soon )

"Be safe, practice good social distancing, when ever possible just stay home"

Categories:
I have the same question (0)
  • Verified answer
    Deseree Krumm Profile Picture
    on at

    Hello Bill.  I believe the fields you are looking for are the RLRECORDSTATUS and the RLGENERATEXML in the CPY40101 table.  As always, try it in test first, to see if you get the desired results.  Let us know if you have any further questions.

    Thank you!

  • Bill Campbell Profile Picture
    12 on at

    So Deseree I make the change in the CPY40101 table and then 'regenerate' the electronic T4 and review the XML that is created?  That is all?

    Seems to good - but as noted, I will test first and let you know the results.

  • Deseree Krumm Profile Picture
    on at

    If you are looking to just have that 'amended' button checked/filled in, that should do it.

  • Bill Campbell Profile Picture
    12 on at

    Deseree, thanks for the details - I was able to update and report on the changes  - all well.

  • Deseree Krumm Profile Picture
    on at

    Excellent and glad to help Bill!  Have a great rest of your day.

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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 611 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans