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


Jet Reports vs SSRS for Dynamics NAV

For the past few months, I’ve been spending a lot of time creating reports with both Jet Reports and SSRS, mostly with Dynamics NAV and a little with Dynamics GP. If you’re a NAV customer, you have some version of Jet included with your purchase. Like all folks with SQL server databases, Dynamics folks use SQL Server and therefore have access to SSRS. So which is better? Or rather, what works best in any given situation? In considering this question, let’s focus neither on regular reporting...Read more

Dynamics NAV Dimensions: Part 3—Dimension Combinations

In my last post, I went into some detail about default dimensions in NAV and options for value posting. I also showed how the system reports posting errors when values don’t match the choices made in default dimensions. Fortunately, you can work around this by controlling how your dimensions post, using dimension combinations. I’m going to give you an error example first and then explain why it happened (and how you might be able to fix it). As in my precious posts, I’ll use the standard...Read more

Dynamics NAV Dimensions: Part 2—Moving Between Systems

In my last post, I went over NAV dimensions setup, using sales invoices for my examples. I also mentioned how dimensions can be assigned to many, many different kinds of data in NAV. In this post, I’ll go over how dimension values work with different setups. Again, all my examples use the CRONUS USA sample company. Dimensions—Assigning Default Values to Master Data Let’s start with “Items.” Items don’t have default dimensions assigned in CRONUS USA, so we can look at how to set them up....Read more