Patrick Roth – Page 5 – Winthrop Development Consultants Blog

POP Distributions randomly being deleted

Apr 8, 2010 Tagged with Application, Dexterity, NDM, Patrick Roth, SmartList Builder, Support Debugging Tool No Comments

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

So many interesting cases, so little time to talk about them.

My interesting case this week is the mystery of the deleted POP Distributions.

The ISV had a customer where all of the distribution records in the POP10390 were being randomly deleted. They had been trying to track this down for weeks and with the help of the Support Debugging Tool was able to capture a script.log of this happening.

Developing For Dynamics GP

Cannot activate workflow in Dynamics GP

Apr 1, 2010 Tagged with Developer Toolkit, NDM, Patrick Roth, Web Services, Workflow 4 Comments

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

Recently one of the support engineers had a case they asked for my help on.

Dynamics Workflow was installed and a new PO Workflow was created and activated in Sharepoint. From the Sharepoint side, everything seemed to be working correctly.

Developing For Dynamics GP

The Smartlist Builder GoTo won’t open my window

Mar 26, 2010 Tagged with Dexterity, NDM, Patrick Roth, SmartList Builder, XML No Comments

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

In a Microsoft Forums post a few days ago, an ISV had created a custom window and a table to store parallel data to the Item Serial Number Master table.

Her goal was to use Smartlist Builder (SLB) to make a Smartlist to show the GP & custom data in one Smartlist. That part was successful.

The 2^nd goal was to make a GoTo to drill back to the custom window to display the Item & Serial Number (her parallel key) and display the custom data that goes with it.

Developing For Dynamics GP

Debugging ISV Application Crashing Dynamics

Feb 19, 2010 Tagged with Advanced Topic, Dexterity, Encryption, Exception, NDM, Patrick Roth 3 Comments

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

I recently had a case that I thought I’d share with you. A well known ISV opened an incident with Developer Support to help solve an issue at their customer site.

This ISV has an application that encrypts certain sensitive data in the custom application in the ISV’s custom table in their own Dexterity based window.

The complaint given: After opening the custom window and making the application perform the decrypted data, when the window closes and the Dynamics navigation shell has focus – Dynamics GP crashes with the “Dynamics Runtime has encountered an error and needs to close..” dialog.

Developing For Dynamics GP

What’s New in Visual Studio Tools 2010

Feb 12, 2010 Tagged with Developer Toolkit, GP 2010, NDM, Patrick Roth, Visual Studio Tools 9 Comments

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

Today, I want to share with you what I think are the 3 coolest new features in Visual Studio Tools for Microsoft Dynamics GP 2010 (VSTools).

Developing For Dynamics GP

VBA – Determining the company name selected in the Company Login window

Jan 22, 2010 Tagged with ADO, NDM, Patrick Roth, VBA 3 Comments

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

A question came up a while back where the user wanted to know what company the user was logging into in order to give them a message depending on the company selected.

Developing For Dynamics GP

Determine SOP Type in SOP Entry using VBA or Visual Studio Tools

Dec 11, 2009 Tagged with NDM, Patrick Roth, VBA, Visual Studio Tools 4 Comments

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

I think the most customized window in VBA must be the SOP Entry window.

If the customization is not saving custom data for the header/line items, then it is adding custom logic based on document type and any number of other factors.

In all of this – especially saving custom data to a parallel table – the SOP Number is important as it identifies the document. And, of course, to be unique your primary key would also include the SOP Type field – just like the SOP10100 table does in Dynamics.

Getting the SOP Number is easy – it is the string value from the window.

Developing For Dynamics GP

Running dag.exe on 9.0 Dynamics forms dictionary fails with runtime error at 86% complete

Nov 26, 2009 Tagged with Developer Toolkit, Development Tools, Exception, NDM, Patrick Roth, Visual Studio Tools No Comments

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

A few months ago, a partner was attempting to create an Application.Dynamics.ModifiedForms.dll using the Dictionary Application Generator (dag.exe) against his 9.0 SP4 Dynamics forms dictionary.

This failed for him. Trying to determine if it was a “forms dictionary issue” or not, he renamed his Application.Dynamics.dll as a test and attempted to generate a new one using Dag.exe. This also failed in the same manner but at a different spot.

Developing For Dynamics GP

Duplicate key error on a range copy statement

Nov 13, 2009 Tagged with Dexterity, NDM, Patrick Roth, SQL No Comments

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

An ISV ran across an interesting problem a few days ago in his Dexterity/Dynamics 9.0 solution.

The goal of a particular procedure was to copy records from one table into a nearly identical duplicate temporary table. The duplicate table contained all of the original table fields plus a few new ones. The temp table was created by using the Duplicate feature in Dexterity so the keys of the new table were identical to the original table.

Developing For Dynamics GP

Hybrid – Setting a push button to Hyperspace

Oct 30, 2009 Tagged with Dexterity, Hybrid, Modifier, NDM, Patrick Roth, VBA No Comments

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

Trivia question for today:

Given the following sequence of events:

In Microsoft Dynamics GP, in a control field such as Customer Number, the user types in “AARON”. The user then presses the associated lookup button.

Tag: Patrick Roth