Need to build multicompany version of the standard customer smartlist - to do this through the smartlist builder I need to know what tables and joins the standard template is using
*This post is locked for comments
I have the same question (0)

Need to build multicompany version of the standard customer smartlist - to do this through the smartlist builder I need to know what tables and joins the standard template is using
*This post is locked for comments
I have the same question (0)The out-of-the-box SmartLists run on underlying SQL Views of the same name. In SQL Management Studio, expand your company database and then expand Views. You will see a View that correlates to the same named SmartList. You can right-click > Edit any of these Views to see the actual tables and joins used.