Patrick Roth - Click for blog homepageThis is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.

In a recent case of mine, the ISV was running into a common issue that I’ve run into before more than a few times.  Actually something I’ve done a few times myself.

The ISV was attempting to use pass through sanScript to populate a SQL temp table.

Read more →

Marian Verzosa - Click for blog homepageThis is a reposting of an article Marian Verzosa originally wrote on my Developing for Dynamics GP blog.

Hi Everyone,

I recently worked on a case where the IV10201 table is not recording any transaction that sells the quantity.

The IV10201 table is the Inventory Goods Received Detail (IV_Purchase_Receipts_DTL) table.

Read more →

Chris Roehrich - Click for blog homepageThis is a reposting of an article Chris Roehrich originally wrote on my Developing for Dynamics GP blog.

In this post I will talk about the changes made to the API for eConnect for Microsoft Dynamics GP 2010 and how developers can take advantage of these changes to affect their custom application.   If you have been using eConnect 2010 you have already realized that there is a new Windows service running called the eConnect for Microsoft Dynamics GP 2010 Integration Service.   This is a change from the version 9 and 10 days where there was a COM+ application for eConnect that appeared under Component Services.  Like the eConnect COM+ application, the eConnect 2010 service runs under a Windows user that requires DYNGRP role access in the DYNAMICS and company databases.  I will breakdown some of the other changes in the following sections.

Read more →

Dave Dusek - Click for blog homepageThis is a reposting of an article Dave Dusek originally wrote on my Developing for Dynamics GP blog.

If you are working with a specific report in report writer, and you are also using a word template to print the report, one thing that you have to keep in mind is that the report writer fields have to be in synch with the content controls on the word template.  If they are not in synch what happens is that nothing will print in the content control on the word template, not even XX’s.  So you need to go through a process to get the report writer report synched up with the word template.  Here is that process.

Read more →

Allan Cahill - Click for blog homepageThis is a reposting of an article Allan Cahill originally wrote on my Developing for Dynamics GP blog.

I recently worked on a PDFWriter printing incident with a Customer and we ran into a format problem when choosing the PDF File format.

The Problem

Since performing an upgrade to Microsoft Dynamics GP 2010, the Customer was having an issue when printing a single page invoice, in this instance, the SOP Blank Invoice Form.  When choosing the PDF file format as the report destination, the invoice was splitting over 2 pages for a single page invoice i.e. the standard report prints with the vertical lines extended past the border in the footer or with the Customer’s modified report, the page is moved up and report was splitting to multiple pages.

Read more →