Resource not found in dictionary error

Greetings everyone! Yes, it’s been a while, my apologies. I’m struggling with motivation to write and hoping it comes back soon!

Today I wanted to post a short blog on a support issue I had today. It is something that I can find a couple of references to online, but not many, so that tells me it’s worth it to share my experience and validate some of the other threads that confirmed the solution.

Continue reading “Resource not found in dictionary error”

Dynamics GP Email – Login Failed error

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”

Enabling the Canadian Payroll module

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”

Where can I find my registration keys on CustomerSource?

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?”

Power BI, Excel & GP – Data Access

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”

Power BI, Excel & GP – Starting from scratch

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”

Power BI, Excel & Dynamics GP

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”

Canadian Payroll 2021 Year End Update

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”

Posts navigation

1 2 3 4 27 28 29
Scroll to top