Looking for an IT Consulting Company? See How We're Different

Contact Us:


Red Three helps clients maximize the power of their current enterprise software to improve business intelligence. We specialize in enabling companies to get more from their current software without the hassle of long, drawn out “consulting” practices.

Unlike many independent consulting companies, our deep knowledge of accounting data, experience in multiple packages and practical, organized approach solves complex data and reporting needs. Our goal is to help you extract the right information from your financial systems and get the reports you need to make smarter business decisions from the software you’ve already invested in.

Improve Business Intelligence


Organize, clean up and report on data in multiple systems to make smarter decisions. 


Learn More

ERP Systems


Integrate ERP systems to improve back office issues and focus on growing a successful company.


Learn More

Reduce Reliance on IT Consulting


Clean up internal IT processes to reduce the need for ongoing consulting.


Learn More

Leverage Microsoft Technologies


Maximize the power of your current platforms to get the reports you need from the systems you already have.


Learn More
7 Steps to Better Financial Reporting
7 Keys to Cost Effective Business Intelligence


Dynamics NAV Dimensions: Part 1—Setup

Dimensions in Dynamics NAV are powerful tools. They’re also a little confusing to use. Which isn’t a good combination. With great power comes great responsibility. In a series of posts, I’ll dive into the topic of NAV dimensions to help you navigate their choppy waters. In today’s post I’ll show you how to set up NAV dimensions. Let’s start by defining what NAV dimensions are, exactly. Simply put, we can define dimensions in two ways: A dimension is part of the accounting information you can...Read more

RapidStart – A Query to Check Your Errors

RapidStart Services is a useful tool to load data into Microsoft Dynamics NAV. You can use it not only for initial setup but also for mass updates. (Theoretically, you can also use it for regular interfaces, but I think there are better options.) But as much as RapidStart is useful, it does have one major flaw: it has no comprehensive error report. To solve this problem, I’ve developed a query for it. (If you want a copy, scroll down to the bottom of this post.)  In this post, I’ll walk...Read more

Using SSRS with Dynamics NAV—Creating Views to Write SSRS Queries

Our consultants write hundreds of SSRS reports each year. Now that we’re working with Dynamics NAV, we want to use our SSRS and SQL skills without having to train everyone in the intricacies of C/AL development. While C/AL uses SSRS to render reports, we only see value in going native C/AL when reports are tied to database updates or are a key part of a process—such as test reports or posting printouts. As I covered in Understanding the NAV Database, one of the challenges in working with NAV is...Read more