Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / CR Group's Changer...
Microsoft Dynamics GP (Archived)

CR Group's Changer for Canadian Payroll

(0) ShareShare
ReportReport
Posted on by Bill Campbell 22,647

We are working on an implementation of the Changer tool for Canadian Payroll and have encountered a 'minor' or could be 'major' issue.

Is there someone out there (not 02/03/15) that can assist me.

We have installed the 'single' click install - no issues

We have added the tools to the TEST company - no issues

We have entered the Registration Keys - no issues

When we try to Validate the Import of the list we get an error (see below) that suggests that there is a SQL error, yet there is nothing that I can see that suggests what the error actually is.

Wondering if anyone else has encountered this message and what was done to get out of the error.  Good news is we are running on a TEST Client against the TEST Database.

Hope someone can assist.

*This post is locked for comments

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: CR Group's Changer for Canadian Payroll

    Cheryl I should have closed this case over the weekend as we determined that due to a mismatch in the TEST client GP2013 folder, the CANPAY.dic was not running the correct version.

    The developer, CRG, sent out a corrected CNK file and all is well.

  • Cheryl Waswick Profile Picture
    Cheryl Waswick on at
    RE: CR Group's Changer for Canadian Payroll

    Hi Bill,

    I see I missed this additional information.   The report is a "list of invalid employee ID's."

    Verify if all the employee ID's in your import file are in both the CPR10100 and UPR00100.   My guess is that either an employee ID in the import file is mistyped, and so doesn't match or is missing from the CPR10100/UPR00100 tables.

    Thanks,

    Cheryl

    Microsoft Community

  • Cheryl Waswick Profile Picture
    Cheryl Waswick on at
    RE: CR Group's Changer for Canadian Payroll

    Hi Bill,

    What 'Changer' tool is this?  

    I couldn't find anything on this specific message, so I would recommend to test with minimal information in your import file.  Is there a field called 'isUPR' in your import file or in the table you are importing to?  Almost likes like its trying to insert in a value that is not allowed into this field, so it will not validate it.  

    I hope the above helps.  I will most likely need you to open a support case to troubleshoot further.

    Thanks,

    Cheryl

    Microsoft Community

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: CR Group's Changer for Canadian Payroll

    Quick Update

    Thinking I might have missed something, I went to Canadian Payroll and 'pushed' a UPR Table fill to the US Payroll tables.

    Not sure why this would matter, but, thought I might start by being able to say "I have tried that . . . ." when someone asks.

    Now I am getting the following error,

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans