This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
If you are a Dexterity developer who uses SmartList Builder to create SmartList favorites for your products and you use the Execute Procedure Go To functionality. This post is for you.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I have yet another interesting case to discuss with you. The partner had created a set of views into the SQL data with the final view being displayed as a SmartList after being added using SmartList Builder. This post is not going to cover how to use SmartList or SmartList Builder, but instead focus on the problem we were seeing.
This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.
I’ve seen several questions over the years on Smartlist of the “Why doesn’t it?” variety such as:
This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.
So many interesting cases, so little time to talk about them.
My interesting case this week is the mystery of the deleted POP Distributions.
The ISV had a customer where all of the distribution records in the POP10390 were being randomly deleted. They had been trying to track this down for weeks and with the help of the Support Debugging Tool was able to capture a script.log of this happening.
This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.
In a Microsoft Forums post a few days ago, an ISV had created a custom window and a table to store parallel data to the Item Serial Number Master table.
Her goal was to use Smartlist Builder (SLB) to make a Smartlist to show the GP & custom data in one Smartlist. That part was successful.
The 2nd goal was to make a GoTo to drill back to the custom window to display the Item & Serial Number (her parallel key) and display the custom data that goes with it.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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 a string field 132 characters long.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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 be used by SmartList Builder to show the Extender data in SmartList.