Debugging in the Dynamics GP 2015 Service Based Architecture

As we move into the world of Service Based Architecture with Dynamics GP 2015, we wanted to highlight some debugging tools that will aid you as you create service procedures of your own.  Today you have various things available to you to debug integrations as they are created.  Among them are internal tools like the…


Opening Up a World of Possibilities with Microsoft Dynamics GP 2015 and Services

On 13th August in Fargo the Microsoft Dynamics GP development team delivered a hands-on workshop to our Collaborative Development partners around the new Service Based Architecture (SBA) that will be available in Microsoft Dynamics GP 2015.  Throughout the day the team went over various pieces such as .NET Interop, changes to the current toolsets and implementation…


Microsoft announces Developer Preview for Dynamics GP 2015

Microsoft is pleased to announce the availability of the developer preview for Microsoft Dynamics GP 2015.  This partner only preview is available to any registered Microsoft Dynamics GP partner and can be downloaded from PartnerSource.  The preview itself is comprised of four parts that once downloaded can be extracted into a single virtual machine instance…

13

Quick Tip: Dexterity Ranges and how to update Fields that are part of the Key

Last week, I had an interesting case where a Dexterity Developer was having trouble getting some code to update a range of records selected in a table. The code would only update the first record in the range.   The Scenario The developer was trying to move the contents of the SOP_Serial_Lot_WORK_HIST table for a line…


Dynamics GP Developer Insights: .NET Interop

Hello, my name is Alice Newsam and I am software engineer on the Dynamics GP team focusing on Dexterity and I have a question for you:  Have you ever thought to yourself while working in Dexterity “I know there’s a .NET class that does this. It would be handy to access that right about now.”…


Import and Export for Office in GP 2013

A customer ran across an interesting issue with Excel Based Budgeting after they upgraded to GP 2013. They had been using Excel Based Budgeting in GP 2010 successfully – mostly to import/update existing budgets based on their existing spreadsheets.  What was successful in GP 2010, wasn’t working in GP 2013 – specifically cells that were based…

4

Display Specific Line in Sales Order Processing

This will be a 2-for-1 post today as the example given solves a frequently asked question and was used to solve a customer issue. The question I’ve seen a number of times before and been meaning to write about is: “How can I fill the Sales Order Processing scrolling window to a specific line?”.  With Dexterity…

1

Dynamics GP Crashes After Installing Addin

One thing we’ve noticed recently is an uptick of cases involving Visual Studio Tools assemblies causing Dynamics GP to crash after being installed. While I don’t think this has anything to do with GP 2013, it does seem to happen on that version.  Perhaps everyone is just going to the new version and thus coincidental….

10

Developing with the Microsoft Dynamics GP 2013 Named System Database

Microsoft Dynamics GP 2013 introduced another long sought after feature…. The Named System Database. Instead of the System database being hardcoded to DYNAMICS, a different name can be selected when installing GP. So what does that mean? Well, it means that more than one Dynamics GP system can reside on a single instance of SQL…


How to create Dexterity Cross Dictionary Lookups

As you may know, I was one of the pioneers of Cross Dictionary Dexterity Development and have posted about it a number of times (also see Can I customise a 3rd party form with Dexterity? and Understanding Cross Dictionary Dexterity Development). I am currently involved as a technical advisor on a large consulting project which requires customisation to…

1

Quick Tip: Capturing the Save Event with Visual Studio Tools

I recently responded to a community post which was asking how to ensure that all save events from the Item Maintenance window were captured using Visual Studio Tools. The aim was to make sure that the additional fields added to the window with Modifier were saved when the item data in the window was saved. The developer had already…

2

Using a GP Web Service Extension in the Connector for Microsoft Dynamics GP

The Connector for Microsoft Dynamics provides a powerful integration platform that can be customized and extended with the CRM Connector SDK and Web Services for Microsoft Dynamics GP SDK tool sets.  The CRM Connector for Microsoft Dynamics GP page in PartnerSource has various downloads to get you started with the CRM Connector including the SDK download.   You…

2

eConnect error – The stored procedure doesn’t exist

I ran across an odd eConnect issue a while back that I thought I’d share today. In this case, the customer had recently updated to GP 2010 and updated their application to eConnect 2010 from the previous version that worked fine. But now under GP 2010, when trying to run their eConnect integration it would…

3

Quick Tip: Solving Dexterity Trigger Clashes

In a recent support case, I had the rare situation where Dexterity Triggers clashed.  Dexterity allows third party developers to create triggers against various events and scripts in a Dexterity application (like Microsoft Dynamics GP). There are times where more than one third party product registers a trigger against the same event or script. Most…

6

Do not use the DEX_ROW_ID table column in your Customizations and Integrations

Today, I responded on a post on the Partner Forum asking “Can the DEX_ROW_ID change for a record over time?”. In this case the partner had seen the values for DEX_ROW_ID change on the GL20000 (GL_YTD_TRX_OPEN) and GL30000 (GL_Account_TRX_HIST) tables. This caused problems for an integration to an external system that used the DEX_ROW_ID as a…

11

Quick Tip: Passing Parameters to Background Processes in Dexterity

A couple months ago there was a post on the Partner Forum about Dexterity Oddities. One of the points raised in the post was about passing a text datatype parameter to a procedure called in the background and the fact that the contents of the text variable are lost. The same code called in the…

2

Quick Tip: Hidden Forms, Command Forms and Dictionary Context issues

This quick tip follows on from my previous post: Quick Tip: Updating Dexterity customizations to work with Security Tasks and Security Roles. There are times when there is a requirement to have some fields on a hidden form (a form with non of the windows set to AutoOpen). One example is when you want code…

4

Quick Tip: Updating Dexterity customizations to work with Security Tasks and Security Roles

Another Quick Tip for Dexterity developers. This one discusses what changes need to be made to an integrating Dexterity application when upgrading from pre version 10.0 code to version 10.0 or GP 2010 to handle the changes in the security model. When version 10.0 was released it changed the security model from the old user and…

3

Quick Tip: Best Practice for Dexterity Version and Build Numbers

A common question that new Dexterity developers have is what should they use for the version and build numbers when creating a chunk dictionary for distribution. This post discusses how those numbers are used and what the best practice for setting their values is. The following Knowledge Base (KB) article that I wrote discusses the…

3

Quick Tip: Creating Dexterity System Variables

Hi everyone. This is another Quick Tip post for Dexterity developers. Vaidy’s recent post: “Illegal Address Field” Error while accessing a Global, raised the issue and so I thought I would respond with an explanation. The issue is when you create a System Variable (global variable) from an existing Dynamics Global Field.  While you are in…

3