Browse by Tags
All Tags » SQL ( RSS)
-
|
I have had two support cases with this issue recently. So I thought I would post an explanation of the problem along with a script to fix it. The good news is that the underlying cause of the issue has been fixed in Microsoft Dynamics GP 2010 (v11.00...
|
-
|
Last week, I tackled the subject of orphaned records in the Extender tables when the parent records were deleted and the Extender data was left behind. If you have not read this post the link is below: Removing Extender Data when deleting Transactions...
|
-
|
A recent newsgroup post asked about how to fix the error message shown below from occurring when clicking the Attach button on the Note window for a record level note. "The note ID has not been set." The cause of the message is that the 'Note...
|
-
|
Over the years, I have seen many requests for Windows Authentication support for Microsoft Dynamics GP, and I have to say I have mixed feelings about it. In theory, it sounds good, but in practice it may be a threat to your customer's financial information...
|
-
|
I wanted to tell you about a recent case I had where the Partner was trying to restrict the Microsoft Dynamics GP data they had selected with the eConnect Requester Setup Tool. They were first importing some of their Sales Orders from an external system...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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 (')...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
Many of inquiry windows in Microsoft Dynamics GP have been optimized to leverage SQL Server to increase performance. This is especially common with transaction inquiry windows which can combine data from more than one table (ie. Work, Open and History...
|
-
|
From the Useful SQL Scripts Series . Because Microsoft Dynamics GP is designed to have separate tables for WORK, OPEN and HISTORY transactions, there are times where it is possible for a transaction record to exist in more than one table. This is usually...
|
-
|
From the Useful SQL Scripts Series . When a system has a batch that is stuck as marked to post or a transaction that cannot be accessed as it says it is already being edited, the usual instructions are to exit all users from the system and then delete...
|
-
|
From the Useful SQL Scripts Series . This stored procedure allows you to search all columns in all tables in a database for the occurrence of a particular string or value. Wild card characters such as those supported by the LIKE keyword can be used. For...
|
-
|
After the success of the Microsoft Dynamics GP Application Level Security Series , I have decided to release a another series which contains some really useful SQL scripts I have collected over time. The posts in the series (so far) include: 01-Dec: spSearchOnAllDB...
|
More Posts Next page »
|
|
|
|
|
|
|