Hello!

Welcome to my blog! My name is Jen Kuntz, I am a CPA (CGA) and my blog is about Microsoft Dynamics GP, Excel, Power BI as well as other random topics from time to time.

Smiling thumbs up light bulb

  • Originating fields in SmartList

    Today’s #TipTuesday is a bit about the “Originating” fields in SmartList, what they are and what one may find in them. These fields are found under the Account Transactions SmartList (under Financial) and in certain circumstances, users will be able to extract *some* sub-ledger information from their GL to supplement their account analysis. What are… (continue >)

  • eConnect Distributions – double trouble

    Today’s #TipTuesday post is yet another integration-related post. In my case, it’s about Payables Transaction Entry and distributions doubling up. This tip will (or should) also hold for other eConnect nodes that have optional GL distributions as most behave in the same default manner I describe below. I was building a Payables Transaction integration for… (continue >)

  • SmartConnect, Variables & Quotes

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

  • 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. (continue >)

  • Fixed Asset Labelling

    This #TipTuesday post is information about Asset Labels vs. Asset IDs and when to use the Asset Label feature. (continue >)

  • 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. (continue >)

  • Mass Update CPY Basic Personal Exemption

    Last week, I was asked if I knew of a quick way to update the Basic Personal Exemption (“BPE”) amount in Dynamics GP Canadian Payroll. It’s not the first time I’ve been asked as it’s relatively common for an “oops” on the CPY Year End Close routine to either forget to update the personal exemption… (continue >)

  • What’s included in those SQL rpt roles?

    ,

    Today’s #TipTuesday is a security tip to help administrators identify what exact permissions the SQL fixed database roles have, that start with rpt*. When granting access to some of Windows users or groups, admins want to know what they can get into, right? The purpose behind the rpt* roles was for SSRS (SQL Reporting Services)… (continue >)

  • Cdn Payroll T4 XML & Multiple Employers

    Today’s #TipTuesday is too late for 2018 filings but hopefully, those this applies to will file it away for next year. The post is a result of a question from a consultant who works for one of the Dynamics GP VARs in the Toronto area, whose client asked how to get 1 XML T4 file… (continue >)

  • 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. (continue >)

  • 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. (continue >)

  • 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. (continue >)

  • 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. (continue >)

  • 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. (continue >)

  • Additional menu in GP windows

    Today’s #TipTuesday is a pretty simple one, it’s about the Additional menus in GP windows that appear when using Extender (from eOne Solutions) or other ISV solutions or customizations that add functionality to existing Dynamics GP windows. I learned something that shouldn’t have been new to me, so I either didn’t know this or had… (continue >)

  • Prepaid Visa Card rip-off

    This post is a warning to those buying or receiving prepaid credit cards. Watch the terms, mine starts with $3/month charges to reduce the balance on the card after one year of activation. (continue >)

  • When did that GL Account get added?

    This phrase was uttered in the office recently, by the person who is tracking final changes to the year-end Financial Statements. Her statements were out of balance, which turned out to be a new GL Account. The next phrase was “Oh sorry, I forgot to tell you I added that. There must be some way… (continue >)

  • SmartList Options

    Today’s #TipTuesday is about the SmartList Options window, a hidden gem! The misconception is some of the things I’m describing might require using SmartList Designer or Builder to create new SmartLists. Many useful tweaks can be made without any of those tools. What is it? First of all, this window is found on the Administration… (continue >)

  • Changing Password Managers

    ,

    This post is my experience with changing Password Managers from LastPass to 1Password. (continue >)

  • My write-off doesn’t add up!

    Or does it? Today’s post is the first #TipTuesday of 2019 and a little bit of an obscure one at that. The short version is if using the write-off feature while applying payments or credit notes in Dynamics GP Receivables Management, the results display rather oddly on the RM Historical Aged Trial Balance (HATB). In… (continue >)

  • Keeping up with the MVP firehose

    It’s January, which means we’re coming to the end of another contribution year for those of us Microsoft MVPs that are up for renewal on July 1st. By the end of March, we need to have submitted our contributions, and new this year, answered the four magic questions on the MVP site. This is the… (continue >)

  • New Year’s Resolutions 2019

    ,

    Well, it’s that time of year again, and time to look back at 2018 and plan for the new year. This is the 9th year where I’ve been writing these resolution posts and it’s always fun to look back at what I thought the last year would bring. If I could describe 2018 in one… (continue >)

  • Top 10 Blog Posts from 2018

    I took a look at last year’s top 10 list and 4 “new” posts made it to the top 10 with the oldest post being from August 2011. This year, 7 posts made the list from 2018, and 3 repeats. It’s always interesting what topics or posts have staying power or something relevant to today’s… (continue >)

  • Clear Companies script & custom tables

    ,

    This is a funny story… or funny now that I’ve figured out the problem I had earlier today. This story begins with a DEV/TEST environment for Dynamics GP where I was setting up some scripts to automate the process of restoring from PROD to DEV. I posted a blog article about this earlier this year… (continue >)

  • Quick Journals

    The last couple of #TipTuesday posts have been around some older “new” features – copy journal entry and backout/correct journal entry. Today I thought I would write a quick tip post around one of the lesser-known options for creating journal entries in Dynamics GP: quick journals. Next week for my last #TipTuesday of the year,… (continue >)