This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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).
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Back in January 2009, I wrote an article: The Importance of Reporting the first Error, which talked about why it is important to report errors, but especially the first error.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Today we are going to cover some of the changes you will need to make to your Dexterity code to just bring forward your code to Microsoft Dynamics GP 2013. This will not leverage any of the new functionality or features of Microsoft Dynamics GP 2013, but will at least get your Dexterity code running.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
In the last couple of weeks, I have had a few cases where Dexterity command based menus for addon products no longer showed in Microsoft Dynamics GP 2010 after Service Pack 3 was installed.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I had a case today that raised an issue that I have seen before which has a simple solution.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
As a Dexterity developer, I have written a number of customisations to Microsoft Dynamics GP which add additional fields to the system. These additional fields are often have a relationship to existing data in Dynamics GP.
It is quite common to store the additional data in a parallel table (sometimes called companion or shadow table). This is a table having same primary key as an existing table, with the additional fields.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
A long time ago, in an ERP system far far away, data was stored in tables which in turn were stored as files in folders.
Yes, before Great Plains Dynamics became Great Plains Dynamics C/S+ for SQL (version 3.15/3.17), we had to specify pathnames to dictate where the Ctree or Btrieve files for each series (Financial, Sales, Purchasing, Company, System, etc.) and for each product / dictionary would be located. There was also a location translation system which allowed the paths to be mapped when a workstation required a different drive letter or machine name to access the data.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I recently posted the Quick Tip: Copying small amounts of data in SQL Server quickly. This quick tip used the clipboard to copy data between tables as an alternative to using DTS (Data Transformation Services), SSIS (SQL Server Integration Services) or Transact-SQL (T-SQL).
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Last week, I was working on a Microsoft Dynamics GP update case where we had to re-upgrade one company from the previous service pack to the current service pack.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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).
This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.
I assisted on an eConnect incident today that was quite interesting and I thought I’d share the case and the solution.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I have completed the development project I was working last week and have another Quick Tip that came out of the project. For the previous Quick Tips related to this project have a look at Quick Tip: Passing Variables to SQL Server and Quick Tip: Passing Date and Time Variables to SQL Server.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
As a follow on from yesterday’s post, Quick Tip: Passing Variables to SQL Server, I wanted to discuss the related topic about passing of date and time variables.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Wow, the week is almost over and I am yet to post something.
This week I was working on a small development project using Visual Basic for Applications (VBA) to execute some commands at the SQL Server level after some user interface events. The code to be executed needed to have values from the windows passed through to the Transact-SQL. Now most people just write the code and pass through the value of a string field concatenated before and after with single quotes.
[code language=”sql”]
sqlstring = "select * from IV00101 where ITEMNMBR = ‘" & CStr(ItemNumber) & "’"
[/code]
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Today I have a post on the solution to a tricky SQL issue.
When working with SQL Server and creating a join that links tables in two databases, all goes well when the two databases have the same collation. However, if the databases have different collations the query it will fail in a writhing blubbery gelatinous slimy mess of confused character mappings, or at least return something similar to the following error:
Msg 468, Level 16, State 9, Line 4
Cannot resolve the collation conflict between “Latin1_General_CI_AS_KS_WS” and “Latin1_General_CI_AS” in the equal to operation.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Here is a neat trick that I just used to copy images from a Microsoft Word 2007/2010 *.docx document.
I was given a Word document of a blog article to be posted on the blog. To get the text into the blog post editor (without extra html) is easy…. Just cut & paste into Notepad.exe and then cut & paste the plain text from Notepad.exe into the editor window. A little editing to add some formatting back and the text is done.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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 key field.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Now I am sure there are people out there that will be thinking that this is a silly topic for a blog article. Surely everyone knows how to get the number of records from a SQL table using the COUNT(*) function?
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
This quick tip follows on from my previous post: Quick Tip: Updating Dexterity customizations to work with Security Tasks and Security Roles.