A Free Tool for Dynamics GP That Microsoft Excel Users Will Love

Visit Website View Our Posts

In my experience, people who use Microsoft Dynamics LOVE Microsoft Excel. (This applies to people considering using Microsoft Dynamics GP too.) Excel tools for Microsoft Dynamics GP are always popular but we just found out about a new one that is FREE. Hard to believe but true.

Jet Express, a new self-service reporting solution from Jet Reports, is now available for Microsoft Dynamics GP for FREE. (I have to repeat that since it is so amazing). Using Jet Express, business users can create reports in minutes, with no advanced programming skills required.

  • Jet Express pulls information directly into Excel from Microsoft Dynamics GP.
  • Data in your reports can be refreshed with the click of a button, so you always have up-to-the-minute information.
  • You can combine data from any table, view or field that you have access to in Microsoft Dynamics GP and pull this directly into Excel. Then using standard Excel features like PivotTables, charting and custom styles, you can create smart and compelling reports. And with the click of a button, the data in your report is quickly refreshed.

Here is a quick video overview

Trouble viewing video? Try https://bit.ly/XbCHDi

When asked to test it out, Amber Bell, Training and Implementation Specialist at CAL Business Solutions was immediately excited. (She loves Excel). Amber did a little research on using a feature she hadn’t tried before - Adding “Slicers” to Pivot Tables. It was easy for her to do this with the free “Data Connections” or with any report created with Excel Report Builder.

The Jet Express tool would allow additional data from other tables to be added to your report. The out of the box “Data Connections” from Microsoft can do some pretty powerful reports, but once you start, you will ask “Can I add____?” and now with Jet Express, you can create these reports without purchasing SmartList Builder.

The report below was done without any add-ons. Amber thinks Jet Express would be good for people that want more complicated Dashboards without buying SmartList Builder.( Although she is passionate about the value of SmartList Builder too). But since the cost of SmartList Builder for Dynamics GP 2013 is $2000 (including Excel Report Builder, Drill Down Builder & Navigation List Builder) vs FREE for JetExpress – a strong argument can be made.jetreport1

Here is a helpful “How to Add Slicer” article: https://blogs.office.com/b/microsoft-excel/archive/2012/10/24/slicers-on-tables.aspx


Also another important formatting feature that you will want to use off this menu is the “Move Pivot table” it will give you room to show the slicers.

The Dynamics NAV version of this tool was wildly successful so Jet Reports is doing it again. Look for Jet Reports at Convergence 2013 or visit their website to download Jet Express. Note: The Jet Report GP tool will be officially launched at Convergence 2013 March 18-21. After Convergence download it at: https://jetexpressforgp.jetreports.com/en/index.php

If you want to learn more about why Dynamics GP is the best ERP system to use with your beloved Microsoft Excel, contact CAL Business Solutions sales@calszone.com

by Anya Ciecierski, CAL Business Solutions, www.calszone.com

1 thought on “A Free Tool for Dynamics GP That Microsoft Excel Users Will Love”

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Show Buttons
Hide Buttons