Open Forum

Expand all | Collapse all

Printing a list of Smartlist reports #admin

  • 1.  Printing a list of Smartlist reports #admin

    Posted Apr 11, 2019 12:31 PM
    We are in the process of cleaning up our smartlist reports.  Is there a way to print a list of the smartlists and maybe the last date used?
    Any tips for cleaning these up would be great!


    ------------------------------
    Lisa Overlin
    Director, Business Systems Analysis
    Guidepost Solutions
    TX
    ------------------------------
    GPUG Summit - Post


  • 2.  RE: Printing a list of Smartlist reports #admin

    TOP CONTRIBUTOR
    Posted Apr 11, 2019 05:10 PM
    Hi @Lisa Overlin

    The table ASIEXP81 holds all the information about your SmartLists.  It's an extensive table that also holds onto the parameters of the favorited SmartLists, but for just a listing of them run this:

    SELECT [CMPANYID]
    ,[USRCLASS]
    ,[USERID]
    ,[ASI_Favorite_Name]

    FROM [DYNAMICS].[dbo].[ASIEXP81]​

    ------------------------------
    Jo deRuiter, MCP, DCP
    "That GP Red Head"
    AISLING DYNAMICS CONSULTING, LLC
    WEBSITE: https://aislingdynamics.com/
    BLOG: https://community.dynamics.com/gp/b/gplife
    770-906-4504 (Cell)

    ------------------------------

    GPUG Summit - Post


  • 3.  RE: Printing a list of Smartlist reports #admin

    GOLD CONTRIBUTOR
    Posted Apr 11, 2019 08:40 PM
    Edited by Ryan Galang Apr 11, 2019 09:01 PM
    Hi Lisa,

    Just adding to what @Jo deRuiter said... linking some more tables...
    ...still, no "last date used"...
    -----

    use DYNAMICS
    select isnull(TRANSVAL, '') SmartList, ASI_Favorite_Name Favorite,
       Module = case when asi_favorite_dict_id = 3830 then 'SLB' else 'GP' end,
       a.CMPANYID, isnull(CMPNYNAM,'') CompanyName, USRCLASS, USERID
          from [ASIEXP81]​ a
          left join [ASITAB30] b on a.[ASI_Favorite_Name] =b.UNTRSVAL
          left join [SY01500] c on a.cmpanyid = c.cmpanyid


    ------------------------------
    Ryan Galang
    BTP Technologies LLC
    Chantilly VA
    ------------------------------

    GPUG Summit - Post


  • 4.  RE: Printing a list of Smartlist reports #admin

    TOP CONTRIBUTOR
    Posted Apr 12, 2019 09:35 AM
    SmartList unfortunately does not store anything about the last time a list was run.

    I believe you have SmartList Builder.  If so we have a template that will give you list of all of your SmartList Favorites and their save level.  Here is more information on the template:  https://www.eonesolutions.com/help-article/smartlist-favorites-smartlist-builder-template/.



    You can import the template by going to Microsoft Dynamics GP - Tools - SmartList Builder - Import.  From there, select the Import from Web.  You will find the list under the product of Microsoft Dynamics GP and the Series of System.  If you are on an older version of SmartList Builder and don't have the import from web option, you can download it from here under the System series:  https://www.eonesolutions.com/smartlist-builder/downloads/#templates



    ------------------------------
    Nicole Albertson
    Product Manager
    eOne Solutions
    ------------------------------

    GPUG Summit - Post


  • 5.  RE: Printing a list of Smartlist reports #admin

    GOLD CONTRIBUTOR
    Posted Apr 12, 2019 09:45 AM
    Hi ​@Nicole Albertson  and  @Lisa Overlin​,

    We too would love to have the feature of "last used".  Opening SmartList for us has grown to 34 seconds.  We believe that several SmartLists created are no longer used, but without the "last used" date, it is more of a guess.  The fewer the SmartLists, the quicker the opening.

    A co-worker created a trigger to record every time a SmartList is "touched" and that has helped some.  But, when a Reminder is created, all SmartLists are touched so we are working on ways to filter out the "mass touches".

    @Nicole Albertson - please add @Lisa Overlin need to a future enhancement list.
    ​​

    ------------------------------
    Terry Horn (retiring July 1, 2019)
    IT Manager
    Owensboro Municipal Utilities
    Owensboro KY
    ------------------------------

    GPUG Summit - Post


  • 6.  RE: Printing a list of Smartlist reports #admin

    TOP CONTRIBUTOR
    Posted Apr 12, 2019 10:52 AM
    I unfortunately cannot change SmartList to track this.  That would have to be requested from Microsoft.  I will enter a product suggestion for SmartView to do it and for SmartList Builder as something we can maybe add on if a customer is using SmartList and has SmartList Builder.  Just cannot do anything for those with just SmartList.

    Nicole


    ------------------------------
    Nicole Albertson
    Product Manager
    eOne Solutions
    ------------------------------

    GPUG Summit - Post


  • 7.  RE: Printing a list of Smartlist reports #admin

    GOLD CONTRIBUTOR
    Posted Apr 12, 2019 11:05 AM
    ​Thanks Nicole.

    ------------------------------
    Terry Horn
    IT Manager
    Owensboro Municipal Utilities
    Owensboro KY
    ------------------------------

    GPUG Summit - Post


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