Customers often utilize Microsoft® Excel® in order to filter, subtotal and generally reformat data from Microsoft Dynamics GP in a method that works best for their role.

 

Microsoft Dynamics GP Release 10.0 ships with a set of data connections and Microsoft® Excel® reports. Microsoft Dynamics GP and Microsoft Office provide an integration method, called an Office Data Connection (ODC) that allows you to view Microsoft Dynamics GP data in an Excel worksheet. These data connections match the data found in SmartList objects. Excel reports are built using the data connections and the fields found in SmartLists. This offers users an Excel based alternative to SmartLists.

 

Because of this, these Excel reports are refreshable each time a user opens the file so the latest data is always available within the spreadsheet. During the setup process, the system administrator can deploy data connections and Excel reports to defined locations. Typically these data connections and reports are stored on the server.

 

The Reporting Tools Setup window allows a system administrator to set up integration with external reporting tools. Setup for SQL Reporting Services has also moved to this window to provide a single setup point for all external reporting tools.