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, once you’re running a build from Sept 8/9th or newer. Today’s post is an attempt to clarify what the situation is, and what is and is not affected and clarify some of your options.Continue reading “Issues with Word Templates”
Hey, everyone reading this… no, I haven’t fallen off the face of the earth. I’m hoping to get back into regular blogging this Fall. Ahem, I mean Autumn. (that’s for David Musgrave 🙂 ).
I’ve been fortunate to stay safe & healthy as well as maintain most of my business during COVID-19, that’s the good news. There have been a few unrelated things that have kept me away from my normal blogging routine. Individually, they are things that normally would have little or no effect. Cumulatively, they weighed me down enough that blogging is what fell by the wayside.
I won’t go into details except to say that there are a number of things going on in the world, the U.S., and closer to home in Canada that have given me pause and make me wonder if what I’m doing *here* matters in the grand scheme of things going on out there right now.
It’s been a weird year, there’s no denying that, and like many of you I will be glad to see it come to an end. In the meantime, I have some work to do to rebuild a lost virtual machine on my computer so I can re-install SQL and Dynamics GP and get back to having an environment to test and mock-up scenarios for blogging.
Stay tuned… 🙂
Today’s #TipTuesday is an odd one. A few months ago, a client had an issue with a specific Excel workbook they couldn’t “open”. Of course, the usual questions around “is there an error message?” etc. didn’t pan out. Typically it might be a corrupt file issue or something, but once I saw the issue on their computer, I realized what the problem was. It turns out someone accidentally “hid” the workbook and then saved it for the next unsuspecting user. To the user, it was akin to voodoo, something appears to “open” but nothing is visible.Continue reading “Excel – where did my workbook go?”
This is a bit belated, but I wanted to share the info about this year’s tax update for those in affected jurisdictions. Last year, there were no changes in any jurisdiction. This year, there are only changes in 2 jurisdictions – British Columbia and Yukon. There are fixes for a couple of issues with Quebec around the RL-1 XML file and QPIP.Continue reading “Canadian Payroll 2020 Mid-Year Tax Update”
Today was a good day. It is Canada Day, which is a national holiday, and already a great day for us Canucks, but July 1st is also MVP renewal day for close to 3,000 Microsoft MVPs worldwide. I’m pleased to share that I was awarded for the 4th time today, within the Business Applications category (where Dynamics GP resides).Continue reading “MVP Renewal for 2020/2021”
Today’s #TipTuesday is one a client ran into a little while ago, and is worth sharing how you may find out what is causing the issue. The TL;DR version is a strange character somehow was input into an invoice comment and it caused an issue when that record (with that field) was exported to Excel from a Dynamics GP SmartList. Exporting to Word instead of Excel showed where the character was to be able to edit the data to remove it.Continue reading “SmartList Export: Excel cannot open error”
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.Continue reading “Thunderbolt dock problem? Try this.”
Today’s #TipTuesday is around email functionality in Microsoft Dynamics GP and some tips around how to test it. As you may have read in my post last week, I made some mistakes in testing that have led to this post. Long story short: I neglected to edit all the tables that had live email addresses when I did some testing. There are some other things I could have also done to prevent compounding the problem, and all of that is what I intend to cover in this post.
The background to this post is the standard non-Workflow related email for emailing documents to customers or vendors. While some of what I’m about to say may apply to Workflow emails, I am going to be explicit here and say I didn’t not document all of the places where Workflow may contain data and it’s not covered here. The only mention of Workflow is in relation to valid Series settings in the SY04902 table.Continue reading “Testing email functionality”
It’s been a while since I wrote a non-technical post, so I thought I would share a situation that happened to me earlier this week and how I dealt with it. At the risk of coming across as a complete moron to whomever reads this, when many would simply never mention it again, I am a believer that sharing things helps others. The gist of this post is not about the mistake itself but how to own up to them, or more specifically, how I own up to them.
There are many articles about how social media makes it seem like everyone around you is doing great, the sky is always blue and the sun is always shining and how that tricks people into believing your own life is somehow abnormal or inferior. The same goes with reading or hearing about the work of people successful in their given field, you’d often think “Wow, they’re perfect, I’ll bet they never make mistakes!”. I am fortunate not to have much to complain about, but I do share both good and bad things for just that reason – to show I’m human, and to be human is to be imperfect. I make mistakes. We all make mistakes. I have learned from other people sharing their rough moments and perhaps someone will learn something from mine.Continue reading “Owning up to your mistakes”
Today’s #TipTuesday is the finale of my series on Fixed Asset transactions in Dynamics GP and what G/L accounts get used where. Today is where I will walk through the rest of the catch-all set of scenarios around what kinds of asset changes impact the G/L.
The previous posts so far are:
- Additions with & without YTD/LTD amortization
- Retirements in the 1st year of ownership
- Retirements after the 1st year of ownership
- Different retirement types & impact on Gain/Loss Account
- Retirements with proceeds and sale expenses
- Account changes & Mass Change impact on G/L