SmartList & SmartList Builder

Originating fields in SmartList

This #TipTuesday is about the "Originating" fields in GL SmartLists and what they contain.
Integrations

eConnect Distributions - double trouble

This #TipTuesday post is about integrating with eConnect to Dynamics GP and a strange case of duplicated GL distributions.
Integrations

SmartConnect, Variables & Quotes

This #TipTuesday post is about integrating into Dynamics GP with SmartConnect, and using variables with something to watch out for.
Integrations

Object reference not set to an instance of an object

This #TipTuesday post was a fun one. I kept getting an error "object reference not set to an instance of an object" while integrating into Dynamics GP in SmartConnect and it took me a while to find the reason for it.
Fixed Assets

Fixed Asset Labelling

This #TipTuesday post is information about Asset Labels vs. Asset IDs and when to use the Asset Label feature.
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.
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.