Tag Archives: Microsoft Dynamics GP 2010 R2

EFT File Format Import/Export Error

I’ve recently been creating an HSBC Standard 18 BACs file format for a client in Microsoft Dynamics GP 2010 R2.

Unfortunately, once I released it to their system, they reported an error with the import where the Creditor’s Cheque Name wasn’t being output on the resulting file.

I did some testing and it turns out to be a bug in the export function of the EFT File Format (Cards >> Financial >> EFT File Format) window in Microsoft Dynamics GP 2010 R2; I have subsequently tested on GP 2010 SP3 and GP 2013 and the import/export works fine. I realised something odd was going on when I looked at the template in the EFT File Format window (Cards >> Financial >> EFT File Format) and saw that while the Series was defined as Purchasing in the header, the scrolling window for the Data Field only had Receivables Management tables and fields available to it and not the Payables Management tables and fields I would expect;

EFT File Format

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , | 2 Comments

How To Realign Trial Balance Summary Modified Report Columns

I was recently asked to assist the Support team to look into an issue with the Trail Balance Summary modified report. The problem was that when sent to screen or printer the report was fine, but when exported to Tab Delimited file, the columns didn;t match up with the totals at the bottom.

Trial Balance Summary on Screen shows as aligned;

Trial Balance Summary - Screen Output

Continue reading

Posted in Dynamics, GP, Microsoft, Report Writer | Tagged , , , , , , , , , , | 3 Comments

How To Deploy Excel Reports In Microsoft Dynamics GP 2010 R2

Way back in February I did a post on how to deploy the SSRS reports to Microsoft Dynamics GP 2010 R2 and meant to follow up with a post on how to deploy the Excel Reports, but got sidetracked and then forgot. Well, I’m correcting that today.

To deploy the reports you need to open the Reporting Tools Setup window (Tools >> Setup >> System >> Reporting Tools Setup) where you can deploy reports and see what has already been deployed;

Reporting Tools Setup - Excel tab

Continue reading

Posted in Dynamics, Excel Reports, GP, Microsoft | Tagged , , , , , , , | 1 Comment

Unknown Error Creating Demo Company

This is another mea culpa post; I’ve been doing enough of them I’m thinking of giving them their own tag.

I was created a virtual machine with the Fabrikam, Inc. demo company in it. When GP Utilities was processing I got this error pop up;

Microsoft Dynamics GP Utilities - An unknown error occurred when initialising tyhe conversion.

Continue reading

Posted in Dynamics, GP, GP Utilities, Microsoft | Tagged , , , , , , , | Leave a comment

How To Install A Domain Controller In Windows 8 Server Consumer Preview

At the start of this year I did a post on how to install a domain controller in Windows Server 2008 R2 (and I think the method would work back to 2003 as well). However, with the release, albeit of the Consumer Preview, of Windows 8 Server (Windows Server 2013 on release?) that post is out of date.

I say it is out of date because when I tried to run it I got the following message;

Active Directory Domain Services Installer - The Active Directory Domain Services Installation Wizard is relocated in Service Manager. For more information, see http://go.microsoft.com/fwlink/?LinkId=220921

So for those of you who, like myself, are preparing a test environment using Windows 8 Server Consumer Preview, SQL Server 2012, Management Reporter 2012 for Microsoft Dynamics GP 2013 (when it arrives) here is a walk through of creating a domain controller on Windows 8 Server Consumer Preview. Please note this is not a guide that should be used on a production environment; it is solely intended for creating a demo or test environment; I am a Microsoft Dynamics GP specialist, not a Windows Active Directory one.

Continue reading

Posted in Dynamics, GP, Management Reporter, Microsoft, Windows, Windows 8 | Tagged , , , , , , , , | 2 Comments

How To Install Management Reporter 2012 – Client Installation

Last week I posted the start of a series of posts on how to install Management Reporter 2012; how to install Management Reporter 2012 – Server Prerequisites, how to install Management Reporter 2012 – Server Installation and how to configure Management Reporter 2012.

Todays post is the final post in the series on how to install Management Reporter and covers the client installation.

The client installer is part of the same installation package as the server installation (download available here (PartnerSource or CustomerSource login required).

Continue reading

Posted in Dynamics, Management Reporter, Microsoft | Tagged , , , , , , , , | 2 Comments

How To Configure Management Reporter 2012

On Monday the new version of Management Reporter was released, on Tuesday I posted the first in a series of posts on how to install Management Reporter 2012 server prerequisites and yesterday I posted the second part of the series on how to install the server software. Today I’ll cover the configuration of Management Reporter 2012.

To quickly recap, the server configuration I am using is four separate servers, all running Windows Server 2008 R2, but could easily be installed on one machine, or virtual machine, for use as a test system;
Domain Controller (DC1) running the ideal domain (a slight departure from my usual azurecurve) on
SQL Server (SQL1)
Reporting Server (RPT1)
Terminal Server (TS1)

The configuration is done using the Configuration Console which is installed as part of the server installation, so in my case it is on the Reporting Server (RPT1).

Continue reading

Posted in Dynamics, Management Reporter, Microsoft | Tagged , , , , , , , , | 6 Comments

How To Install Management Reporter 2012 – Server Installation

Yesterday, I posted the first in a series of posts on how to install Management Reporter 2012; how to install Management Reporter 2012 – Server Prerequisites. Today I’ll cover the server side of the installation.

The first step is to download the installation package; Microsoft Dynamics Management Reporter 2012 (PartnerSource or CustomerSource login required).

One thing to note about the installation of Management Reporter 2012 is that it has been much simplified over that of Management Reporter 2; some parts have been removed (no separate provider to install) and some has been moved to the new Configuration Console.

Continue reading

Posted in Dynamics, Management Reporter, Microsoft | Tagged , , , , , , , , | 1 Comment

How To Install Management Reporter 2012 – Server Prerequisites

With the release of Management Reporter 2012 I thought it might be worth doing a series of posts on how to install this version.

The server configuration I am using is four separate servers, all running Windows Server 2008 R2, but could easily be installed on one machine, or virtual machine, for use as a test system;

  • Domain Controller (DC1) running the DOMAIN.MSDynamicsERP.co.uk
  • SQL Server (SQL1)
  • Reporting Server (RPT1)
  • Terminal Server (TS1)

All of the installation of Management Reporter server, and the server prerequisites, will be done logged into the Reporting Server (RPT1); the client and initial configuration will be done on the Terminal Server (TS1).

The prerequisites for MR 2012 are very similar to those of Management Reporter 2 which were covered hereThe prerequisites of Management Reporter 2012 differ from Management Reporter 2 in that only the .NET Framework 4 is common between the two versions. The addition that MR 2012 requires is the Microsoft Access Database Engine 2010 Redistributable to be installed.

Continue reading

Posted in Dynamics, Management Reporter, Microsoft | Tagged , , , , , , , , | 14 Comments

Hiding The Fabrikam Demo Company Date Warning

When doing sales demos or testing I tend to use the Microsoft supplied demo database to save time on rolling my own.

One annoyance in it is the warning message that is displayed when logging into Fabrikam;

Microsoft Dynamics GP - You have chosen to use the sample company, which provides data that you can use to practice procedures or learn nore about the product. When you use this sample company, the date is automatically set to April 12, 2017.

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , | 3 Comments