Open Forum

 View Only
  • 1.  Reoccurring Smartlists

    Posted 23 days ago
    Hello Everyone,

    Does Microsoft Dynamics have a feature to run daily smartlists and save them to a file? I've found that you can run trial balances daily with My Reports so I was wondering if there is something similar to pull data from smartlists.

    Thank you!

    ------------------------------
    Amanda Pezewski
    Prevea Health, Inc.
    Green Bay WI
    ------------------------------


  • 2.  RE: Reoccurring Smartlists

    TOP CONTRIBUTOR
    Posted 16 days ago
    There is no GP Smartlist or Smartlist Builder feature available for this. Alternatively many use the MSDB SQL sp_send_dbmail  stored procedure to send scheduled CSV files to mail Recipients using the same SQL Views as used or created for Smartlist. I think  Refreshable Excel Reports may also be an option but we have dbmail for 20 years and it works just fine once configured.

    ------------------------------
    Thaddeus Suter
    Retus, Inc
    HELOTES TX
    ------------------------------



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