Tips, Tricks & Thoughts on Microsoft Dynamics GP
Articles filed under: Troubleshooting
Thursday, May 16, 2013 Integrations, Troubleshooting
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 accounts, so the thought that the password might have been changed was nearly impossible.
Read More →
Friday, March 29, 2013 Canadian Payroll, Troubleshooting
A couple of years ago around this time of year, I got a call from a client of mine with a strange error in Canadian Payroll. At the time, I ran into other significant issues in trying to help with said error, and at the time, I blogged/ranted about it here.
Fast forward to last month, when I received an email from another customer who was asking me "did you ever find out what the issue was with that error? We are having the same problem now!". We exchanged emails and I researched what notes I had taken at the time, and in the end, she confirmed for me that what worked for my client also worked for her.
So, this post is just an update on the issue and at least one resolution, in case it helps someone else out there. Some of this is a repeat of the rant blog, without the rant!
Read More →
Thursday, December 27, 2012 Integrations, Troubleshooting
This is a short post... a bizarre issue that I can't find an answer to.
A client has a bunch of inactive GL accounts and for a project, wants to re-active them to do some re-allocations and then inactive them again. Simple right?
I set up a simple Integration Manager integration for them, and set the "Inactive" field to "Use Input". In other words, let the user decide if they are inactivating or re-activating the accounts. Better than changing the integration, right?
Read More →
Friday, June 8, 2012 General Stuff, Project Accounting, Troubleshooting
My last post about the good and the ugly of the Update Budget Lines feature had a continuing theme to it. I was telling the story of the client who mass updated 650+ projects with a new cost category only to find the budget sources set to Specific didn't get populated with the default "specific" GL account.
What I didn't get into was HOW they found the problem. I built some integrations for them for Misc Logs, which they've been using for a while now and having no issues with. It's been a huge timesaver for them, and they love it. Great! So, fast forward to how they found out they had an issue was during the Misc Log import and posting. The problem was, eConnect didn't fail and alert them of the problem with the missing accounts, it allowed the creation of the transaction without GL distributions and they posted it without thinking to check! Uh oh x2!
This article is explaining the issue, another possible bug, in Project Accounting Misc Log Entry eConnect node (not a problem with Misc Logs themselves).
Read More →
Wednesday, June 6, 2012 General Stuff, Project Accounting, Troubleshooting
The other day a client asked me if there was a way to mass-add a new cost category to all projects at once. I actually didn't know there was a new function to do this starting with GP10, but a quick google search resulted in a post from Mark Polino describing this exact thing.
Wow. That doesn't happen every day... I was thinking of the alternatives I would explain the client, but was really happy to see this added functionality.
Until... today, after the client used the new window, and rolled down a new cost category to every project they have, they found a problem. Uh oh!
This particular article relates to the Project Accounting module in Dynamics GP, and the Update Budget Lines window under the Routines menu.
Read More →
Thursday, May 17, 2012 Canadian Payroll, Troubleshooting
This is a repeat of an article I wrote in November 2011 with updated information.
Issue #2 in that blog was regarding permissions during the Generate Cheques routine and the message "There is an error in the Transmission Header - Incorrect Length".
At that time, the fix seemed pretty obvious and it worked during testing on Windows 7 machines. I wrote about it, forgot about it, and moved on. Months later I learned the client doesn't use Windows 7 on the machines that they use payroll for (those machines happen to be older Windows XP machines) so the error never came up again and I had completely forgotten about it.
Fast forward to last month and another client of mine upgraded all of their workstations to Windows 7 and the error re-surfaced.
Read More →
Monday, February 20, 2012 General Ledger, Troubleshooting
What I'm posting today is hopefully of use to someone out there who runs into this same problem. Admittedly it's rare but it took me a while to find the answer.
In this case, "I" didn't find the answer, I found it buried in a community forums post from Sivakumar, one of the Microsoft Dynamics GP MVPs.
(Update: include link to Sivakumar's blog)
Read More →
Thursday, February 16, 2012 Canadian Payroll, Project Accounting, Troubleshooting
Recently a client of mine has 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 definitely something to look out for if you use the Canadian Payroll import processes; the second is more of a head-scratcher type of error where you don't know what the real problem is.
I call these things "gotchas" - I'm not sure that translates into all languages but generally means to me at least, something that "GOT" me, that I wasn't expecting or didn't think to look out for.
Read More →
Saturday, November 19, 2011 Canadian Payroll, Troubleshooting
Third time's the charm... :) Gotta love computers, I've written this twice already and lost it completely, the draft didn't even save. Argh!
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 is finished".
Issue #2 is regarding permissions during the Generate Cheques routine and the message "There is an error in the Transmission Header - Incorrect Length".
Read More →
Saturday, October 29, 2011 General Stuff, Security, Troubleshooting
It seems I am starting every post recently with "it's been a while since I last posted"! I have probably reached the point that it goes without saying... lol
A recent scenario at a client got me to thinking about security - or lack thereof - that exists at some clients for various reasons as well as the flipside of ridiculous security that was going too far the other way.
Read More →
RSS Feed