New BI Tools to Use with Microsoft Dynamics GP

Tuesday, August 18, 2009 by Jenny Lowry

• Easily import and modify with SmartList Builder
• Set-up to publish to SmartList under the Additional SmartLists
• Very similar to (if not exactly like) the default Favorites in SmartLists
• Very similar to the Data Connections that already exist with Dynamics 10.0 SP2 but are using GP tables

Download the SmartList templates from CustomerSource by going to Downloads & Updates – Reports Library – Microsoft Dynamics GP – SmartList Templates.

Support policy for modifications to SmartList Builder and Excel Report Builder in Microsoft Dynamics GP

Did you know that Microsoft Dynamics GP 10.0 contains more than 200 Office Excel 2007 reports with refreshable data that you can generate and modify quickly?

Now there’s a new add-in for Excel, Chart Advisor, that generates various charts for you based on the properties of your data.  Chart Advisor ranks the recommendations based on their charts scores and displays them in a new dialog.

You can then modify the chart, filter your data, and select the types of data you want to display.

When you’re finished, simply click “Insert” to insert the chart into your worksheet!

To learn more about Ohio Microsoft BI and Microsoft Dynamics solutions, please visit our website or contact us today!