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


Month End Closing in Dynamics NAV

If you know anything about NAV, you know it doesn’t really have a hard month end close. So, apologies for the somewhat misleading title of this post. However, month end close remains a topic for discussion for folks switching to Dynamics NAV from other systems (like Lawson) that have a more traditional, hard period end. Consequently, clients will ask for my advice on how to implement some level of period end control in NAV. (Yes, NAV does have a year-end process. But I’ll save that topic for...Read more

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