O'Reilly logo

Developing Microsoft Dynamics GP Business Applications by Leslie Vail

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Excel Report Builder

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required