Canada - Ontario Regional Chapter

Expand all | Collapse all

GP Smartlist Builder

  • 1.  GP Smartlist Builder

    Posted Oct 30, 2018 10:31 AM
    Good morning all,

    I would like to know if anyone has ever enrolled in a day course to learn:
    a) How to build smartlists in GP
    b) Learn how to effectively use the background​ SQL tables to build smartlists

    I have a goal to learn how to build these lists from scratch but when I go in behind the scenes, I make a mess of everything?

    Does anyone have any suggestions please?


    Joe Braun
    The Law Society of Alberta
    Calgary AB

  • 2.  RE: GP Smartlist Builder

    Posted Oct 31, 2018 08:35 AM
    ​Hi Joe,

    I don't know of any course concerning Smartlist (SL) ... but ... I know Victoria Yudin! ;¬)

    Her web site is full of great informations about the SQL background of GP.
    Here is the page explaining the steps to build a SL with SQL data :

    How to use a SQL view in SmartList Builder
    Victoria Yudin remove preview
    How to use a SQL view in SmartList Builder
    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 ...
    View this on Victoria Yudin >

    I don't know your affinity with SQL or DataBases but, if your not, I'd also suggest some courses about those too.

    Hope it helps.
    Good luck with your SL,

    Kind regards

    Olivier Roy
    Centre des services partagés du Québec
    Québec QC

  • 3.  RE: GP Smartlist Builder

    Posted Oct 31, 2018 11:12 AM
    Hi Joe,

    Another good resource may be eOne, if you haven't reached out to them yet.
    They designed Smartlist Builder originally. Their support is really good and they may even offer courses.

    Kind regards,

    Maria Frandzeskakis
    IT Manager
    MIP Inc.
    Anjou QC

If you've found this thread useful, dive deeper into User Group community content by role