O'Reilly logo

Building Dashboards with Microsoft Dynamics GP 2016 - Second Edition by Mark Polino, Belinda Allen

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

Chapter 2. The Ultimate GP to Excel Tool – Refreshable Excel Reports

The easiest method of getting data out of GP into Excel is with Excel refreshable reports. These were introduced in GP version 10 and provide users with the ability to open an existing report which is connected to GP already. To get the latest data from GP you only need to use the Excel refresh button. What could be better. These work very similarly to SmartList as the data is sorted in the same way and almost all default SmartList objects have a corresponding Excel refreshable report.

Refreshable Excel reports are easy to deploy, easy to update, and easy to work with. That's why they make a great foundation for an Excel 2016 dashboard. In this chapter, you will learn how to: ...

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