Tag: great plains

Management Reporter 2012 on PartnerSource

| 03/12/2012 | 0 Comments

New Management Reporter information now available including Fact Sheets, Presentations, Videos and Demos.  Check it out. Pam https://mbs.microsoft.com/partnersource/solutions/mgmtreporter/default

Continue Reading

SQL view for sales quantities by customer by item by year

| 03/09/2012 | 0 Comments

Seems like no many how many variations of sales reports there are, people will always want more.

Continue Reading

Are you ready for new features and functionality in Microsoft Dynamics GP? It is time to start planning your upgrade!

| 03/08/2012 | 0 Comments

Year end is now over and it is time to start thinking about planning the upgrade for Microsoft Dynamics GP!  New features and functionality are waiting for you in the current release of Microsoft Dynamics GP 2010 and more exciting capabilities are right around the corner with a brand new release available at the end of this year!  Start your planning meetings now to get a jump on your project plan for the upgrade of Microsoft Dynamics GP and all your integrating applications that you use today! Take advantage of the upgrade resources and information below to learn everything you need to know about the current release of Microsoft Dynamics GP and the steps involved in the upgrade process that you can apply to any release of Microsoft Dynamics GP! Important Note: Several links on this page go to CustomerSource. Learn more about CustomerSource and how to signin .

Continue Reading

Number of results columns doesn’t match table definition errors in Personal Data Keeper

| 03/06/2012 | 1 Comment

Hi everyone, If you are using Personal Data Keeper (PDK) you have probably seen a Get/Change message whose More Info button displays the error “ Number of results columns doesnt match table definition .”  There are a number of errors that can cause that More Info message such as: A get/change operation on table ‘UPR_MSTR_Tax_Info failed accessing SQL data A get/change operation on ‘GL_Account_MSTR’ failed accessing SQL Data A get/change operation on table ‘UPR_MSTR’ failed accessing SQL data A get/change first operation on table ‘MC_Currency_SETP’ failed accessing SQL data A get/change first operation on table ‘PDK_Employee_Expense_HDR’ failed accessing SQL data A get/change operation on table ‘P_CPY_SETP_Income’ failed accessing SQL data A get/change first operation on table ‘P_CPY_MSTR’ failed accessing SQL data But what they all mean is that the version of Microsoft Dynamics GP and the version of PDK being used are not compatible.   What is compatible? Here is a cheat sheet I created for my team that I wanted to share so you can use it to verify that the versions you are using play nicely together

Continue Reading

Moving SQL Server Reporting Services from Native Mode to SharePoint Integrated Mode

| 03/01/2012 | 4 Comments

Historically, many of our customers started out deploying their Microsoft Dynamics GP reports to SQL Server Reporting Services (SSRS) in Native mode, meaning that they used a Report Manager site to access their reports.  With the high adoption rate of Microsoft SharePoint Server, many of our customers would like to know how to switch their SSRS instance to SharePoint-integrated mode. This process is broken up into main steps: A) Install SharePoint 2010 B) Backup any custom or modified SSRS reports C) Configure SQL Server Reporting Services to use SharePoint Integrated Mode D) Setup the integration between SharePoint 2010 and SSRS E) Create a SharePoint Document Library to house your reports F) Redeploy the Dynamics GP SSRS reports to your new site You can review the following steps to perform the switch to SharePoint Integrated Mode: 1) First, you will need to be sure that you have installed SharePoint.  For this blog I’m going to be referencing SharePoint Server 2010 and SharePoint Foundation 2010.  We will also be using SQL Server Reporting Services 2008 R2.  a. NOTE: in order for SSRS SharePoint Integrated Mode to work correctly you must have SharePoint installed on the same server as SSRS

Continue Reading

GP2010 Upgrade Error

| 02/29/2012 | 0 Comments

The GP2010 upgrade from Dynamics GP 10 (SP4 > > 10.0.1368 Build) failed during tables update in a recent upgrade process.

Continue Reading

Emailing SOP invoices in GP 2010 made easy with GP Reports Viewer

| 02/29/2012 | 0 Comments

  Background / The Problem For many companies a long awaited new feature introduced with Dynamics GP 2010 was the ability to email SOP (Sales Order Processing) invoices directly from GP. Many of our customers have started to offer emailing of invoices to their customers and are seeing an increased number of requests for emailed invoices. However, something that we have heard many users complain about with GP’s new emailing options is how cumbersome it is to deal with both emailing and printing invoices. It’s easy if invoices are all printed or all emailed, but anything in-between requires a lot of manual sorting through records in GP or sorting through printed invoices to determine what needs to get mailed out.

Continue Reading