Dynamics Community Forum Thread Details

Smartlist

Is there a way to see the tables an already exsisting smartlist report is set up to use? if so is there a way to add one and pull in additional columns relating to a transaction that is not showing up under the listed field names?

For example- there is a smartlist called Receivings Transactions that I would like to pull and also include the PO number and Item number. Can I link this to a new table to pull in those items? That are listed within the receiving transaction itself.

Thanks,

Amanda

Yes, you can lookup the tables fairly easily; I've got three suggestions:

1. Each SmartList Object is built from a view of the same name. You could read the SQL code and determine the tables and Joins and such.

2. If you have the SmartList Builder product you can go and import SmartLists they have created that match the existing out of the box SmartLists.

3. The easiest way is to install Dexterity from the GP Install media, and then open up the IG.pdf file in the documentation folder. Go to the chapter about SmartList overview - it's chapter 33 in my books. Scroll down until you get to the section about SmartList objects. Here's what one of them looks like