Category: Reporting
-
Microsoft Management Reporter End of Live
Every accountant can verify that reports are a necessary evil. Microsoft Dynamic GP first supplemented its internal reports with FRx. Which was transitioned out to Management Reporter to the relief of the GP world? Even experts, such as Mark Polino have written since 2016 about how it is time to rethink Management Reporter, as seen…
-
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.…
-
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,…
-
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…
-
Top Reasons To Love Microsoft Power BI
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…
-
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. …
-
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…