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

Payroll Tables in Canada

(0) ShareShare
ReportReport
Posted on by 12

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

I have the same question (0)
  • Derek Albaugh Profile Picture
    on at

    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

  • Bill Campbell Profile Picture
    12 on at

    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.

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

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans