In the realm of business data analysis and reporting, Jet Reports has become a go-to solution for organizations seeking powerful reporting tools. In this blog post, we will highlight WebSan Inc.'s top 10 recommended Jet Reports from our financial package, based on our expert opinions and customer feedback. 1. Company Overview: The Compa...

Register for the final webinar in the 8-part manufacturing series. Business Central has many built-in reports available that cater to the manufacturing industry. It’s also capable of connecting data into Power BI which can be displayed on an interactive dashboard. Register for the webinar to learn more about:

● Variance Analysis for Production Orders
● Status of Released Production Orders
● Capacity Utilization and Availability
● Power BI Production Dashboard

Date: Wednesday September 25, 2019
Time: 2:00 PM - 3:00 PM EST

Click Here to Sign Up for the Webinar Today!

Happy Canada Day!

For those enjoying a little R&R today, imagine this was your every day!  To get achieve that, you would need to start building some automation into your business processes.  The first step you can take is by ensuring your reporting is easily & readily available.

Homepage Metrics offer out-of-the-box reporting that covers all GP modules.  There exists an extensive list of potential reports one can use.  These are automatically integrated to ones Homepage for easy & quick viewing.

Try adding some Metrics to your Homepage today by selecting the pencil icon / edit button on the Metrics heading.

Management Reporter 2012 for Microsoft Dynamics has been released & is now available for use.  Management Reporter is a robust financial reporting tool that provides companies visibility into organizational health.  Management Reporter is available for the following Microsoft Dynamics products:

• AX 2009 & 2012
• GP 2010
• NAV 2009
• SL 2011

Upgrades include greater design flexibility, the ability to collaborates with co-workers, enhanced drill-down capabilities & a more interactive viewing experience.

Contact This email address is being protected from spambots. You need JavaScript enabled to view it. to upgrade today!

For some of the more technical Microsoft Dynamics GP users, you may want a little more control and customization when reporting on your GP data.  SmartLists provide a fairly quick and dynamic option to custom reporting, but they may not be visually satisfying.  On the other hand, integrating BI360 with GP will allow you create very clean and organized reports in an Excel-like environment, but won’t give you that rudimentary control that your technical mind may crave.  If you’re looking for some sort of middle ground between these two options, take a look at SQL Server Reporting Services (SSRS) for Dynamics GP.

The key to creating effective SSRS reports is having a good knowledge of SQL – or at the very least, a fairly strong knowledge of databases.  This is what scares away some users, but for those that have this type of background, SSRS Reports could be your salvation in the pursuit of both visually appealing and fully customizable reports.

While SSRS Reports can be easily viewed within Dynamics GP, they are created in Microsoft Report Builder – a separate software program that is offered for free by Microsoft.  Using Report Builder allows you to take a custom SQL query that you have created (either from scratch or by using Report Builder’s intuitive Query Designer) and turn it into an appealing report.  With the ability to easily create tables, charts, and even visual scales/gauges, you can turn a simple list of data into a work of art!

If you have SSRS Reports deployed in your GP environment, you can view them by going into any series and selecting the “Reporting Services Reports” item in the Navigation Pane.

[caption id="attachment_674" align="aligncenter" width="300" caption="SSRS Reports in Dynamics GP"][/caption]

A lesser-known method for reporting on your Microsoft Dynamics GP data is through Solver’s BI360.  BI360 is an Excel-based business intelligence tool that offers out-of-the-box integration with Dynamics GP for reporting, budgeting, and dashboards.  It offers several key benefits to users:

• Familiar Environment – BI360 is an Excel add-on, which means all of your reporting is designed and displayed in the same Excel environment that you are already accustomed to.
• Simple Design – No SQL knowledge is required to design your own report or budget in BI360.  It’s a simple drag-and-drop interface that allows almost anyone in your organization to develop customized and effective reports quickly.
• Integration – BI360 automatically integrates with your Microsoft Dynamics GP environment and pulls data from GP in real-time when generating reports, so you never have to worry about synchronization.
• Easy Distribution – not only does BI360 give you an easy and effective medium to design and view custom reports, but also allows you to easily distribute static versions of your reports to non-BI360 users.

In a nutshell, BI360 is a simple tool that provides powerful Dynamics GP reporting in a familiar environment – what more do you need?

By: Rahim Jiwani, Application Specialist, WebSan Solutions Inc.