Winthrop Development Consultants Blog

Support Debugging Tool Build 11 released

Jun 4, 2009 Tagged with Dexterity, Security, Support, Support Debugging Tool, Tools 15 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

IMPORTANT NOTICE: The Support Debugging Tool is now GP Power Tools from Winthrop Development Consultants (https://winthropdc.com/GPPT)

Over the last few months I have been working hard on the next build of the Support Debugging Tool for Microsoft Dynamics GP. After just over 130 hours of development, testing and documenting it is finally ready for release. I have made over 30 significant changes to the tool which will make the existing features more robust as well as adding functionality and some completely new features.

Developing For Dynamics GP

Understanding Notes and the Note Index field

Jun 2, 2009 Tagged with Application, Dexterity, Exception, Notes & OLE Attachments, SQL 26 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I was asked recently about the Note Index field and how it is used and in particular about the Note Index field in SY01500 table in the DYNAMICS system database. This post will explain how the field is used as well as explain how it is possible to create the conditions that will generate cross linked notes. Understanding how the conditions can be created will allow you to avoid that situation from occurring.

Developing For Dynamics GP

Understanding how Microsoft Dynamics GP works with Microsoft SQL Server continued

May 28, 2009 Tagged with Application, Dexterity, History, SQL 6 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

As a followup to last week’s post about Understanding how Microsoft Dynamics GP works with Microsoft SQL Server, I am adding a few more topics about why Microsoft Dynamics GP works the way it does with Microsoft SQL Server. So here goes ….

Developing For Dynamics GP

Controlling the size of the Body section on Reports

May 26, 2009 Tagged with Application, Report Writer 3 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

The question of how to control the size of the body section of a document such as Sales Order Processing (SOP) Orders and Invoices or Purchase Order Processing (POP) Purchase Orders has come up a number of times before. It was asked again on a Community Forum post a while back. So I thought I would post the answer here.

Developing For Dynamics GP

RW – Showing the Full Item Description on Invoices Example

May 24, 2009 Tagged with ADO, Report Writer, RW Functions, VBA 9 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

When the inventory module of Microsoft Dynamics GP was first written the Item Description field was 60 characters long. A few versions ago it was extended to 100 characters.

Developing For Dynamics GP

Understanding how Microsoft Dynamics GP works with Microsoft SQL Server

May 21, 2009 Tagged with Application, Dexterity, History, SmartList Builder, SQL 13 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Many people who have not been working with Microsoft Dynamics GP since the early non-SQL versions of Great Plains Dynamics sometimes wonder about the way that the application works with Microsoft SQL Server.

Developing For Dynamics GP

Development White Papers for Download

May 19, 2009 Tagged with C#, Dexterity, eConnect, VB, Visual Studio Tools 4 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I recently came across some development tool based White Papers which are available for download from Microsoft Downloads. I thought I would highlight them as they are worth a read:

Developing For Dynamics GP

RW – Making a One-to-Many Table Relationship behave as One-to-One

May 17, 2009 Tagged with Report Writer 3 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

One of biggest issues people have with the Microsoft Dynamics GP Report Writer is not being able to create the desired table relationships from tables on the report to other tables so that the other tables can be added to the report and behave correctly.

Developing For Dynamics GP

How to access a Third Party Table Buffer on a Cross Dictionary Procedure Trigger

May 15, 2009 Tagged with Best Practice, Dave Dusek, Dexterity, NDM 1 Comment

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

This particular situation has come up in a number of support incidents and I also run into this myself on occasion. The situation is that you have a cross dictionary procedure or function trigger on a script and one of the parameters is a third party table buffer.

Developing For Dynamics GP

RW – Can I print Page Numbers including the Total Number of Pages?

May 12, 2009 Tagged with ADO, Report Writer, VBA 5 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

The question in more detail is whether it is possible to print “Page: Y/X” or “Page: Y of X” on a Report Writer report, where Y is the current page number and X is the total number of pages for the report.