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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Canadian Payroll T4 Electronic copy XML file content error

(2) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Community Member Profile Picture
    on at

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

  • Tami Farrelly Profile Picture
    5,080 on at

    editing the file worked for us also

    Thank you Jodi for posting!!

  • SRStafford Profile Picture
    30 on at

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

  • Tami Farrelly Profile Picture
    5,080 on at

    Desjardins outsourcing

  • Bill Campbell Profile Picture
    12 on at

    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
    5,080 on at

    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
    5,080 on at

    CRA is rejecting our file too

    Haven't tried an edited one yet.

    Tam

  • Community Member Profile Picture
    on at

    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
    12 on at

    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

News and Announcements

Season of Giving Solutions is Here!

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 > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans