Apologies for the lack of updates recently, but I’ve been out of the office over the last couple of weeks for my birthday (I never work it), on client site and then back down to Cheshire for a week to pack the contents of the house I am selling as part of moving to the NE for work.
I’m now back and over this week will post a few SQL scripts I’ve written over the last year or so which you may find useful.
Earlier this week I did a post on how to configure SQL Server Reporting Services for use with Microsoft Dynamics GP. This is the follow up post where I’m going to explain how to deploy the SSRS reports for GP.
To deploy the reports you need to open the Reporting Tools Setup window () Continue reading “How To Deploy SSRS Reports In Microsoft Dynamics GP 2010 R2”
The post following this will cover deploying SSRS reports within Microsoft Dynamics GP but I thought I’d cover configuring SSRS as a spearate post rather than assuming everyone has it already configured. A number of the clients I deal with have had GP for a while and never installed the SSRS reports but are now doing so.
When you install SQL Server Reporting Services at the same time as SQL Server you have the option to automatically configure SSRS with the default settings. In the case of someone who has SQL already installed but didn’t install SSRS at the same time, this is not an option.
This How To starts after SSRS has been added to the installation on the client machine at the point where you would start to configure it; if you’d like a walk through adding SSRS to an existing installation of SQL Server, let me know and I’ll sort one out.
To do the initial configuration of SSRS, or to change the configuration of an existing installation, you need to start the Reporting Services Configuration Manager () Continue reading “How To Configure SQL Server Reporting Services In Order To Deploy Reporting Services Reports In GP”
I periodically have problems when trying to restore a GP company database over the Test database as SQL reports that the database is currently in use.
One way of resolving is to restart the SQL Server but this is only possible on a stand alone test system which is not being used by other people but this approach is overkill.
The better solution is to change the database to single user, restore the database and change the database back to multiple user. This can be done manually through SQL Server Management Studio but is far easier done via a SQL script.
Continue reading “Restoring A Database Without Encountering A Locking Issue”
Normal service for blog posts will soon be resumed.
I was out of the office last week learning about Microsoft Dynamics CRM and have passed the MB2-867 Microsoft Dynamics CRM 2011 Installation & Deployment certification; a nice addition to the three Microsoft Dynamics GP certs I already have.
Any items of interest I encounter about Dynamics CRM which relate to GP, such as the CRM-GP Connector, will be shared here.
If you’re installing Microsoft Dynamics GP into a thin client environment then installing the clients isn’t that onerous a task, but if you’re installing GP into a thick client (or into a large thin client) environment then it can be a task that takes quite a while especially when the client has numerous features which need to be selected on each client.
Microsoft Dynamics GP includes an aid for this circumstance; the ability to create an installation package which allows you to easily and quickly install GP onto clients with exactly the same configuration each time.
The installation package is created from the Microsoft Dynamics GP setup;
Continue reading “How To Create A Microsoft Dynamics GP Installation Package”
Well, I return to fixing the Management Reporter sample reports with an, unexpected, part 2. Last week I installed the sample reports into Management Reporter and then found a problem with the sample reports where the Segment didn’t link correctly to the segments in Microsoft Dynamics GP.
The same issue exists with the Reporting Trees in the sample reports with the Dimensions column;
Continue reading “Fixing The Management Reporter Sample Reports Part 2”
One of the features introduced in Microsoft Dynamics GP 2010 was the Word templates which could be used instead of the Report Writer reports (known in 2010 onwards as Standard reports). There were several Word templates shipped out of the box with GP that could be amended quite easily but if you needed to use one of the others then a lot of work was needed to manually create the template from scratch.
In Microsoft Dynamics GP 2010 R2, the Word Template Generator, available as a separate download from PartnerSource (login required) was introduced which would generate the base Word template which can then be amended as required. Continue reading “How To Use The Microsoft Dynamics GP Word Template Generator”
On the Microsoft Dynamics GP Community site a question from Lisa Sorenson in October last year asking if it was possible to use the Table Import () feature in Microsoft Dynamics GP to update some Segment descriptions has risen to the top with Steve Cummings linking to a post where the suggestion is to use a CSV file and Word template to generate a mailmerge.
This solution will work, but can be accomplished in much less time and effort by using the SQL command BULK INSERT to load the CSV (formatted as Segment ID, Segment Number and Description) Continue reading “How To Bulk Update Segment Descriptions From A CSV”
I installed the sample reports into Management Reporter yesterday when writing the blog post but I didn’t actually take a proper look at them until this morning when I realised that there is a problem with them; there is a mismatch between the default settings of the sample reports and Microsoft Dynamics GP 2010 R2 whereby the Link to Financial Dimensions is broken;
Continue reading “Fixing The Management Reporter Sample Reports”