I’d successfully run an integration of the chart of accounts which threw out a couple of warnings. After amending the file I realised that GP was no longer showing in the task bar and assumed that I had accidentally closed it. I restarted it and logged into the test company and tried to run the COA integration again and got the following error message;
Getting the form to display a menu option on the Additional tab of the Creditor window was easy enough but I had trouble finding out how to make it display on the Cards menu.
After struggling with it for a while, I remembered reading a discussion between Mariano Gomez and David Musgrave about long module names and how Visual Studio Tools for Microsoft Dynamics GP 2010 wasn’t the longest but instead Menus for Visual Studio Tools for Microsoft Dynamics GP 2010 was the longest.
A quick search found the module, in the very obvious location, of David Musgrave’s Developing for Dynamics GP blog; Menus for Visual Studio Tools Build 9 Released which can be downloaded from either PartnerSource (login required) or CustomerSource (login required).
The module comes with full instructions on how to install and use it.
Great idea, but it occurred to me that this could possibly be done with a little less work. Continue reading “Extracting Images From Microsoft Word 2007/2010”
I’ve kept my hand in enough that I can still do some coding and last weekend, after chatting with a developer in the office who is creating some new screens for GP, I decided to have a little dabble with the Visual Studio Tools for Microsoft Dynamics GP myself. Continue reading “Error During Build in Visual Studio Tools For Microsoft Dynamics GP”
As David explains, DEX_ROW_ID was added when support for SQL Server was added to Microsoft Dynamics GP but is not guaranteed to always remain the same. For example, a change to the table structure during an upgrade could result in the DEX_ROW_ID changing. As it isn’t a fixed value, it should never by relied upon in customisations, integrations or custom code.
I do this fairly often as I use quite a lot of Virtual Machines for testing different configurations, but I don’t want to have to build a new one every time, so I make copies of a base VM and rename it each time I want a new one (there is often more than one running at any one time and I want to avoid conflicts).
As well as renaming the machine inside the VM, I also rename the SQL Server to make sure it matches the name of the machine; I’ve had problems before with Microsoft Dynamics GP when I’ve not done so.
Doing this is actually very simple. Continue reading “How To Rename A SQL Server”
I needed a demo environment and so installed the most recent version. I’ve been getting an error since that time whenever I switched back from Report Writer to GP itself;
At my last company, we decided to make this process as easy as possible for clients, so we started creating a SQL Agent Job which would do the backup, restore and run the scripts with minimal effort or could even run on a scheduled basis. The basic purpose was to give the client a test or training system which was always, or could very quickly be, up to date. Continue reading “Copy Microsoft Dynamics GP Live Company To Test Automatically”