Dynamics PTS Team Blog

A blog managed by Dynamics Partner Technical Services team for Global English

Creating Smartlists with Sub Query Restriction using Smartlist Builder

Smartlist Builder is a great tool to create custom smartlists. We can create smartlists using Dynamics GP tables (or) using SQL objects. However, there have been many requests from customers and partners to retrieve the data from smartlist using a sub query filter. An example of such a request is to pull out all payables transactions… Read more