Integrations

SmartConnect Define Company

This #TipTuesday post is about using the Define Company option in SmartConnect and why it's my number one way of identifying what company in Dynamics GP to integrate into.
Canadian Payroll

Mass Update CPY Basic Personal Exemption

This #TipTuesday post is about the CPY10105 table in Canadian Payroll (Dynamics GP) and how to update it if Basic Personal Exemption (or other tax credits) are incorrect.
Dynamics GP Security

What's included in those SQL rpt roles?

This #TipTuesday post is about identifying what is in the rpt_ SQL database roles in the system and company databases in Dynamics GP.
Canadian Payroll

Cdn Payroll T4 XML & Multiple Employers

This #TipTuesday post is about how the T4 XML file is generated from Dynamics GP Canadian Payroll when there are multiple employers.
SQL Server Development

Fun with XML, the end

This is the 5th post in a 5-part series where I was building an XML file in SQL with Dynamics GP data and Extender data for T5 filing.
SQL Server Development

Fun with XML, part 4

This is the 4th post in a 5-part series where I was building an XML file in SQL with Dynamics GP data and Extender data for T5 filing. In this post, I discuss file validation.
SQL Server Development

Fun with XML, part 3

This is the 3rd post in a 5-part series where I was building an XML file in SQL with Dynamics GP data and Extender data for T5 filing. This post is about namespaces.
SQL Server Development

Fun with XML, part 2

This is the 2nd post in a 5-part series where I was building an XML file in SQL with Dynamics GP data and Extender data for T5 filing. This post is about the "guts" of the SQL to create the XML.
SQL Server Development

Fun with XML, part 1

This is the 1st post in a 5-part series where I was building an XML file in SQL with Dynamics GP data and Extender data for T5 filing. This post is the intro and story on why I needed to do this and the trials and tribulations of my various efforts to get it working.
Dynamics GP

Additional menu in GP windows

This #TipTuesday is about Additional menus, what they are and how security works with them.
You've successfully subscribed to JenKuntz.ca
Great! Next, complete checkout to get full access to all premium content.
Welcome back! You've successfully signed in.
Unable to sign you in. Please try again.
Success! Your account is fully activated, you now have access to all content.
Error! Stripe checkout failed.
Success! Your billing info is updated.
Error! Billing info update failed.
Press ESC to close.