Today’s #TipTuesday post is a pretty short one. A client of mine recently merged with another firm and part of that was everyone getting new email addresses for a new web domain. For most of the users that used email functionality in GP, it was a non-event: they simply logged into the “Exchange Log On” prompt with their new email and password and continued with their task.
For one user, however, they were stuck in an endless loop of “Login Failed: check your login information and try again.”. In this case, the user had gotten married and had a name change so their Exchange profile had numerous aliases in it, which may be related to this, but I’m not 100% sure of that (it was the only “unique” thing I could think of for this individual).
Continue reading “Dynamics GP Email – Login Failed error”
Today’s post is short-ish and sweet. In my last post, I documented where to go to get registration keys. In the last part of the post, I had added a note that was specific to Canadian Payroll and today learned that it no longer applies, at least not for recent versions of Dynamics GP. I have edited that part of the post now…
This post is a very brief overview of the 2 things that need to be done in a company in Dynamics GP where you want to use the Canadian Payroll module. At some point I may start a series on more topics around Canadian Payroll but for today, it’s just two things you may want to know that aren’t necessarily obvious or well documented. Please note: this is specific to Dynamics GP, this is not a general “payroll in Canada” post!
Continue reading “Enabling the Canadian Payroll module”
This is a short post. I went looking for a customer’s registration keys and could not remember how to get to them now that the old CustomerSource links are dead and buried.
So… future “me”, this is your reminder! And for those who stumble across this, you’re welcome, I hope the info stays “correct” for the next few years so I don’t have to look for this again!
NOTE: I am not covering what to do if you cannot log in, that is outside of the expertise I can provide! If in doubt, contact your partner, and ask them to set you up as a professional under your account so you can log in.
Continue reading “Where can I find my registration keys on CustomerSource?”
Today’s post is combining the topics of the previous two posts and moving into Power Query to connect to SQL directly instead of connecting to static, exported SmartLists or flat files.
The previous posts in the series are:
Continue reading “Power BI, Excel & GP – SQL sources”
This is the third post in the series and I am going to dedicate this post to how to access GP data in terms of describing some of the options and factors to consider. Very little of this will have “how to” information about Power Query, but I will continue that in the next post.
The previous posts in the series so far are:
Continue reading “Power BI, Excel & GP – Data Access”
The first part of my series around Power BI, Excel & Dynamics GP begins with some of the basics, and a way to start learning Power Query, literally starting from scratch.
From my experience, an audience that is often overlooked are users who want to learn more or improve their skills but doesn’t know where to start, and everything they find starts at a point they don’t understand or can’t get to. For example, this post starts without getting into directly accessing data from SQL, which admittedly adds a level of complexity that some users have trouble getting past. Most of the rest of this series I will be accessing SQL data as that’s more efficient, but in this one, I’m using SmartList exports to make the learning more accessible.
This is post #1 of the series, aside from the introduction post here. In this post, I’m using the context of Dynamics GP to make a “real world” example with Accounts Payable data.
Continue reading “Power BI, Excel & GP – Starting from scratch”
This is most likely the shortest #TipTuesday post I will ever create!
I was playing with a SmartList to prep for my upcoming series on Power BI, Excel & Dynamics GP. I stumbled across something I have never seen before: I tried to add too many columns to a SmartList!
Continue reading “Maximum columns in a SmartList”
Soon I will be starting a new series of posts around Dynamics GP and how to get data out of it with Power BI or Excel via Power Query. There is no shortage of reporting options available for Dynamics GP customers, with many ISV (3rd party) products out there to augment some out of the box options (Report Writer, SmartLists). However, as with accounting departments everywhere, there is a heavy reliance on Excel as the “go to” tool for reporting and data analysis.
There are a lot of customers who do a lot of “export this SmartList to Excel and then do X” to get data ready. I’ve found many users do things in Excel that are repeatable yet are unaware of Power Query and more advanced ETL (Extract, Transform, & Load) techniques to automate some of the work. The other part of the coin here is there are many times where users or management want to get dashboards and higher level metrics on how they are doing, not just data dumps to wade through. I hope to cover a bit of both here.
Continue reading “Power BI, Excel & Dynamics GP”
In all the 2020 excitement, I realized I never posted about the 2020 Year End update. I think 2020 for me was all about getting through day to day things and I just forgot about this. Anyway, I’m back to blogging semi-regularly again and it’s that time of year again.
The CRA (Canada Revenue Agency) released their T4127 guide for January 1, 2022 very late this year (December 14th). Typically Microsoft (& other software vendors) get in late November to allow them adequate time to update their software for the new year tax changes.
Update 3: December 22, 2021 – The CanPay update is ready. See below.
Continue reading “Canadian Payroll 2021 Year End Update”
This post is about an issue that I found when testing the ROE (Record of Employment) functionality for a client in Dynamics GP. (Since “ROE” is a generic term, this post is specifically about a bug in the Dynamics GP Canadian Payroll module). I opened a case for it and it was quickly confirmed and written up as a quality issue (#91928 in case you need to add yourself or your customer to the list of affected clients).
Continue reading “ROE issue in Canadian Payroll”