-
Resource not found in dictionary error
Greetings everyone! Yes, it’s been a while, my apologies. I’m struggling with the motivation to write and hope it comes back soon! Today I wanted to post a short blog on a support issue I had. It is something I can find a couple of references to online, but not many, which tells me it’s…
-
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”…
-
ROE issue in Canadian Payroll
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…
-
SmartList Export – Excel Content Error
Last year, I wrote a post about a relatively common SmartList Export error, the “Excel cannot open the file” error. Today, I was working on a client upgrade and cleaned up a ton of minor issues with some Canadian Payroll SmartLists they use. In writing this post, I have also developed a quick hatred for…
-
Issues with Word Templates
Recently, there have been issues with Dynamics GP and Word Templates, due to some changes to the most recent Microsoft Office build releases. Specifically, documents generated in Word Templates cannot be opened in Microsoft Word, for environments running a build of Microsoft Office from Sept 8/9th or newer. Today’s post is an attempt to clarify…
-
SmartList Export – Excel cannot open error
Today’s #TipTuesday is one a client ran into a little while ago and is worth sharing how to find out what is causing the issue. The TL;DR version is a strange character that somehow was input into an invoice comment and it caused an issue when that record (with that field) was exported to Excel…
-
Thunderbolt dock problem? Try this.
This post is purely to save someone else (or my future self) the frustration of troubleshooting their Thunderbolt dock if they reinstall Windows and then can’t get the dock working. Background The context around my situation was this: I’m using a Lenovo P43s and Lenovo “ThinkPad Thunderbolt 3 Workstation Doc”, part 40ANY230US. I ran a…
-
SmartList Export Oddities
I am in the early stages of a set of tips around the use of SmartList in Dynamics GP. Today I was writing one for this coming Tuesday and in doing the prep work to get screenshots etc. ready, I was doing some exports. One thing led to another, and I realized I should include…
-
Where’d my navigation pane go?
Today’s #TipTuesday is a quick one! Last week, a client brought me over to their desk to ask me how to get their Navigation Pane back. It had gone missing for some reason, despite the option “checkmark” still showing as having the pane enabled. The issue Here is what their home screen looked like –…
-
Dynamics GP & Office 365
Today’s #TipTuesday is a post about Office 365 and Dynamics GP and is specific to email functionality such as emailing Purchase Orders, EFT Remittances and Sales Documents. Rest assured that most other functionality other than email seems straightforward and works no matter what (like exporting from Smartlist). (At least that’s my experience although there may…
-
Outlook credentials issue
A little while ago, I was trying to add one of my Office 365 email accounts back to Outlook and it wasn’t working. I forgot that I needed an app password because I have MFA (Multi-factor authentication) enabled on my domain/tenant. I initially put in my “regular” password and was expecting it to kick back…
-
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…
-
Object reference not set to an instance of an object
Today’s #TipTuesday is about one of the many things this error message could relate to, and it’s in the context of Dynamics GP and SmartConnect/eConnect integrations (not development, where it can also occur regularly for many other reasons). This error came up when I was attempting to preview my data in the Data Source section…
-
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…
-
Upload Pending issue in Excel with OneDrive
Recently I’ve noticed that every time I open an Excel document from my OneDrive sync folders, I’d be prompted with one of two messages/warnings. One was “Upload Pending” and the other was “SERVER FILE UPDATED. A newer version is available” with a Reopen Document prompt. This has been happening in nearly every single document I…
-
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…
-
Web Client & Account Level Security
So, I learned some interesting and unfortunate news today. I’ve been troubleshooting an odd issue with the GP 2016 Web Client. We’re in the early stages of upgrading from Dynamics GP 2013 to GP 2016. The news? The GP Web Client doesn’t play nicely if Account Level Security is enabled in a given company. What’s…
-
GP & Lowercase Database IDs
Some days I feel like I’m on a game show, where troubleshooting is a contest… “I’ll take strange GP errors for $400 Alex!”. Today is one of those days! One of my clients imports in SOP and Payables transactions via eConnect and then uses Postmaster Enterprise to post the batches. Today one of the QA…
-
Project Accounting mystery COGS account
A while back, a long-time client of mine told me about an issue they were having that they couldn’t explain. No problem, I said, let me have a look. I come from the school of “everything has a reason, things don’t just happen by themselves”. Well…. The issue On Receivings Trx Entry, the COGS account…
-
Cdn Payroll – Things that make you go hmm
This is a strange one, one of those things that makes me go “hmm”. I never understand how this happens, if it’s been here for years or just never been noticed. Anyway, in Canadian Payroll in Microsoft Dynamics GP (testing GP2010 specifically, in case it’s not the same in other versions), when creating a batch…
-
eConnect error, but not the real error!
One of my customers is doing some Sales Order Processing integrations with GP 2010, and for the most part, when we run into eConnect errors, it pretty much tells us what the issue is, and we fix it and move on. We ran into one the other day and this error wasn’t even the real…
-
eConnect error “configured identity is incorrect”
A client recently had an issue with their nightly eConnect integrations, getting an error about the username and password. This integration had been live for nearly 2 years, running every night, and running without issue – or at least without this kind of issue. In other words, fairly stable. They also never touch the service…
-
Some Canadian Payroll & Project Accounting gotchas!
Recently, a client of mine experienced a couple of weird things when we started to configure another Dynamics GP company for them with Canadian Payroll and Project Accounting in action. One of them is something to look out for if using the Canadian Payroll import processes; the second is more of a head-scratcher type of…
-
Canadian Payroll issues and fixes
Today I have 2 issues to write about relating specifically to Canadian Payroll in Dynamics GP; things that a couple of my clients have recently run into that are fairly common and easy fixes. Issue #1 is regarding stuck batches and the message “The batch is currently in use – Please wait until the other user…
-
How secure are your passwords?
A recent scenario at a client got me thinking about security – or lack thereof – that exists at some clients for various reasons as well as the flip side of ridiculous security that was going too far the other way. The Background I’ve been documenting the configuration of a third-party reporting & budgeting tool one…
