Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Canadian Payroll T4 Electronic copy XML file content error

Posted on by Microsoft Employee

Was notified by 2 separate clients this morning that the XML generated via printing the electronic copies of T4's was rejected at CRA. The error received from CRA was the 'file contains errors and would not be submitted'. When reviewing with the client directly in GP, file verification and generation did not contain errors. It is only when uploading the XML to the CRA website do you become aware of this with no indication of what the error is. 

Further investigation showed that if you open the generated XML directly, you will see an error similar to the below embedded somewhere in the file. 

10502.Capture.JPG

If you open the XML in Notepad, and search for "fileramendmentnote", you will see that there is only one tag line noted; an end tag line. There is no open tag line. This is what is preventing the client from submitting the file to CRA. 

Further, in Notepad, when you locate the line, it is located within the file in the T4 Summary section right below where code indicates the file is an original file. 

Error Noted below in Red

<rpt_tcd>O</rpt_tcd>
</fileramendmentnote>
<T4_TAMT>
<tot_empt_incamt>899072.98</tot_empt_incamt>
<tot_empe_cpp_amt>29078.09</tot_empe_cpp_amt>
<tot_empe_eip_amt>9841.78</tot_empe_eip_amt>
<tot_rpp_cntrb_amt>0.00</tot_rpp_cntrb_amt>
<tot_itx_ddct_amt>210957.39</tot_itx_ddct_amt>
<tot_padj_amt>0.00</tot_padj_amt>
<tot_empr_cpp_amt>29078.09</tot_empr_cpp_amt>
<tot_empr_eip_amt>11642.79</tot_empr_eip_amt>
</T4_TAMT>
</T4Summary>

We found that if you remove the end tag line and save the file, you will then be able to successfully upload the file to CRA. (this fix is only for original T4 submissions - not amended T4's)

Corrected XML code

<rpt_tcd>O</rpt_tcd>
<T4_TAMT>
<tot_empt_incamt>899072.98</tot_empt_incamt>
<tot_empe_cpp_amt>29078.09</tot_empe_cpp_amt>

**We have not tested/verified what will be noted if the T4 submission is an amended copy. **

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Canadian Payroll T4 Electronic copy XML file content error

    My pleasure! I am glad it worked. We have been using it a lot this week.

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at
    RE: Canadian Payroll T4 Electronic copy XML file content error

    editing the file worked for us also

    Thank you Jodi for posting!!

  • SRStafford Profile Picture
    SRStafford 30 on at
    RE: Canadian Payroll T4 Electronic copy XML file content error

    THANK YOU!  I had no idea how to fix this.  I really appreciate you sharing your discovery.

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at
    RE: Canadian Payroll T4 Electronic copy XML file content error

    Desjardins outsourcing

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Canadian Payroll T4 Electronic copy XML file content error

    Tamy, I was able to remove the arrent line as identified above and have had the CRA accept the document on the first pass.

    The fix did work after installed - did not like to have to duplicate the update within 2 weeks.

    What are you moving your payroll over to?

    Bill

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at
    RE: Canadian Payroll T4 Electronic copy XML file content error

    It appears there is a hotfix to fix the XML format

    community.dynamics.com/.../microsoft-dynamics-gp-january-2018-hotfix-has-released

    and vague instructions on how to install it other than of course it has to be installed on all workstations AGAIN.

    so glad we are dumping this product

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at
    RE: Canadian Payroll T4 Electronic copy XML file content error

    CRA is rejecting our file too

    Haven't tried an edited one yet.

    Tam

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Canadian Payroll T4 Electronic copy XML file content error

    If you have already received a confirmation from CRA web submission, then there is nothing that needs to be done.

    If you have not yet successfully submitted the file to CRA, then you do not need to change the submission reference ID, nor the file name, as CRA does not yet on file the original.

    It sounds like there may be another issue within the file that is causing the rejection. Did you verify the content prior to creating the electronic T4's?

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Canadian Payroll T4 Electronic copy XML file content error

    Question - if you have submitted the T4.xml file with Name : FILE001.xml do you need to send with the same name?

    Secondly, do you have to update the Submission Reference ID in the XML file?

    I have tried to remove this line - and CRA still rejects the file.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Liquid error: parsing "/forums/thread/details/?threadid=%27nvOpzp;%20AND%201=1%20OR%20(%3C%27%22%3EiKO))," - Too many )'s.