Excel Report Builder is a lot like SmartList Builder except the product is a refreshable Excel spreadsheet. It's refreshable because it is linked to the company's database instead of the static data you get from downloading information from a SmartList object. It's a kind of Excel SmartList object.
Let's build one!
You'll use the Warehouse Quantities SmartList object that you just built and turn it into an Excel report using Excel Report Builder.
Open the SmartList Builder module using the following navigation: Microsoft Dynamics GP | Tools | SmartList Builder | SmartList Builder.
The SmartList Builder window will open. Open the WHSE_QTY object, click on the Options menu item from the menu bar, and then click on the Duplicate button.
The Duplicate window will open. Select the Excel Report option for the New List Type field and then click on the Duplicate button as shown in the following screenshot:
Now, launch Excel Report Builder by following this navigation: Microsoft Dynamics...