Browse by Tags
All Tags »
SQL (RSS)
An ISV ran across an interesting problem a few days ago in his Dexterity/Dynamics 9.0 solution. The goal of a particular procedure was to copy records from one table into a nearly identical duplicate temporary table. The duplicate table contained all
Read More...
Following on from last week's post on OLE Attachments and Record Notes , I can now get to the reason for the interest in notes and OLE attachments. The partner was trying to copy master records for Vendors from one company to a new company. They wanted
Read More...
Extremely well.... The answer is out there for all to read. The Microsoft Dynamics GP team is excited to announce the availability of a new White Paper documenting the successful Performance Benchmark Testing of Microsoft Dynamics GP 10.0 SP2 with SQL
Read More...
If you have looked a DEXSQL.LOG file to see the communication between SQL Server and the Microsoft Dynamics GP application, you might have noticed messages with errors 5701 and 5703 being reported. See the example below: /* /* Date: 08/10/2009 Time: 20:09:49
Read More...
In a recent forum post , the question of where the business logic for Dynamics GP resides was raised. This is an excellent question which, sadly, does not have a simple answer. When Great Plains Dynamics was first developed for the Ctree and Btrieve ISAM
Read More...
In the previous article in this series, Microsoft Dynamics GP and Illegal Characters Part 1 , we discussed how string delimiter or terminator characters can cause issues and need to be handled correctly. The article discussed the single quote (') and
Read More...
Over the years that I have worked with Microsoft Dynamics GP, there are been a few occasions where we have had issues with so called "illegal" characters. While the use of these characters should work everywhere, there are times when the characters are
Read More...
I was asked recently about the Note Index field and how it is used and in particular about the Note Index field in SY01500 table in the DYNAMICS system database. This post will explain how the field is used as well as explain how it is possible to create
Read More...
As a followup to last week's post about Understanding how Microsoft Dynamics GP works with Microsoft SQL Server , I am adding a few more topics about why Microsoft Dynamics GP works the way it does with Microsoft SQL Server. So here goes .... Transactions
Read More...
Many people who have not been working with Microsoft Dynamics GP since the early non-SQL versions of Great Plains Dynamics sometimes wonder about the way that the application works with Microsoft SQL Server. The answer is in the long history of the product
Read More...
From the Useful SQL Scripts Series . I was assisting on a support case recently where we needed to identify transactions in Payables Management history which had missing Apply records. We wanted to add up the total of the Apply records and make sure that
Read More...
Visual Basic for Applications (VBA) can use the Dynamics User Object Store (DUOS) table to store additional data such as user defined fields. The SY_User_Object_Store (SY90000) DUOS table uses a single row for each field stored, It stores the data in
Read More...
My friend Victoria Yudin has posted a great introductory article on her blog about how to use the LIKE command in where clauses when creating queries on SQL Server. Even if you know your Transact-SQL, it is always good to get a refresher. Have a look
Read More...
If you are going to Convergence 2009 in New Orleans between the 10 th and 13 th of March 2009, make sure you attend the various sessions about the Microsoft Dynamics GP development and customization tools. Below are the details of the sessions: GP04 Building
Read More...
Extender can create SQL views of the data in an Extender window which allows the data to be viewed as a single row in the view even though the actual data is stored as a multiple records across multiple tables (depending on data type). This view can then
Read More...
