Winthrop Development Consultants Blog

Using Integration Manager with Analytical Accounting

Posted on 8 September 2009 Posted in Developing For Dynamics GP Tagged with Application, Dexterity, Hybrid, Integration Manager, VBA 10 Comments

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

When you use Integration Manager on a system with Analytical Accounting (AA) installed, integrations often fail because Analytical Accounting will open windows which are unhandled by Integration Manager. However, there are time when you still want to use Integration Manager to import transactions where the Analytical Accounting information is left blank. This post provides three methods of how to make Integration Manager work when Analytical Accounting is installed.

Halo Warthog comes to Sydney office

Posted on 27 August 2009 Posted in Developing For Dynamics GP Tagged with Fun 1 Comment

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

This is completely off topic, but worth mentioning. I am spending this week at the Sydney office for meetings and while I was here, we had something very special come to visit us.

A while back, when the Halo 3 game was released, there were a number of short movies created to help promote the game. Of those short movies there were three live action movies filmed as a collaboration with Bungie Studios, Neill Blomkamp, WETA Digital and Origami Digital LLC.

Creating External Shortcuts with Parameters

Posted on 23 August 2009 Posted in Developing For Dynamics GP Tagged with Application 5 Comments

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

I was asked recently if it was possible to create a Shortcut from Microsoft Dynamics GP to launch an external application and pass parameters to the application.

Version 10.0 and its individual windows

Posted on 18 August 2009 Posted in Developing For Dynamics GP Tagged with Application, Dexterity 7 Comments

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

One of the major changes to the Microsoft Dynamics GP user interface occurred with the release of version 10.0. This change was from the MDI (Multiple Document Interface) to the SDI (Single Document Interface).

Why do my Lookup windows look different?

Posted on 13 August 2009 Posted in Developing For Dynamics GP Tagged with Application, Dexterity, Security, Support Debugging Tool 2 Comments

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

This is an oldie but a goodie. It came up again in the newsgroups recently.

The History of Microsoft and more

Posted on 12 August 2009 Posted in Developing For Dynamics GP Tagged with Blogsphere, Fun, General, History No Comments

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

For those of you interested in history of computing and Microsoft’s involvement, take a look at the series of posts on the Channel 9 blog called the History of Microsoft.

What are Errors 5701 and 5703 that show in the DEXSQL.LOG?

Posted on 11 August 2009 Posted in Developing For Dynamics GP Tagged with Application, SQL 5 Comments

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

If you have looked a DEXSQL.LOG file to see the communication between SQL Server and the Microsoft Dynamics GP application, you might have noticed messages with errors 5701 and 5703 being reported. See the example below:

/*
/*  Date: 08/10/2009  Time: 20:09:49
SQLSTATE:(01000) Native Err:(<strong>5701</strong>) stmt(0):*/
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'master'.*/
/*
/*  Date: 08/10/2009  Time: 20:09:49
SQLSTATE:(01000) Native Err:(<strong>5703</strong>) stmt(0):*/
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.*/
/*

An open operation on table ‘[TEMP Table]’ errors

Posted on 9 August 2009 Posted in Developing For Dynamics GP Tagged with Application, Exception 4 Comments

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

Sometimes Microsoft Dynamics GP reports unusual errors with temporary tables. Here are some example error messages that you might see:

An open operation on table ‘IV_Reconcile_PO_TEMP’ has an incorrect record length.

An open operation on table ‘PM_Inquiry_Summary_TEMP’ failed because the path does not exist.

What does Option Explicit do in VBA?

Posted on 6 August 2009 Posted in Developing For Dynamics GP Tagged with Best Practice, VBA 4 Comments

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

My colleague asked me for assistance with a Visual Basic for Applications (VBA) case yesterday.

Support Debugging Tool Portal

Posted on 6 August 2009 Posted in Developing For Dynamics GP Tagged with Pages, Support Debugging Tool 59 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)

Installing the Support Debugging Tool for Microsoft Dynamics GP FAQ

Posted on 4 August 2009 Posted in Developing For Dynamics GP Tagged with Application, Dex.ini, Support, Support Debugging Tool 6 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)

I have been asked a few times recently about installing the Support Debugging Tool for Microsoft Dynamics GP on a live system. This post covers some of the Frequently Asked Questions about installing the tool.

Where are Dynamics GP’s Business Rules Defined and Enforced?

Posted on 2 August 2009 Posted in Developing For Dynamics GP Tagged with Application, Dexterity, eConnect, History, Integration Manager, SQL, VBA 4 Comments

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

In a recent forum post, the question of where the business logic for Dynamics GP resides was raised. This is an excellent question which, sadly, does not have a simple answer.

Modifier – How to Expand the GL Transaction Entry Scrolling Window Example

Posted on 28 July 2009 Posted in Developing For Dynamics GP Tagged with Modifier, VBA 1 Comment

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

One of the customisations that I have heard requests for a number of times is to open the General Ledger Journal Entry (GL Transaction Entry) window’s scrolling window (grid) to its expanded state when the window is opened.

Arabic Version of Microsoft Dynamics GP

Posted on 27 July 2009 Posted in Developing For Dynamics GP Tagged with Blogsphere, Language, Translation 4 Comments

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

One of our community’s MVP, Mohammad Daoud, is giving us a preview of the Arabic version of Microsoft Dynamics GP he has created.

He has used Modifier and Report Writer to update all the messages and strings in the dictionaries, which leaves the original application dictionaries unchanged.

What does the Preprinted Form option on the Report Definition window do?

Posted on 26 July 2009 Posted in Developing For Dynamics GP Tagged with Application, Fonts, Report Writer No Comments

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

When working with the Report Writer to print a report onto a preprinted form it is important to ensure that the report prints to the same position regardless of the printer or printer driver used. This article explains the option that allows a report to always print in the same physical position. This can also be handy for plain paper reports; for example: An invoice that had an address which needs to show through a “windowed” envelope.

Getting Started with Visual Studio Tools for Microsoft Dynamics GP

Posted on 22 July 2009 Posted in Developing For Dynamics GP Tagged with Blogsphere, C#, Developer Toolkit, Development Tools, Dexterity, VB, Visual Studio Tools No Comments

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

The Dynamics GP Blogster, Mariano Gomez, has begun an awesome series of posts about how a Dexterity developer can get started using Visual Studio Tools for Microsoft Dynamics GP.

VBA – Determine if the Caps Lock button is enabled on Password entry

Posted on 22 July 2009 Posted in Developing For Dynamics GP Tagged with Advanced Topic, NDM, Passwords, Patrick Roth, VBA 6 Comments

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

With password policies in place in Dynamics 10.0 RTM, it was easy to be able for your user to ‘lock themselves out’ after a mistyped password or two.

Because Dynamics GP doesn’t give you any kind of warning that the Caps Lock key is enabled, the user wouldn’t necessarily notice this is the real issue and not a typo and all of a sudden you are locked out.

Dexterity Pragma Pre-compiler directives

Posted on 14 July 2009 Posted in Developing For Dynamics GP Tagged with Best Practice, Dexterity No Comments

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

Most Dexterity developers would have seen the pragma(disable warning LiteralStringUsed) command used at some stage to avoid literal string warnings when hard coded strings are needed as part of a script. This can often be the case when building SQL where clauses or pass through SQL, sanScript or macro code.

RW – Getting RW_ConvertToWordsAndNumbers() to show cents in words

Posted on 7 July 2009 Posted in Developing For Dynamics GP Tagged with Dexterity, Report Writer, RW Functions 5 Comments

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

A little while ago I wrote an article about how to get the RW_ConvertToWordsAndNumbers() report writer user defined function to work correctly for both originating and functional currency views. Today, a comment was added to that article asking about how to get the RW_ConvertToWordsAndNumbers() function to return the cents in words rather than numbers.

Usually the function will convert the dollar amount into words but the cent amount is shown as numbers.