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 to operate a business. We also learned that being Profitable does not mean you have cash in the bank. Have you ever really looked at the traditional cash flow statement? It’s supposed to provide information about gross receipts and gross payments. Does it really do that? Attend this webinar and see Belinda present alternatives to the traditional cash flow statement and cash flow analysis using Microsoft Power BI and GP data. Learning Objectives Start the process of new ways to visualize the movement of your cash Create a plan that can provide information to your [...]

By | 2018-12-13T21:57:31+00:00 November 7th, 2018|Business Intelligence, Dynamics GP|

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 primary interface uses the command line, it is still a complete operating system. There are even different command line interfaces created for DOS. Applications were written specifically to run within DOS. You cannot write an application to run in PowerShell.The Command Prompt, introduced in Windows 95, is a DOS-like command line interface that simply emulates many of the same commands used in DOS. Once Windows moved to the 32-bit versions, DOS was no longer part of Windows. Granted, you did still have access to a true MS-DOS prompt, but it was simply a self-contained virtual machine [...]

By | 2018-07-18T19:22:06+00:00 August 12th, 2016|Business Intelligence|

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 centers. To assign an employee to a work center: 1. Create the Employee ID in the Employee Maintenance Window. (HR & Payroll >> Cards >> Payroll >> Employee) 2. In the Work Center setup, add the Employee ID and subsequent details for that work center. You can also calculate labor in WIP according to specific Employee's pay rate, rather than using the standard labor cost. The steps for this are outlined at

By | 2018-07-18T11:26:04+00:00 March 4th, 2014|Business Intelligence, Dynamics GP, Njevity|

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 Pay Code must also be linked to the Employee ID. Complete the following steps: 1. Make sure that in WIP setup, the box next to "Always Use Standard Labor Rate" is NOT checked. (Manufacturing >> Setup >> System Defaults >> WIP) 2. Set Up the appropriate Pay Codes (HR & Payroll >> Setup >> Payroll >> Pay Code) 3. Create the Employee ID in the Employee Maintenance Window. (HR & Payroll >> Cards >> Payroll >> Employee) 4. Link the Pay Code to the Employee ID - In the Employee Pay Code Maintenance window, select [...]

By | 2018-07-18T11:26:04+00:00 February 25th, 2014|Business Intelligence, Dynamics GP, Njevity|

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 recently saw a demonstration of a simple, yet powerful solution to the complexities of quality management - and I was really impressed! The software is called Quality Essentials Suite. Things that really stood out to me about this solution: • The interface is extremely user-friendly, and is designed with tablets in mind. • It has the ability to handle multiple types of test data (numbers, Boolean, date and time, pre-defined lists, text, document paths) • Standard documentation and forms are easily created, and just as easily recalled as historical records • Test data can be [...]

By | 2018-07-18T11:26:04+00:00 February 11th, 2014|Business Intelligence, Dynamics GP, Integration, Njevity|

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 from anywhere.  However, most solutions for project management, until today, have been legacy technology with very little mobility built in. Today, Acumatica’s version 3.0 is available.  Acumatica has significantly augmented their application with numerous new features that improve business intelligence, customer processing and most notably Project Accounting.  Project Accounting and its associated capabilities such as time and expense entry, allocation processing, billing and project management are critical functions for someone in a professional services role.  For the professional, mobility is critical.  The typical workday of a professional begins with reviewing the tasks he or she [...]

By | 2018-07-18T11:27:01+00:00 March 23rd, 2012|Business Intelligence, Cloud|

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 a first timer, I was warned that I would be going nonstop from early morning to early morning with a few hours of sleep in between.  That was not far off from the truth and after coming home and having some time to finally sit and reflect on the past five days, I want to share some of my experiences and takeaways from Convergence 2012.  After an already solid two days of GPUG events, meeting up with customers and networking put behind me, Microsoft opened with their keynote Monday morning.  Upon entering the arena, it [...]

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 = CONVERT(DECIMAL(14,2), 300)/24 Out1 Out2 ----------- --------------------------------------- 12 12.500000 SELECT Out1 = CEILING(300/24), Out2 = CEILING(CONVERT(DECIMAL(14,2), 300)/24) Out1 Out2 ----------- --------------------------------------- 12 13

By | 2018-07-18T11:27:01+00:00 March 21st, 2012|Business Intelligence|

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 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 through the Cloud is really the "secret sauce" (my words).  Cloud Computing's core components have been with us for years.  Virtualization, service provider licensing, remote access, .net development platform.  However, it's only been the past few years that we, as a Cloud Computing Industry, have been able to fully deploy the Cloud.  The next evolution of Cloud is "app-ifying" specific components of ERP (Enterprise Resource Planning), CRM (Customer Relationship Management) and BI (Business Intelligence).  We have seen CRM become one of the first applications to app-ify components such as Accounts, Opportunities, Tasks and Activity Management [...]

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 solutions have been either expensive in their software purchase and/or their implementation.  Further complicating things are the differing requirements from the user to the manager to the executive.Therefore, we have seen an emerging trend in business solutions in which we believe you should know about.  They are:Audience -- the audience or consumer of the business intelligence will always be the number one concern in Business Intelligence.  For example, the CEO and CFO will have a varying set of requirements of what they want to see.  The manager of purchasing will want to see something different from [...]