This 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.
This 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.
This 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
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
As I perform my role in the Asia Pacific Microsoft Dynamics GP support team I am finding that more and more sites already have the Support Debugging Tool for Microsoft Dynamics GP installed. This makes my job much easier as there are many features of the tool that help a support engineer diagnose and resolve technical issues.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
A couple of weeks ago, a good friend of mine posted on his Facebook account that his 1TB external hard drive had failed and that it contained a lot of data that was not stored anywhere else. In particular, there was 10 years worth of digital photos. All now lost.
I did have a look at the drive to see if it was something that could be recovered, but the problem was definitely a hardware failure with the drive failing to initialize. It would spin up the platters, but would make some very nasty noises when trying to perform the initial head seek. If my friend wanted to spend the money, it would be possible for a hard drive recovery specialist to recover the data by replacing the drive head assembly. However, as far as I know he has resigned himself to losing the photo collection.
So why am I telling you this little story?
Simple. As a warning.
This 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?
This 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.
This 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?
This 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.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I had a case a couple of weeks back, where the customer wanted to filter the transactions shown on a Receivables Management Statement. There was one type of transaction that they did not want included on the statements sent out to the customers. The transactions to be excluded could be identified by a particular value on the Description field on the transaction.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Have you ever had to develop Dexterity code that needs to read data from a company other than the current Microsoft Dynamics GP company? Well, with my latest updates to the Support Debugging Tool, I came across this requirement.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Today, I thought I would spend a little time explain how to read a Dexterity Script Profile to resolve a performance issue. To demonstrate this I will use a support case I had where the customer was intermittent long delays when clicking on the checkbox on the Apply Sales Document window.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Here is another Quick Tip article. This time I wanted to discuss the best practices for making conditional triggers in Dexterity.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
This is a Quick Tip post to explain how the Dexterity Reject Script command works.
This 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.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
If you have ever used the SOP Blank Invoice Form or the POP Purchase Order Blank Form in Microsoft Dynamics GP, you will have seen the vertical lines on the report which make up the boxes around the various sections of the report. This article explains how those vertical lines work and how to easily make changes to them.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Keeping with the theme of my previous post, I have another “Temporary” topic to discuss.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Dexterity developers often need to use temporary tables to perform tasks, such as displaying data in a different order, consolidating or totalling data, to store data while it is being edited, or to combine data from tables so it can be sorted using an index using fields from multiple tables.
This 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?“.
This 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?