It’s that time again, the time to trek to Fargo and be immersed in all things Microsoft Dynamics GP! The last technical conference was a blast and this proves to be no different.
The content this time around is, of course, Microsoft Dynamics GP 2013 and all of it’s new features including a ton of content around the new web client. Stayed tuned this week for bits of news as I have time to blog. Check out twitter if you want live action tweeting from myself and others – hashtags most commonly used are #airlift12 and #GP2013.
Continue reading “Dynamics GP Technical Airlift 2012 – Pre-Conference”
I was asked this question from someone a few days ago and I have a little bit of information about this. At some point I will expand on this article but for now, it’s a short one!
This article is simply about using Cdn Payroll and US Payroll together, as in “can you use them together”?
The short version is the supported method is not to have both in the same environment, i.e. same SQL instance. There is a KB article that spells out all of the “how to”, and describes two installs, two instances, one US English, one Canadian. That KB article is here.
Continue reading “Canadian Payroll & US Payroll in the same environment”
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).
Continue reading “Project Accounting: Misc Log eConnect import issue”
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 GP 10, 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.
Continue reading “Project Accounting: Update Budget Lines – the good and the ugly”
Well, it’s been fun but it’s time to focus on more interesting areas of Microsoft Dynamics GP. This is the last official article in the Report Writer series of posts I’ve written, although I’m sure there may be the odd article pop up that has some Report Writer content.
Continue reading “Report Writer Series: The End!”
Here, at long last, is my next-to-last blog post in the Report Writer series. It’s not that I’ve covered everything you could possibly know about Report Writer, not by a long shot, but what I’ve found is some of the basic information I’ve shared thus far wasn’t as easy to find as the more advanced stuff was. Do you want to know about using VBA with Report Writer? Editing package files? Adding Extender fields to a Report Writer report? There are many things like these that are already covered by the Dynamics GP community. In my last article I will summarize my series and include a few links to other Report Writer resources if you haven’t found them already!
Now onto this article… This one is a bit of a hodge-podge of things, there is no particular reason why these are all lumped together in one! The items here probably deserve more in-depth discussion but for the purposes of this blog I just wanted to highlight a few key things about them rather than dig deep into their usefulness.
Continue reading “Report Writer Series: Keys, Restrictions, Sorting, Grids”
The next in my series of blog posts about Report Writer is a brief article on Custom reports.
Why would you create a custom report in Report Writer? (really… why?) I’ve done it a handful of times, and don’t particularly recommend it (with all due respect to David Musgrave 🙂 ) but there are a couple simple reasons why it makes sense sometimes. The types of reports you would create with it would need to be extremely simple due to the fact there is no end user option for sorting or filtering results and no parameter input.
Continue reading “Report Writer Series: Custom Reports”
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.
Continue reading “Canadian Payroll – Transmission Header Incorrect Length error”
I’m continuing the Report Writer series with a brief article on Sections in Report Writer. Every once in a while I see a question on a forum “my field didn’t print and I don’t know why!”. Hopefully this will help answer that kind of question!
Continue reading “Report Writing Series: Sections”
Way back in February 2011 (yikes!), I wrote about some Report Writer toolbox items, and focused on the Arrange tab of tools. Today, at long last, I am concluding that article with some notes and tips on the drawing options (most font options), hopefully clearing up some mysteries.
Continue reading “Report Writer Series: Drawing Options Tips”