Jet Reports Prerequisites and Prebuilt Reports

The Prerequisites for Jet Express are low. If your Microsoft Dynamics GP, office and Operating system are on a supported version then you will be able to run Jet Express. The only item that may need to be completed is verifying .NET Framework 4.5 is installed. Here are the following requirements from Jet Report’s website.

Database: Microsoft Dynamics GP (Version 9.0 and Newer)
Microsoft Office: Microsoft Office 2007, 2010, 2013, 2016, Microsoft Office 365 Desktop Edition
Operating System: Microsoft Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista, Windows Server 2008 through 2012R2
Prerequisites: Microsoft .NET Framework 4.5**
**Microsoft .NET Framework will be installed with Jet Express.

Pre-Built Reports
Another benefit of the link above is the pre-built reports. With Jet Express and Jet Professional, you will receive a list of templates that are ready to be implemented.

Pittsburgh’s Power BI Dashboard in a Day

On March 9, 2018, Microsoft in partnership with Orion Systems Integrators will host another Dashboard in a Day event at its Pittsburgh office.  I encourage anyone interested in learning more about Power BI’s business analytics service to monitor your company’s health to attend this event.

This hands-on event is a built around a demo environment, however, attendees are encouraged to bring their own CSV or excel documents to play and explore with a familiarity.

Here is a link to the registration.

If you are not near Pittsburgh, then I would recommend reaching out to your local Power Bi group to see if they host or can create a similar event.

What is Power BI and why do I need it?

Over the past few months, I have spoken with many customers and discussed Power Bi and how it can benefit their company.   There is always a push back because people do not believe they need the service or they already had a report for that and it seems too complicated.  In retrospect, it seemed complicated because it was a new, unfamiliar way to analyze and filter their company data.  From my perspective, Power BI can be useful for your accountants to your CEOs and everywhere in between.

Instead of long complicated reports, Power Bi creates dashboard snippets of your data that allow you to grab a snapshot of where your company is at that point in time.  For example,  I created power BI template for a that mimics the Payables Aging Summary, as you can see in the screenshot below.  What makes this unique from other reporting solutions, such as Management Reporter, Jet Reports, SSRS, Etc, is that it is interactive.  You can narrow the slicer for the aging bucket to show you the items in only the 1-30 days.  Or you can select a vendor on the left and it will filter all the invoices that create those totals.   It’s a snapshot that is intuitive and does not need an analysis of 10 pages to get the final total.  It connects to the database and updates the data with a simple refresh.


Or you can place the report in the Power Bi Portal and share it within your company or outside your company, based on your payment plan.  There are different ways to access the data.

  1. Desktop: This version allows you to create reports on your desktop and uploads them to the Power Bi Service.  Clients have the option to create reports and storing them in a share.  Then everyone with permissions to the share and the desktop version installed could open the reports and refresh them.  The desktop version of Power BI is free as of February 2018.
  2. Service: Power Bi offers the Power Bi Services which is their online portal. This is where the pricing can become tricky and I would recommend consulting with a Microsoft partner if you have questions.
  • Free/without subscription: You can upload a report to your dashboard within the Power BI Service and access it on your mobile device for free.  This feature limits the ability to share with other users or auto update the report.
  • Office 365 business license:  This is tricky for Office 365 administrators to locate, however once installed it will allow users to share Power BI reports only with users in your company.  When you log in to your Office 365 admin portal you would go to Billing, then Select Subscriptions.  Under the subscriptions select Add subscriptions.  You will look for one that says “Power BI (free).”   You will select your license quantity and this choice will allow you to share Power BI reports within your company.


  • Pro:  There is a paid version of $9.99 a month/ per user, that allows you to share reports, internally and externally.
  • Office 365 Enterprise E5 license: With the Office 365 Enterprise E5 license for office 365 it includes Power BI.  This license is purchased on a per-user basis.
  1. Mobile: When your reports upload to the Power BI service you can download the iPhone or Android app from their respective app stores. Once you sign on via the app, you can open your reports and view from anywhere you have an Internet connection.

With so many options, it can overwhelm for some companies that are still trying to grasp what Power BI is and if it can be useful for making their lives easier.  Several companies may find the Payables Aging Summary useful, while others have no need for this specific data.  It comes down to what our clients need and asking the right questions to determine where their current reporting structures are failing them.  Power BI just provides the tools to see your business in a snapshot without long tedious reports.



The pricing in this post is based on the current cost on their website as of 2/10/2018.  Pricing is subject to Microsoft and can change.  For current information, please review their pricing page.

Here is a link to the Office 365 licensing comparison.


Top Reasons To Love Microsoft Power BI

  1. Direct connection into SQL databases to connect into Microsoft Dynamics GP and also Microsoft Dynamics 365.

This product is designed to work with a variety of data sources.  Including Excel, CSV, XML, Access databases, Microsoft SQL Server, MySQL, etc.  If you have data stored, there is a high chance that Microsoft Power BI will connect to it with little difficulty.  Additionally you can connect multiple data sources into one report.

  1. Access from anywhere

Sharing is caring.  This cloud based solution offers access to anyone you permit at any time of the day and from anywhere.  It has mobile apps on Apple, Android and Windows devices.

  1. Easy to comprehend and create data.

Visual charts and graphs make Power BI useful for all users.  The charts setup is also drag and drop.  Simply select your data and it is there.

  1. Up to 1GB is free

Typically, free users are extremely limited, and in this case they are limited.  However, even with the limitations, users can create dashboards and customized reports.  They can still connect to their data and schedule refreshes.  The cost of $9.99 the paid version offers additional features and flexibility with the software that is not available for the free version, please see their pricing page for more detailed information of the differences.

  1. Designed for the non-technical person.

What you normally see with many reporting systems, is that the person creating the reports has to have hours upon hours of training and trial and error to become competent at creating the reports.  With Microsoft Power BI, they have created a solution that allows the non-technical person to hit the ground running.  Simply install the Power BI Desktop, connect to your data, and start creating.

The pricing in this post is based on the current cost on their website as of 2/6/2017.  Pricing is subject to Microsoft and can change.  For current information, please review their pricing page.

Business Intelligence: When Standard Reporting Is Not Enough

It should be no surprise to anyone that we are living in a digital world and data is being kept on the most mundane items.  Especially in every aspect of a business.  Once a business creates data, it needs to be able put it together in a meaningful, productive way.  Reports once filled this void.  There are many reporting solutions that work with Microsoft Dynamics GP.  Such as Management Reporter, Crystal Reports, Excel Reports, and Jet Reports.  The question becomes, what do you do with the information that you have at your fingertips when that monthly report is not enough?

The next step is Business Intelligence.  Once thought to be a flash in the pan, is now on its way to becoming the standard for driving business decisions for many companies.  As a consultant, I see a constant need to have relevant data and Power Bi create real-time dashboards with your data to make data-driven decisions.  It can connect to wherever you store your information and be made available to you anywhere.  This is the next step to the standard reports and can be used in conjunctions with reporting to drive your business to the next level.

Microsoft has created an extremely powerful tool called Power BI.  Power BI creates dashboards with relevant, constantly updated information that you can have at your fingertips to make business decisions.  You can create a dashboard item for any variety of reasons, such as the current sales for the year, see where your sales are at, or even compare current year sales with past years.



Excel Report Error: “The SELECT permission was denied on the object ‘accounts’, database ‘MLC’, schema ‘dbo.’”


With Microsoft Dynamics GP permissions come from two different types of accounts.  There are local accounts and GP accounts.  Local accounts are setup on a domain in Active Directory.  GP accounts are setup within the GP programs.

The permissions for excel reports pulls from Active Directory and not Microsoft Dynamics GP.  Specifically, it is an active directory account setup in SQL and set DYNGRP and rpt_power_user for it to access the account.

First login to SQL and expand security.  Under the security right click on login and select ‘new login…’.  After you select new login you will be able to see the option to search for a login.  This search will allow you to search in Active Directory.  After you add the new user under the general tab, then select the user mapping.  Under the user mapping, select all the databases that the user should be able to run excel reports in and add the permissions DYNGRP and rpt_power_user.  If you do not want to provide them the rpt_power_user role, then you would be able to select the rpt_%rolename% that best fits your company’s security policy.  This can also be matched to their GP logins permissions.