Category: Business Intelligence

Business Intelligence

Not Your Daddy’s Financials Webinar Series

  Join Microsoft MVP Belinda Allen as she presents alternatives to the traditional cash flow and financial statements using Microsoft Power BI and GP data in this two part Better Financials Webinar Series. Not your Daddy’s Cash Flow Statement One of the first things we all learn in Business 101 is that Cash is needed

Read More
Is Powershell just DOS, or is Belinda Allen crazy?

Belinda Allen tells me that PowerShell is just DOS. I can understand why she would think this, but she is, in fact, crazy. I believe this misunderstanding comes from the colloquial use of the term “DOS Prompt”, which falsely identifies the Command Prompt as DOS. For starters, DOS is a full operating system. While its

Read More
Is Payroll Processing Required to Add Employees to Work Centers in GP Manufacturing?

When setting up work centers in GP Manufacturing it is possible to add employees to a work center and calculate labor according to employee pay rates, even if you don’t own the Payroll Processing module. Employee and Pay Code master records are available as a standard part of GP, and can be linked to work

Read More
Calculate Specific Employee Labor Rates in GP Manufacturing Without Payroll Processing

Payroll Processing is not required in order for Microsoft Dynamics GP Manufacturing to calculate labor according to specific employee pay rates. For WIP to use an employee’s pay rate, the WIP settings need to be correct. In addition, the Pay Code needs to be linked to the Labor Code of the routing sequence, and the

Read More
A Unique and Powerful Quality Management Solution!

If you’re like most companies, your current quality management system is a cumbersome manual processes that involves a vast array of spreadsheets. You’re constantly wrestling with how to collect the many types of data you need – and after that, how to organize the data so that it can be reviewed and communicated effectively. I

Read More
Acumatica 3.0 Professional Services Release Review!

Professional Services employees make up a large demographic of our workforce.  They are architects, engineers, contractors and consultants like me.  We are a highly mobile workforce, often flying to work on projects or working at our client’s offices.  This creates a need for us to be able to manage our work, projects, resources and time

Read More
Highlights of Convergence 2012

The anticipation of my first Convergence had been building up since January.  Convergence is a gathering of Microsoft Dynamics users, partners and ISV’s who come from around the world to crash a city for a few days to learn more about the Microsoft Dynamics family of products and network with fellow business product users.  As

Read More
Issue using CEILING in Microsoft SQL

I ran into an issue while doing some report writing for SQL today. I was trying to round up the quotient of one integer divided by another integer. The result never rounded up. What I found was that I had to convert the dividend to a decimal. See my examples: SELECT Out1 = 300/24, Out2

Read More
Cloud Computing and Mobility Apps The perfect storm of mobile ERP, CRM and BI

Continuing the conversation about Cloud Computing, I ran into this article through a Google Newsfeed this week.  It seems to me and to the author of this post http://www.wired.com/cloudline/2012/03/personal-cloud-2014/ that some companies are not taking Cloud seriously.  Tagging onto my post from a couple of weeks ago, the author agrees with my conclusion that deploying enterprise applications

Read More
The Future of Business Intelligence

Let us explore the future of Business Intelligence.  Last week I spoke about Windows 8 and it’s impact on computing.  However, let’s further explore the problems, yes problems, with Business Intelligence. Until today, Business Intelligence has been primarily provided by Hyperion, Cognos and other solutions.  Many years back, Microsoft introduced Microsoft Analysis Services.  However these

Read More