Tag: great plains
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
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
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.
If you have not read the first post in this series, please read it now: End of an Era: Farewell Dave Gaboury & the Creation of Dexterity – Part 1 Here is the continuing story of the creation of Dexterity and Dynamics from Dave Gaboury. Although our progress was slow, our work on graphical development platforms kept us in close partnership with both Microsoft and Apple. I think it was in 1990 that we started talking to Microsoft about the possibility of jointly producing a low-end accounting system. The work we were doing on EB was a big factor in attracting Microsoft to the project, and our initial proposal was that we would build this new accounting system with EB.
Back in 1998 when I was experimenting with Cross Dictionary Dexterity Development in version 4.00 and version 5.00, I was contacted by Dave Gaboury from Great Plains in Fargo.
Server Error in Application in Project Time and Expense in Business Portal for Microsoft Dynamics GP
You may receive the following error in the Project Accounting Timesheet or other pages in Business Portal for Microsoft Dynamics GP. Server Error in ‘/’ Application Runtime Error -or- An unexpected error has occurred.