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.
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
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
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