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

  • GP Utilities user permissions

    ,

    Today’s #TipTuesday post is about GP Utilities and what permissions are required. For those going through any service pack install or upgrade, there might be a lot of workstations that need to be updated! In our case, we just upgraded the Dynamics GP environment and wanted all hands on deck to help with installs, including… (continue >)

  • GP Tech 2018 Wrap-up & Pennies for Taylor

    I’m getting ready to leave Fargo for another year and head home after a long but great week of learning and networking. For those who may have missed my earlier posts, here are the 3 posts I wrote after each day of the Dynamics GP Tech conference: Day 1 recap Day 2 recap Day 3… (continue >)

  • GP Tech 2018 – Day 3

    Today was day 3 at the Dynamics GP Tech Conference. As in other years, the 3rd day is a half day and many people head on their way back home right after the conference is done. For me, it’s a bonus part of a day off to regroup, review notes, check in on email etc.… (continue >)

  • GP Tech 2018 – Day 2

    Today (August 21st) is day 2 of the Dynamics GP Tech Conference. This post will be a fair bit shorter than yesterday as it only covers 1 day and I didn’t take as many detailed notes in the sessions I attended! DynPros Beta Distribution Exam The first thing on my agenda today was sitting in… (continue >)

  • Start/Stop SQL by Batch File

    This #TipTuesday post is about stopping and starting SQL Server services by batch file, something that is useful for those running a local SQL instance for development or testing purposes. (continue >)

  • GP Tech 2018 – Day 1+

    I’m back in Fargo, ND for the annual Dynamics GP Tech Conference. Today was the first day of the conference (Monday, August 20th). I arrived on Saturday morning, with very little trouble, except some minor stress of believing I might have been bumped from the 2nd leg of my flights to Fargo. It turns out,… (continue >)

  • Send Message to Users

    Today’s #TipTuesday post is a simple one, and it’s about user notifications. In Dynamics GP 2013 R2, the “Send Users Message” feature was introduced as an easy way to send a notification to users who are logged in or to add a task to the users’ reminder list in Dynamics GP. How to use it… (continue >)

  • Budget Transactions vs Budget Upload

    Today’s #TipTuesday is a brief post about Budget Transactions. Introduced in GP 2010, Budget Transactions were a feature to add more control over budget changes in Dynamics GP. Here is a brief post on how it works. Why would I use this? In the past with Dynamics GP, before GP 2010, changing a budget meant… (continue >)

  • Retained Earnings account is inactive error

    Today’s #TipTuesday post comes from a GPUG forum question that someone posted recently, answered by Victoria Yudin. It’s a good example of what I like to post as “tips” because it’s pretty small but useful to know. The question essentially was about getting an error about an inactive Retained Earnings account when trying to run… (continue >)

  • SSRS 2016 Report Builder Permissions

    This #TipTuesday post is about Report Builder permissions in SQL Server Reporting Services 2016. (continue >)

  • PowerApps Newbie – getting started

    I’m starting a series that might take months to get to any semblance of “done”! This series will follow a purely personal project, in terms of the content of the app I want to try to develop (golf stat tracking), using the Microsoft PowerApps platform. That being said, I will be tagging it as a… (continue >)

  • Getting rid of Day in Mgmt. Reporter date format

    Today’s #TipTuesday I *swear* I’ve blogged about before but for the life of me, I cannot find it in my posts. So… I’m documenting it here because I ran into this again after our latest Dynamics GP upgrade and had to search for my documentation to find the details of the fix. This tip is… (continue >)

  • Touring the Old Post Office in Galt

    Last week was the official celebration of the opening of the Old Post Office in downtown Galt, Cambridge. Construction began in late 2015, restoring & renovating this as the latest location of the Idea Exchange (Cambridge’s library system). Today, I went on one of the free guided tours of the new space and it’s fantastic!… (continue >)

  • Lookup window tips

    Today’s #TipTuesday contains some Lookup window tips. After last week’s tip on finding a shortcut to the Available to Promise window, I realized some hidden gems on Dynamics GP Lookup windows are often overlooked. What’s a “Lookup” window? Simply stated, these are the windows behind any magnifying glass icon in Dynamics GP. The primary purpose… (continue >)

  • Hidden shortcut on Item lookup window

    I wrote this on a plane because I realized I was heading on vacation and hadn’t yet written a #TipTuesday post. I’m on a roll now and didn’t want to skip a week!! So, this is pretty short, and maybe everyone else knows about this but it was new to me so I thought I… (continue >)

  • MVP Renewal for 2018/2019

    Today is Canada Day and I’ve been fortunate to get the official notification earlier today that I’ve been re-awarded for the next year. Woohoo! It’s a great way to start Canada Day! An email notification of my MVP renewal. This year’s renewal is a little bittersweet as there are several people I know who I… (continue >)

  • Remote Desktop & Multiple Monitors

    This #TipTuesday is about Remote Desktop Connection and using multiple monitors. (continue >)

  • Navigation Pane Options

    This week’s #TipTuesday is about the navigation pane and some very brief tips on personalizing what I can see. How to customize it By default, the navigation pane will show 4-5 panes, as pictured below. Depending on what I have installed in my environment, there may be more “panes” I have as icons below that.… (continue >)

  • User Preferences tips

    Today’s #TipTuesday is a recap of the User Preferences window. Last week I was doing some upgrade testing with some staff and I realized some users weren’t aware of how to personalize some elements of their Dynamics GP environment. So, this is a brief recap of what kinds of things are in the User Preferences… (continue >)

  • MVP emails gone mad!

    At the end of April, I thought I would experiment with something. I kept track of nearly every email that I received as a part of the MVP program for the entire month of May. I deleted nothing. However, some emails such as calendar invites are auto-deleted in Outlook once I accepted or declined the… (continue >)

  • Sample SQL Views for Smartlists

    ,

    Today’s #TipTuesday has been on my list for a while and it’s a great resource that many people don’t know exists. Microsoft has created a “living” document that has embedded links to SQL views that an admin can run and tweak in their Dynamics GP environment to create custom SmartLists. The document says it is… (continue >)

  • Upload Pending issue in Excel with OneDrive

    ,

    This post is about the annoying “upload pending” issue in Excel with OneDrive. (continue >)

  • Launching GP with alternate Dynamics.set file

    Today’s #TipTuesday post is one for those who modify reports in Report Writer (mostly) or anyone who has an alternate Dynamics.set file they wish to launch in their Dynamics GP environment. A quick review of the terms here: the Dynamics.set file is a launch file that displays the number of products/dictionaries installed on a given… (continue >)

  • Unassigned Security Report & Superuser roles

    ,

    This wasn’t going to be a “Tip” post but it’s Monday night as I write this, so it’s now becoming this week’s #TipTuesday. Funny how deadlines work! 🙂 Late last week, I was working on some upgrade tasks as my firm was going through an upgrade from Dynamics GP 2013 to GP 2016. One of… (continue >)

  • Mystery Window! Export Data (Solved!)

    This is a short post and a weird one! Tonight I was setting up my sample data to test some scenarios for a blog I’m working on. Earlier this week, I came across a situation with the Unassigned Security Report in Dynamics GP and I wanted to write a blog about that. Stay tuned for… (continue >)