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.
Integrate ERP systems to improve back office issues and focus on growing a successful company.
Reduce Reliance on IT Consulting
Clean up internal IT processes to reduce the need for ongoing consulting.
Leverage Microsoft Technologies
Maximize the power of your current platforms to get the reports you need from the systems you already have.
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
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
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