Since the release of the original version of this book, which focused on Dynamics GP 2013, SmartList has received a few updates. The Designer, which is now part of SmartList, allows for the creation of Excel refreshable reports based on custom SmartList objects that were originated in the Designer. The Designer can easily create both a SmartList object and an Excel refreshable report using a SQL view (which we discussed in Chapter 1, Getting Data from Dynamics GP 2016 to Excel 2016.) Let's create a new SmartList object and a new Excel refreshable report now.
Let's create a new SmartList object that will display the bank accounts and their balances, from the Bank Reconciliation module. Microsoft has a view already built to do this very thing, named CM00500, which is stored in each company's SQL database. Let's take a look at the following steps to create a new object:
Open SmartList as you would to pull up accounts...