Tag Archives: SmartList Builder

New SmartList Builder features from eOne

January 6, 2014 by Victoria Yudin 3 Comments

As promised, eOne has released new SmartList Builder features as soon as it got the product back from Microsoft. (If you’re not sure what I mean by that, here is a reminder.) I am hoping to test all of this out in the upcoming week, but in the meantime, I am very excited by some of […]

Continue reading →
Dynamics GP, GP 2013, SmartList Builder
, ,

Important SmartList Builder announcement

September 10, 2013 by Victoria Yudin 13 Comments

On the heels of the Extender and Collections Management announcements over the last year, it has just been announced that SmartList Builder is joining the Microsoft Dynamics GP OEM modules “coming home”. You can read about all the reasons and details for this in Martin Olsen’s comprehensive announcement on the eOne blog. This is certainly […]

Continue reading →
Dynamics GP, Microsoft, SmartList Builder
, ,

How to use a SQL view in SmartList Builder

April 20, 2009 by Victoria Yudin 43 Comments

Something I have been asked more than a few times is how to use a SQL view in SmartList Builder to create a new SmartList.  I am going to walk through this step by step using Dynamics GP 10.0 SP 3 and SQL Server 2005 SP 3:   STEP 1  –  create SQL view To start […]

Continue reading →
Dynamics GP, GP SQL scripts, SmartList Builder
, , , , ,

SQL view to show security roles and tasks in Dynamics GP

March 12, 2009 by Victoria Yudin 25 Comments

Dynamics GP 10.0 has brought about a drastic change in GP security. Not only is the security pessimistic now, so by default no permissions are granted, but setting up and administering security is quite different from what many of us are used to after working with previous versions of GP for many years. And, of course, reporting on […]

Continue reading →
Crystal Reports, Dynamics GP, GP 10.0, GP 2010, GP Reports code, GP SQL scripts, System/Setup SQL code
, , , , , , ,

Adding Extender Data to SmartLists

November 3, 2008 by Victoria Yudin 35 Comments

This has been a very popular question for support lately: “I have created an Extender window, how do I add data from it to my SmartLists?”  Extender includes the ability to add fields to both existing SmartLists or ones created in SmartList Builder.  Below is an example using GP 9.0.  [Click on any of the […]

Continue reading →
Dynamics GP, Extender, SmartList Builder
, , ,

Granting access to a new SmartList in Dynamics GP

October 8, 2008 by Victoria Yudin 74 Comments

We have been seeing a lot of questions on granting access to new SmartList Builder SmartLists. Because this is so different from older versions of Dynamics GP, we’ve created a really detailed list to go through it. This may be overkill for some, but it will hopefully cover every needed scenario. (Update: These instructions will work for […]

Continue reading →
Dynamics GP, GP 10.0, GP 2010, SmartList Builder
, , ,