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.
I’m in the process of finishing up a data conversion from Lawson to Dynamics NAV 2016. The last piece to figure out are 1099 balances from checks issued before we converted. (We only converted open AP Items, so we don’t have the history necessary to calculate 1099s at year end.) I’ve looked around the web and found a variety of incorrect and partial answers. Many solutions have a lot of discussion about invoices and credits. But I think I’ve found a much simpler way of doing this. While...Read more
Dimensions are a wonderful feature of NAV. However, when doing General Ledger analysis, sometimes clients just want to dump everything into Excel and “play” with it—especially if they use Analysis Views. And to do this, clients want to see all dimensions, at the detail level, for each transaction. But here’s the challenge: You can only view or filter two dimensions directly on the General Ledger entries page. Fortunately, there’s a way around this restriction. How to See All Dimensions for NAV...Read more
Since most of my clients have switched to Dynamics NAV (many of them from Lawson), I’ve been busy writing a bunch of SSRS reports that facilitate specific finance and accounting functions my clients require. Here are the reports I’ve completed thus far: Using Totaling Accounts with SQL in Dynamics NAV AR Revaluation Report – Dynamics NAV RapidStart – A Query to Check Your Errors. I have more reports in the works. If you’d like my complete package of free SSRS reports for Dynamics NAV when...Read more