Have you ever been frustrated by trying to find the “right” report in Microsoft Dynamics NAV (Navision)? Are you tired of spending days, often weeks, learning yet another report writing tool that ends up being too complicated or cumbersome? Do you love Excel? Well, if you answered “Yes” to any of these questions, take a look at Jet Reports.
Jet Essentials is an Excel add-in which allows you to connect to your Microsoft Dynamics NAV database in real-time to create reports or query information. If you’re looking for a quick ad-hoc report, let’s say item number and quantity on hand, it’s only a few clicks away in Excel to retrieve that data. And, once the report is generated, you can drill down in the spreadsheet to access the NAV details behind the value. In my opinion, using just this one feature in Jet could save hours a week. Imagine not having to spend your valuable time looking for that just right report.
If your requirements are more complex, utilizing Jet Essentials report wizard allows you to create reports with multiple filters, options, fields, and more without having to be a report expert. Any of these reports can be emailed automatically daily, weekly or monthly. And, any report can be distributed to non-Jet Reports users. Plus, Jet provides the ability to connect to any data source, allowing you to query and report information from multiple databases that don’t have to be NAV. This is especially helpful if a company has multiple software systems with the need to provide one, consolidated report.
The best part is if you’re running NAV 2009 or greater, you already own Jet Express, which is now bundled with the product. It offers ad hoc reporting and drill down functionality. If you find it’s not enough, upgrading to Jet Essentials would provide the more advanced features described above. With either product, I believe you’ll find it to be straight-forward and easy to use.