Open Forum

Expand all | Collapse all

Smartlist does not return any data

Jump to Best Answer
  • 1.  Smartlist does not return any data

    Posted Jul 30, 2021 02:19 PM
    Hi, has anyone experienced this issue. It has been a problem for us for quite some time. We are on GP2016 and have about 20 years of data in our DB. When users run smartlist it sometimes does not bring up any data and says it is exploring. If left it will explore for a long time until we close GP (using task manager). I tried to make sure there are ranges and not querying the entire DB but it still crashes. Any ideas would be helpful. Thank you.

    ------------------------------
    Steve Parisi
    Controller
    Qosina Corp
    Ronkonkoma NY
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Smartlist does not return any data

    GPUG ALL STAR
    Posted Jul 30, 2021 02:22 PM
    @Steve Parisi

    How was the SmartList built?  Is it one of the out of the box SL or is it custom built with either the Designer or Builder?​

    ------------------------------
    Jo deRuiter
    🌟 GPUG ALL STAR
    💫Granite Award Winner
    Atlanta Chapter Leader
    Aisling Dynamics Business Solutions
    Business Applications Practice Manager
    jo.deruiter@aislingdynamics.com
    9518674366
    aislingdynamics.com
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Smartlist does not return any data

    Posted Jul 30, 2021 02:26 PM
    Its is your normal out of the box GP smartlist. Thanks

    ------------------------------
    Steve Parisi
    Controller
    Qosina Corp
    Ronkonkoma NY
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Smartlist does not return any data
    Best Answer

    GPUG ALL STAR
    Posted Jul 30, 2021 02:28 PM
    @Steve Parisi

    Can you give us the name of the SmartList?  Does it have an asterisk * ​at the end of the name?

    I'm trying to determine if it is custom made which will make all the difference in determining HOW to fix this.

    ------------------------------
    Jo deRuiter
    🌟 GPUG ALL STAR
    💫Granite Award Winner
    Atlanta Chapter Leader
    Aisling Dynamics Business Solutions
    Business Applications Practice Manager
    jo.deruiter@aislingdynamics.com
    9518674366
    aislingdynamics.com
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Smartlist does not return any data

    Posted Jul 30, 2021 02:37 PM
    I is a sales line item smartlist. It is called item sales by part. I saved it as a favorite for just the users who are running the smartlist. The range is by item number and doc date. We are not clicking on the asterisk.

    ------------------------------
    Steve Parisi
    Controller
    Qosina Corp
    Ronkonkoma NY
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Smartlist does not return any data

    GPUG ALL STAR
    Posted Aug 02, 2021 07:26 PM
    Steve,
    Aside of your SmartList problems with slow performance, one may wonder how large your data is... especially considering that default GP smartlists are built to grab data from both the Work & History tables, which makes it sometimes a less than optimal query tool..
    Do you have access to SSMS (SQL Back-end thru Studio Management) ? How about Excel reports deployed with GP ? if you have those deployed, you may want to use the Excel reports as they are 10 times faster to retrieve the data out of GP than Smartlists..
    If you do have access somewhat to your SQL back-end, I would be curious to check how many records are hold in your SOP30xxx tables and SOP10xxx tables.. 20 years worth of data can represent a large chunk to go thru in GP, even by using filters.

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 7.  RE: Smartlist does not return any data

    GPUG ALL STAR
    Posted Aug 03, 2021 12:40 AM
    Hi @Steve Parisi

    ​Please see these articles

    https://winthropdc.wordpress.com/2013/06/20/why-does-smartlist-not-return-all-of-the-expected-data-for-large-queries/

    https://winthropdc.wordpress.com/2010/06/23/smartlist-builder-based-on-sql-view-not-returning-data/

    Regards

    David

    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------

    Academy - Online Interactive Learning from Experts


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