New Microsoft Dynamics GP Statement of Direction Available

Microsoft Dynamics GPErrol Schoenfish on the Inside Dynamics GP blog has posted a new Statement of Direction for Microsoft Dynamics GP.

The Statement of Direction can be downloaded from PartnerSource or CustomerSource (login required). Continue reading “New Microsoft Dynamics GP Statement of Direction Available”

How To Create A Domain Controller

Windows ServerThe release of Management Reporter brought several advantages over FRx; x64 compatibility, replacement of the Access database with SQL Server and a modern client among them. However, one of the downsides is that Management Reporter requires a domain to be available for both the installation and running.

Where FRx could be run on any PC or laptop regardless of the operating system, Management Reporter can only be run on a server OS. This means that the Business Development Managers, and I, need either a laptop with Windows Server 2008, or better the R2 version, installed or we need a VM with the same. To make everyday life easier I opted for the latter as I can install it once and then copy the VM between machines.

I am a Microsoft Dynamics GP consultant by training, certification and experience but I don’t have a huge amount of experience with Active Directory. I am the most knowledgeable here about installing GP and Management Reporter though, so it falls to me to do the setup of the demo systems and I figured I might as well do the full monty rather than getting someone else to install the operating system and then passing it back to me.

To this end I needed to learn how to install and configure Active Directory Domain Services (ADDS) and I thought it best to document here for anyone else interested and also for my own future reference. Continue reading “How To Create A Domain Controller”

azurecurve Now Syndicated To The Microsoft Dynamics GP Community Site

azurecurveContinually expanding the ways you can read azurecurve; this site has been added to the list of syndicated blogs on the Microsoft Dynamics GP Community website.

Thanks to Steve M for putting me forward and Justin S for doing the rest.

Transferring GP To A New Server Without Resetting All Passwords

[One of the annoyances when migrating a client’s installation of Microsoft Dynamics GP to a new server is that, unless the new server has the same name as the old one, the password of every user needs to be reset as the server name is encrypted in with the password.

The is another alternative though and that is to create a DNS CNAME Alias and use this as the server name in the SQL Server ODBC instead of the servers actual name. When GP is migrated to a new box you only need to amend the DNS CNAME Alias and users can continue logging in with the same password. Continue reading “Transferring GP To A New Server Without Resetting All Passwords”

VAT 100 Is Missing

Microsoft Dynamics GPI ran into an issue recently when installing Microsoft Dynamics GP 2010 R2 where the VAT Return was not available. I was configuring the system in preparation for training a new client and was running through the Company options (Microsoft Dynamics GP menu » Tools » Routines » Company » Company » Options button) where I was sure the Enable VAT 100 option was but in this case wasn’t;

Company Options - No Enable VAT 100 Option

Continue reading “VAT 100 Is Missing”

Financial Year End Closing – Only Open Year Error Message

Microsoft Dynamics GPI was recently doing some training for a new client and, when showing them how to do period and year end processing encountered an error message when trying to do the Financial Year End Closing (Microsoft Dynamics GP menu » Tools » Routines » Financial » Year End Closing);

Financial Year End Closing - You must set up a new financial year before you can close the only open year.

This had me stumped for a few minutes as there were Open Year calendars (Microsoft Dynamics GP menu » Tools » Setup » Company » Financial Periods) on the system for 2011, 2012 and 2013. Typically in the UK a financial year runs from 1st April to 31st March; but this isn’t a hard and fast rule. This particular client has a different financial year and the error message was being produced as there was a gap of one day between the end of 2011 and the start of 2012. Once the calendar was fixed, the Year End Closing could be run without issue.

Integration Manager Error – MSScriptControl

Microsoft Dynamics GPI’ve spent a fair bit of time recently importing data into Microsoft Dynamics GP using Integration Manager with which I have encounterd a few different error messages (ADO Field Is Nothing, All GP Windows Must Be Closed and Source Document Doesn’t Exist).

The latest error I’ve encountered related to the MSScriptControl;

Integration Manager - MSScriptControl Error

Continue reading “Integration Manager Error – MSScriptControl”

Problem With SOP Word Templates

Microsoft Dynamics GPI’ve recently been working on a Microsoft Dynamics GP 2010 implementation project for a client.

We created custom Word templates (Reports » Template Maintenance) for POP Purchase Order Blank Form, SOP Blank Quote Form, SOP Blank Order Form and SOP Blank Invoice Form without problems and granted access to the relevant companies.

To test the new Word templates we printed the documents to screen so we could quickly see the result. The POP Purchase Order Blank Form worked fine but when it came to the SOP documents we had a problem. When printing any of the SOP documents as Word Templates, instead GP printed the Standard Report Writer reports. Continue reading “Problem With SOP Word Templates”

Word Template Generator, Where Art Thou?

Microsoft Dynamics GPI’m currently doing some work for a client where we’re modifying some of the reports in Microsoft Dynamics GP and I’m trying to avoid using Report Writer as a) I don’t like it, b) Word template reports look better and c) I don’t want to spend time training a client on a module which can be avoiding and is being retired in the near future.

For some of the reports such as the Sales Orders and Invoices and the Purchase Order reports, there are Word templates already available for customising, but for some of the reports such as the Sales Picking Ticket or Dispatch Notes there are no Word templates available by default.

In Microsoft Dynamics GP 2010 this meant starting a template from scratch. In Microsoft Dynamics GP 2010 R2 you can use the Word Template Generator to convert a saved xml report into a Word template.

The only problem is, I can’t find it. None of the blog posts I read announcing the feature said where it would be; just that it would be available with 2010 R2. My first port of call was within GP itself. The I tried the installation media but no luck. I then tried a couple of Internet searches and came up dry. I asked a colleague but they hadn’t used it before.

I finally searched on PartnerSource (I don’t like the PartnerSource search so usually try general Internet searches first) and finally found the download link for the Word template Generator.

Integration Manager Error – ADO Field Is Nothing

Microsoft Dynamics GPDuring a recent implementation I was using Integration Manager to load data into GP and on one occasion I got the following message in the progress window;

Integration Manager Error - ADO Field Is Nothing

Continue reading “Integration Manager Error – ADO Field Is Nothing”