Winthrop Development Consultants Blog

Any Font in the Dexterity Script Editor

Posted on 5 July 2009 Posted in Developing For Dynamics GP Tagged with Dex.ini, Dexterity, Fonts, Fun, NDM, Patrick Roth 2 Comments

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

Aren’t secrets fun? And while having a secret is fun in and of itself, it is also fun to share them from time to time (and allowed to share them).

The secret today is an undocumented feature that I believe was added to 10.0 SP2. As an undocumented feature, this means:

It might not work for you
It might cause “issues”
Don’t ask support about it if it causes “issues”
Might not work in the future

That said:

I can’t see why it wouldn’t work
I don’t see what issues it would cause and is completely reversible

Dex – How to Fix the File Association for the .DIC extension

Posted on 30 June 2009 Posted in Developing For Dynamics GP Tagged with Dexterity No Comments

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

In the Dex – Identifying the build number of a Development Dictionary post, we covered using the Windows Explorer to get the dictionary version from the file properties. This only works if the .DIC extension is correctly associated with Dexterity as a Dexterity Dictionary.

Dex – Identifying the build number of a Development Dictionary

Posted on 28 June 2009 Posted in Developing For Dynamics GP Tagged with Dexterity, Service Packs No Comments

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

In a recent post on the new Partner Forum, it was asked how to identify the build number and hence Service Pack/Hotfix number of a Dynamics.dic dictionary being used as a development dictionary for writing a Dexterity customization.

Web Services Configuration Settings for Integrating Large Transactions

Posted on 26 June 2009 Posted in Developing For Dynamics GP Tagged with Chris Roehrich, eConnect, NDM, Web Services 2 Comments

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

It is definitely possible to use Web Services for Microsoft Dynamics GP to create large transactions. By large transactions I am referring to examples of where a sales invoice would have several thousands of lines on it. That’s right, some companies are integrating transactions this large using our Web Services for Dynamics GP!

Microsoft Dynamics GP and Illegal Characters Part 2

Posted on 23 June 2009 Posted in Developing For Dynamics GP Tagged with Application, Dexterity, Exception, Report Writer, SQL 3 Comments

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

In the previous article in this series, Microsoft Dynamics GP and Illegal Characters Part 1, we discussed how string delimiter or terminator characters can cause issues and need to be handled correctly. The article discussed the single quote (‘) and double quote (“) characters. Sometimes we have seen a single quote (‘) character cause problems at the SQL level when it is included in a data field and not handled correctly by the code.

Removing References to Fields in VBA Revisited

Posted on 22 June 2009 Posted in Developing For Dynamics GP Tagged with Blogsphere, Modifier, VBA 1 Comment

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

Michael Johnson (the MBS Guru) has posted a great article about removing invalid references from a Visual Basic for Applications (VBA) project. This has prompted me to revisit the topic and gather together all the relevant resources from a number of blog authors.

Microsoft Dynamics GP and Illegal Characters Part 1

Posted on 21 June 2009 Posted in Developing For Dynamics GP Tagged with Application, Dexterity, Exception, SQL, VBA 4 Comments

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

Over the years that I have worked with Microsoft Dynamics GP, there are been a few occasions where we have had issues with so called “illegal” characters.

Why does VBA’s Shift+F11 not always work?

Posted on 16 June 2009 Posted in Developing For Dynamics GP Tagged with Dexterity, VBA 1 Comment

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

There is an issue with the Shift+F11 keyboard shortcut which is used by Visual Basic for Applications (VBA) to Add Fields to Visual Basic. I was asked about it again recently and so decided to post the details on the blog.

How to modify the Safepay Transactions upload window to allow macros to run

Posted on 12 June 2009 Posted in Developing For Dynamics GP Tagged with Dave Dusek, Dexterity, Macro, NDM 4 Comments

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

The following is a situation that I have come across a couple of different times. What people want to do is set up a macro to run at night to generate their Safepay EFT file. They want to just set it up to run every night whether there are transactions to process or not.

Using the Support Debugging Tool to assist with Report issues

Posted on 9 June 2009 Posted in Developing For Dynamics GP Tagged with Dexterity, Report Writer, RW Functions, Support Debugging Tool, Tools No Comments

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

A new feature to the Support Debugging Tool for Microsoft Dynamics GP build 11 is the support for the rw_ReportStart, rw_ReportEnd, rw_TableHeaderString, rw_TableHeaderCurrency, rw_TableLineString, and rw_TableLineCurrency report writer user defined functions.

Using the Support Debugging Tool to create temporary fixes

Posted on 7 June 2009 Posted in Developing For Dynamics GP Tagged with Application, Dexterity, Named Printers, Support Debugging Tool, Tools 4 Comments

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

The Support Debugging Tool for Microsoft Dynamics GP has the facility to create non-logging triggers. This are Automatic Debugger Mode triggers that do not automatically start and stop the Dexterity and SQL logging.

Support Debugging Tool Build 11 released

Posted on 4 June 2009 Posted in Developing For Dynamics GP 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.

Understanding Notes and the Note Index field

Posted on 2 June 2009 Posted in Developing For Dynamics GP 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.

Understanding how Microsoft Dynamics GP works with Microsoft SQL Server continued

Posted on 28 May 2009 Posted in Developing For Dynamics GP 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 ….

Controlling the size of the Body section on Reports

Posted on 26 May 2009 Posted in Developing For Dynamics GP 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.

RW – Showing the Full Item Description on Invoices Example

Posted on 24 May 2009 Posted in Developing For Dynamics GP 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.

Understanding how Microsoft Dynamics GP works with Microsoft SQL Server

Posted on 21 May 2009 Posted in Developing For Dynamics GP 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.

Development White Papers for Download

Posted on 19 May 2009 Posted in Developing For Dynamics GP 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:

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

Posted on 17 May 2009 Posted in Developing For Dynamics GP 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.

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

Posted on 15 May 2009 Posted in Developing For Dynamics GP 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.