Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Payroll Tables in Canada

(0) ShareShare
ReportReport
Posted on by 22,647

Hello everyone, I know that Victoria Yuden has a great site with all the GP tables laid out, but I am looking for anyone that has done something similar with Canadian Payroll.

Go figure that someone has decided that they need to design a better advice slip for their staff and allow for it to be published.  They decided not to go on with the Canadian Payroll solution as they could not get to the Employee Self Serve and what they could do with it was really not what they felt they wanted or needed.

So, they have moved on and are doing a third party web portal for the employee to manage time off, HR matters and to get their pay stubs from.

Now I need to figure out with them how to get the details that GP will generate into a form that they can pass to the 3rd party and publish.

So my request is to find something like what Victoria has done for the other modules in GP, and get a list of the Table Names and key fields in each for Canadian Payroll.

Thanks in advance for your time and effort on this matter.

*This post is locked for comments

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Payroll Tables in Canada

    Derek, thanks for the list of tables.  Now I just need to fill in some of the key table field names and I will be set.

    The request for that to exist is really where I would like to be.  I need to be able to create a view of data from the Canadian Payroll in order to allow a developer to come and pick and choose the information that they want to display in their HR Application.

    Hope someone can assist.

  • RE: Payroll Tables in Canada

    Bill, here is a spreadsheet with a list of Canadian Payroll tables for Dynamics GP 2016. Most likely this is the same for GP 2018 and prior versions as well.

    Let me know if this isn't what you're looking for.

    CanadianPayrollTableInformation2016.xlsx

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans