Month: November 2011

4th Dynamics Certification Gained: Managing Microsoft Dynamics Implementations

Ian Grieve2 minute read3 Comments

Microsoft Dynamics GPI’ve been a bit quiet again this week posting wise, but this was because I was preparing for a Microsoft Certification exam yesterday.

Fortunately, I passed and am now the holder of a Managing Microsoft Dynamics Implementation certification along side the three Dynamics GP certs I already had; GP 10 Installation & Configuration, GP 10 Financials and GP 2010 Inventory & Order Processing.

I’ve taken a look at the Certification Planner on Microsoft Learning to see how far I am from an MCITP in Installation & Configuration for Microsoft Dynamics GP. I think I’m one certification away but it’s slightly hard to tell as the planner hasn’t been updated with the GP 2010 exams.

Fixing A Corrupt Account Index Master

Ian Grieve2 minute read4 Comments

Microsoft Dynamics GPA while ago I investigated an issue where some reports were not working correctly on a client system; they’d been written with Crystal and were not returning transactions for newly created accounts.

As reports I write tend to do, these reports were joining to the General Ledger via the GL Account Index Master (GL00105) table and then joining to GL Account Master (GL00100) for the account descriptions. I wrote the following script to check the two tables against each other to see where the problem lay (my suspicions were on GL00105 being corrupt as the accounts were being used within Microsoft Dynamics GP Continue reading “Fixing A Corrupt Account Index Master”

Making A Drive Available Over The Remote Desktop Connection

Ian Grieve2 minute read1 Comment

WindowsI needed a colleague to backup and copy a clients Microsoft Dynamics GP System and Company database back to our systems remotely out of standard working hours.

While I may have used FTP or similar if I had control of all software installed on the server, in this case the best way of doing this was to just use the Remote Desktop Connection and a local drive made available and copy the backups to this drive over the connection.

However, the colleague who was going to do this for me out of hours is not from an IT background like I am. He’s one of those Mark Polino laments the absence; a qualified accountant who has moved into a role as a Microsoft Dynamics GP consultant.

As he’s not from a technical background, there are some things I take for granted which he does not know of. I therefore documented the process of making a drive available over the RDP connection for him and I thought I’d post it up here as I thought it might be useful to others. Continue reading “Making A Drive Available Over The Remote Desktop Connection”