Author: Barry Crowell

Wow! A Dynamics GP Multi-Company Financial Dashboard: Part II

Back in September of 2015, I posted a blog about how to modify Jared Hall’s awesome Excel Financial Dashboard that you can download. The problem

February 28, 2017

Power BI – New Features and Need for Big Data Functionality

With January’s Power BI update, two items that I was looking forward to have been released. The first one was the public preview of email

February 8, 2017

Power BI Visuals in SSRS 2016 Web Site

Yesterday, January 17, 2017, Microsoft released the Power BI reports in SQL Server Reporting Services (SSRS) technical preview. I downloaded the technical preview and installed it

January 18, 2017

Dynamic Security – additional thoughts

Introduction Recently I posted a blog titled “How to implement Analysis Services Dynamic Security based on Microsoft CRM User Access Rights.” That post talked about

November 29, 2016

How to implement Analysis Services Dynamic Security based on Microsoft CRM user access rights.

Introduction In Analysis Services implementations, there is always a demand for implementing security. In this post, I’ll describe a dynamic or attribute security solution in

November 22, 2016

How to Solve Dynamics GP Problem with High-Resolution Displays

With the advent of newer technology using high-resolution displays, this has led to a lot of Dynamics GP end-users complaining about eyestrain or un-readability of

October 3, 2016

How to create Dynamics GP SmartList Workflow Reporting

Recently, I completed a GP 2015 R2 upgrade with Workflow setup for General Ledger, vendor and check batch approval. Microsoft has made changes to the

September 22, 2016

What Happened to All of My GP OLE Notes?

During the migration of OLE Notes to the GP 2013 and above, to the document attach functionality, not all OLE Notes will get migrated through

June 16, 2016

Get Your Self-Service On!

Do you need to make an immediate or occasional one-time backup of your Dynamics GP databases, or maybe run a SQL job that populates your BI360 Data Warehouse? Occasionally, you may be performing some month-end closing procedures, post a large, significant batch, or perhaps you are about to integrate a large amount of your Dynamics GP data into your BI360 Data Warehouse. It’s critical that you make a good set of database backups to use in recovery in case of a failure, in order to refresh your Dynamics GP data into your Data Warehouse without IT involvement. There are several ways you can create a one-time backup or run other SQL jobs, like refreshing your Data Warehouse for month-end reporting. Here are some easiest ways, with some of the tools most people are familiar with:

May 11, 2016

The Two Power Players – Power BI and CRM

At the 11th Annual KTL User Conference, I will be presenting a session on Power BI and Dynamics CRM data. The main goal is to give users an easy way to present information in a timely and simple-to-understand format. In the session, using Power BI, we will cover the process of building and accessing refreshable dashboards with information from Dynamics CRM and Dynamics GP. In the session we will discuss/demo the following:

April 27, 2016