Editing Standard SmartLists with SmartList Builder

Every now and then I get asked “How you can modify an existing SmartList favorite with SmartList Builder?”. The short answer is you cannot. This is because the standard SmartLists are written as Dexterity code in each of the dictionaries that integrate with the SmartList dictionary. The Dexterity Integration Guide document (IG.PDF) has an entire section…

13

SmartList Builder Execute Procedure Go To Changes for GP 2010

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. Below is a screenshot of the v10.0 window used for adding a Go To which executes a global procedure.  You will notice that the…

2

SmartList Builder based on SQL View not returning data

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…

5

Smartlist: Only the data area should grow

I’ve seen several questions over the years on Smartlist of the “Why doesn’t it?” variety such as: Why does Smartlist export to Excel so slowly? Because Smartlist exports row by row and sets each cell individually. Why does Smartlist automatically try to display the default Smartlist when the node is selected (such as Customers)? It…

14

POP Distributions randomly being deleted

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…

0

The Smartlist Builder GoTo won’t open my window

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…

0

Understanding how Microsoft Dynamics GP works with Microsoft SQL Server

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 and especially in the fact that it originally did not work with Microsoft SQL…


Creating SQL Views of DUOS Data

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. Below is a table which shows the columns in…

8

Tools Sessions at Convergence 2009

If you are going to Convergence 2009 in New Orleans between the 10th and 13th 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 Personalized Solutions using Modifier with VBA for Microsoft Dynamics GP Beth Gardner Explore…

3

Creating SQL Views of Extender Data

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…

14