NDM – Page 6 – Winthrop Development Consultants Blog

Creating a Custom Serialization Assembly for eConnect for Microsoft Dynamics GP 2010

Dec 2, 2010 Tagged with C#, Chris Roehrich, eConnect, NDM, XML 7 Comments

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

The eConnect Programmer’s guide discusses creating a custom XML node and stored procedure so developers can process new types of data. For example, a custom or 3rd party table could be updated when integrating a master record like a Customer or a transaction like a Sales Invoice using eConnect. The strategy that I will discuss below is for developers out there that would like to go one step further by referencing their own custom assembly. This assembly can be referenced in their Visual Studio project which would allow them to serialize the eConnect XML document with the custom node.

Developing For Dynamics GP

Determining Role Access To Extender Objects

Nov 19, 2010 Tagged with Application, Extender, NDM, Patrick Roth, Security, SQL 1 Comment

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

An Extender case came up recently where the customer was having security issues with Extender forms.

Developing For Dynamics GP

File not found: VBA6.dll error occurs or GP crashes

Nov 15, 2010 Tagged with Application, Beth Gardner, Exception, GP 2010, NDM, VBA 10 Comments

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

This is a follow up to my previous post on the VBA6.dll not found error (for 64-bit). I have found this can occur on 32-bit computers and Microsoft Dynamics GP 10.0 and GP 2010.

[Edit] Re-installing the VBA 6.4 core components (as used by Dynamics GP) has been shown to resolve this issue for VBA6.DLL, VBE.DLL, VBA7.DLL and VBE7.DLL errors. Please download the necessary files from this link:

https://mbs2.microsoft.com/fileexchange/downloadfile.aspx?fileid=2208ac6f-d575-4f34-8b19-40340fe3d20c

Developing For Dynamics GP

Dexterity: Cannot See Table Buffer Values in 10.0 SP5 or 2010 SP1

Nov 5, 2010 Tagged with Dexterity, NDM, Patrick Roth, Service Packs 1 Comment

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

A long standing pain point for ISV’s has been the inability to see 3^rd party table buffers while debugging ISV code in runtime.

Most development – I assume – is in test mode where your customization and Dynamics are on a level playing field and the ISV can see anything they like easily.

Developing For Dynamics GP

Retrieve more than 1000 Records using Web Services for Microsoft Dynamics GP 2010

Oct 29, 2010 Tagged with C#, Chris Roehrich, eConnect, NDM, Web Services 1 Comment

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

A question we have received in the past in Developer Support is how to retrieve more than 1000 records using Web Services. The maximum number of records a GetList method will return is 1000 records. This is by design as this value is coded into the call to eConnect and it cannot be changed with a configuration file.

Developing For Dynamics GP

Writing to An Event Log in a Visual Studio Tools Customization

Oct 14, 2010 Tagged with Advanced Topic, Development Tools, NDM, Patrick Roth, Visual Studio Tools, Windows 7 No Comments

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

So you are writing your top notch, one-of-a-kind Visual Studio Tools for Microsoft Dynamics GP customization.

You’ve covered all the bases for any potential errors and just in case you miss any and an exception is thrown, you are catching the exception to write into an event log.

Developing For Dynamics GP

Finding Command Forms and Commands to use with Menus for Visual Studio Tools or Dexterity

Oct 1, 2010 Tagged with C#, Developer Toolkit, Dexterity, Menus for Visual Studio Tools, NDM, Patrick Roth, PSTL, Visual Studio Tools 10 Comments

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

One of the issues ISV’s have when integrating with the Dynamics GP menu system is to determine the name of a command list and command form to use.

Developing For Dynamics GP

SQL Server Express Failing To Start Revisited

Sep 26, 2010 Tagged with Development Tools, NDM, Patrick Roth, SQL 6 Comments

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

David Musgrave posted an interesting article a few days ago where compressed SQL Server database files caused the SQL Server service not to start.

Developing For Dynamics GP

Stored Procedure Executing In Wrong Database

Sep 17, 2010 Tagged with Application, Customizations, 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.

We ran into an odd issue recently that I’d like to share today.

An ISV reported that in their customer was getting an error when the ISV application attempted to execute a stored procedure.

[SQL Server] Could not find stored procedure DYNAMICS.dbo.SomeStoredProcedure

Easy you say – the proc doesn’t exist. Just create it and you’ll be fine.

Developing For Dynamics GP

Using SQL DB Update Trigger With Text Fields

Sep 3, 2010 Tagged with NDM, Patrick Roth, SQL, Triggers 1 Comment

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

An ISV had a goal of creating an audit table of the Dynamics record notes table – SY03900 – but was running into an issue.

He mentioned that he was using an “instead of update” SQL trigger and not just a normal “update” trigger. The specific issue was that while his audit table was being updated, the SY03900 table was not.

After discussing the goals of his application and the issue, I set out to discover why exactly the normal update trigger wouldn’t work, why the SY03900 table wasn’t being updated, and lastly what we could do about it.

Tag: NDM