Quick Tip: Passing Parameters to Background Processes in Dexterity

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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 foreground works.

Continue reading

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

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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.

Continue reading

Quick Tip: Using substring() with a text field datatype

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

An interesting tip today. Over the last few months there has been a thread on the Partner Forum (GP Notes Lockdown) with the request to prevent changes to the existing text on the Record Notes feature of Microsoft Dynamics GP.

Continue reading

Quick Tip: Best practice for using sum range table command

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I came across an interesting issue yesterday relating to the Dexterity sum range command. We had a SQL datetime conversion error caused by a sum range command. This was the error message:

A sum range operation on table ‘SVC_Serial_Lot_Work_HIST’ failed accessing SQL data.

More Info: [Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting date and/or time

Continue reading

Quick Tip: Using eConnect to update Customer or Vendor Addresses with a blank Address Line 3

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I had a case this week that was asking a fairly commonly asked question about integrating address information using eConnect. The scenario is that we want to update a customer or vendor address and the previous address had three lines in the address and the new address only has two lines. When the update is processed, Address Lines 1 and 2 have been updated, but Address Line 3 has the old data and has not been cleared.

So how can I update Address Line 3 with blank data?

Continue reading

Quick Tip: Why does Microsoft Dynamics GP show as Not Responding

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I am wondering if Joseph Tews is a mind reader, or if he can somehow see my draft blog posts before they are published.  Joking aside, it turns out that the same day he posted about Symantec Endpoint Protection, he also posted about this topic that I was planning to post about. Unless he has a super power, then I will have to believe that these issues are faced by enough people to warrant multiple blog posts.

Continue reading

Quick Tip: Dynamics fails to launch on system with Symantec Endpoint Protection installed

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I recently had a case where the customer was able to install the Microsoft Dynamics GP client on a machine, but when they clicked on the shortcut nothing happened. Even dragging the DYNAMICS.SET launch file onto the DYNAMICS.EXE application did nothing. In fact, any thing that involved getting the Dexterity Runtime Engine DYNAMICS.EXE to launch failed.

Continue reading

Quick Tip: Best Practice for Dexterity Version and Build Numbers

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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.

Continue reading

Quick Tip: Table Hierarchy Inconsistency Errors in Runtime Mode

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Following on from yesterday’s post: Quick Tip: Creating Dexterity System Variables, I want to cover a related issue.

This is when a Dexterity developer is creating a report (either new or alternate) which will display data from newly added tables. To get the data to show on the report the developer creates a table relationship from an existing Dynamics table to their newly added table.

Can you spot the problem yet?

Continue reading

Quick Tip: Creating Dexterity System Variables

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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.

Continue reading

Tips for Using the Control Panel Applet and Service for Dexterity Source Code Control

Alice Newsam - Click for blog homepageThis is a reposting of an article Alice Newsam originally wrote on my Developing for Dynamics GP blog.

Recently, Rob Anderson and I presented the “What’s New in Dexterity for GP 2010 R2” session at the Microsoft Dynamics GP Technical Conference in Fargo, so I thought I’d share some of that information with you through a series of posts.  One question that comes up a fair amount of the time is around using and saving information with the Control Panel applet for Dexterity Source Code Control especially on machines that have UAC (User Account Control) turned on so I thought I’d tackle that topic first.

Continue reading

Quick Tip: Choose Profile Dialog Opens in Dynamics

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

A question that I’ve seen in the past and ran across recently in a forum post is the issue of being prompted to pick your Outlook Profile when Dynamics GP attempts to access Outlook via the MAPI function library in Dexterity.

Continue reading

Quick Tip: Solving Illegal Address Errors on Alternate Windows after installing a Service Pack

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Every time a Service Pack for Microsoft Dynamics GP is released, there is a potential for the installation of the service pack to cause Illegal Address errors for a field on Modified or Alternate windows.  I have seen this a few times over the years, mostly with the Sales Transaction Entry (SOP_Entry) window in the Sales Order Processing (SOP) module.

Continue reading

Quick Tip: Solving “Do you want to Save?” dialog appearing after VBA customization

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Have you ever used Modifier and Visual Basic for Applications (VBA) to add an additional field to a window?  Have you then had the issue when navigating through records on that window, it keeps coming up and asking “Do you want to Save, Discard or Cancel?” or “Do you want to Save, Delete or Cancel?“.

Continue reading

Quick Tip: Changing Dexterity Script Debugger Context

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

This post is the first of a new style of blog post.  The idea is to publish the response to a question that I have been asked as a “Quick Tip” so that others can benefit from the information.  Over time we should end up with a few real gems of information… You never know, I could present 50 of them in a 50 minute session at a conference…. No wait … Mark already did that.

How can I change the Script Debugger Context to work on my dictionary?

Continue reading