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


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

Jet Reports for Dynamics NAV—Sign Reserving and Totaling

In my previous post, I covered the topic of using accounting periods instead of dates in Jet Reports. In this post, I’m going to tackle another problem that often comes up with Jet, especially when regular report writers try to write financial reports for the first time. The problem relates to sign reversing and totaling. The Problem of Sign Reversing To understand this problem, let’s start with a basic financial report written over the fictional Cronus company sample database. To keep the...Read more

Jet Reports for Dynamics NAV—Using Accounting Periods Instead of Dates

It’s pretty easy to get basic financial statements out of Jet Reports. And to help even further, Jet has many videos available that explain its terminology and functions to new users. But sometimes, you just want to solve a particular reporting challenge without digging into all the details. Therefore, I’m putting together a series of posts with a few simple tips that make Jet Reports easier to work with. So far, I’m planning to write these posts: How to deal with 4-4-5 calendars Sign reversal...Read more