Tag: microsoft office
While importing a customised Form with VBA I encountered a problem and received a Component write exception; Component Write Exception The form itself had imported but the VBA element had not. Not having seen this error before I hit up … Continue reading →
I recently encountered a problem trying to install the .NET Framework 3.5 in a virtual machine on my test server which is not connected to the Internet (I wish it was but I am currently renting and don’t have a … Continue reading →
I was recently on site with a client doing an upgrade from Microsoft Dynamics GP 2010 to 2013 and implementing Management Reporter 2012 to replace FRx 6.7.
I was out on site a short time ago implementing Management Reporter 2012 for a client and ran into a problem with Management Reporter.
It’s not uncommon to find system administrators and consultants alike struggling to deploy Microsoft Dynamics GP SRS reports in an environment, while trying to keep these reports secured. I find that the main issue revolves around understanding the different moving parts: domain accounts, GP user logins, the SQL Server database roles created for reporting, the reports web site security, the reports folder security and the list goes on. So here is a list of resources that I believe will help with this: The best place to start is the SQL Server Reporting Services Guide, which has all of the information for installing, deploying and setting up security for SRS reports to use with Dynamics GP.
Just recently I have been seeing a number of questions around Microsoft Dynamics GP 2013 Smartlist exports to Microsoft Office Excel not being formatted correctly – let’s rephrase, the correct word to use here is “nicely”. The issues usually involve leading zeroes being dropped (in some cases) and currency amounts being exported with 5 decimals and no currency symbol.
I have many other outside work items competing for my time at the moment which, combined with being busy at work is leaving me little time for reviewing. To that end I’m snatching an hour while sat at a hotel … Continue reading →