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?
Seemed like a good idea at the time. So we set the field to Use Input and then they ran it, it gives them a drop down list, and they chose False, as in “re-activate”. They run the integration and start getting a bunch of errors “This account has a current balance”. Hmmm. That should not matter if you are “activating” so I didn’t understand the message.
Continue reading “Bizarro world: Integration Mgr “use input” doesn’t work”
I’ve been using Windows 8 now on my new laptop for about a couple of weeks. I *love* it! What baffles me is the sheer volume of blogs and articles I run into that are crapping all over this new operating system… it’s hilarious really. “How to make windows 8 look like windows 7”?? Are you serious? Why bother upgrading if you’re going to do that?
Enough of that. Part of the learning curve has fortunately been handled by reading other users’ experiences and searching out tips and tricks to understand how to get things to work for you. None of what I’m putting in here is new or revolutionary, but hopefully it helps someone out!
Key note for all of these tips: I am not using a touch device so these tips are 100% for keyboard and mouse users… some might work for touch too, I have no idea!
Continue reading “Fun with Windows 8”
Time has flown by, as it does tend to do when you are not paying attention! One minute I’m in Fargo at the Technical Airlift, dropping a perfectly functioning laptop on a hard tile floor (yes, boy, that was fun!), and the next, it’s nearly Christmas and I’m loading Windows 8 on a even more perfectly functioning new laptop. It’s wrapped in bubble wrap to protect it from myself, just so ya know… ; )
When the Windows 8 previews and betas came out, I fully intended to install them on a virtual image or something, and get to know the new features. So much for that! The, ahem, fortunate timing of dropping a laptop and having my other functional Dell brick fail to boot led me to a just-in-time-for-Christmas new shiny laptop. While my American friends were eating Thanksgiving turkey, I was doing some timely Black Friday shopping. It seems Canadian retailers have adopted the sale weekend much to our price advantage!
Continue reading “Windows 8 install tips and tricks”
A continuation of the first part of my articles on the GP 2013 Web Client, this goes through some of the other training things that were covered that are installation related. Some of the things in this article are:
Continue reading “Dynamics GP Technical Airlift 2012 – Web Client part 2”
Tuesday was the unofficial first day of the conference for me with the agenda being one of two things for those who chose to come a day early. There was a sales presentation for those on the business development side and there was technical training on the web client for the rest of us.
Generally you have to pay for training but due to the importance of this product release and the new content, Microsoft put this training on for free – which was awesome. They really want to make sure the Partner channel is informed and ready for the web client specifically, and understand the “stack” dependencies to be able to troubleshoot it when it does release.
Continue reading “Dynamics GP Technical Airlift 2012 – Web Client part 1”
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!”