News

Back to consulting!

A brief announcement that I am resuming my consulting career after a brief stint with a client as an FTE.
Microsoft Excel Microsoft Office

Excel Paste Special - Operations

This #TipTuesday post is how to Paste Special with a multiply or divide operation to quickly change the sign on a set of data.
SQL Server

SQL Alerts with HTML email body

This #TipTuesday post is about some SQL code I'm using in SQL Agent job alerts to get more information in a more readable format in my email notifications.
Personal

In search of the perfect credit card

This post is off-topic about a series of trials and errors in finding the right credit card for my needs.
SmartList & SmartList Builder

SmartList stuck on My Reports pane

This #TipTuesday post is about using SQL to fix an issue with the My Reports page in Dynamics GP showing a SmartList favorite that is no longer there.
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.
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.