Open Forum

Expand all | Collapse all

Great Plains SmartList reports

  • 1.  Great Plains SmartList reports

    Posted 27 days ago
    We recently went through an upgrade from an older version to the 2018 version of Great Plains. The SmartList reports I rely on disappeared and the explanation had something to do with "canned" reports vs reports created specifically for our company. The firm we work with on GP maintenance has been unable to duplicate the reports and I do not have access to "Designer". I am able to add columns to reports but not all of the choices are there. Has anyone had a similar problem and/or does anyone have any suggestions? Thank you

    ------------------------------
    Terri Regina
    Schurz Communications, Inc.
    Mishawaka IN
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Great Plains SmartList reports

    GPUG ALL STAR
    Posted 27 days ago
    Hi @Terri Regina

    The SmartList's are kept in the database, if the DB was moved and upgraded correctly they would be there.

    The ONLY other explanation is that you used to have SmartList BUILDER by eOne solutions installed and that has NOT been installed on the machine you are logging in to GP on.  They would show back up as soon as the BUILDER is installed.

    Otherwise, your SmartLists should all be there and it is highly concerning that they are not.



    ------------------------------
    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: Great Plains SmartList reports

    Posted 20 days ago
    Yes, I experienced it. After upgrade Smartlist Builder was not available to the user. So I created SQL views and added them through smartlist designer. you can do the same to have all the required data in your smartlist.

    ------------------------------
    dexteritydeveloper
    dexteritydeveloper@gmail.com
    https://keptonworking.blogspot.com/
    ------------------------------

    Academy - Online Interactive Learning from Experts


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