Looking for an IT Consulting Company? See How We're Different

Contact Us:

917.848.7284

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

 Integrate
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

RECENT POSTS

SSRS Tip: Put Parameters in Your Query, Not Your Filter

As a SSRS consultant, we’re often asked how to speed up reports. While there are many ways to do it, I would make this the top one: Put parameters in the query, not in the dataset filter, if at all possible. Filtering is not your friend. Repeat after me: Put your parameters in your query, not in your filter. To show you why, let’s look at two reports: one called Parameter in Filter, the other Parameter in Query. Both reports are identical except for one thing—in one report I use a filter on the...Read more

Creating a Summary/Detail Report for Jet Reports and Dynamics NAV

One weakness of NAV Account Schedules is its inability to specify a range of accounts (or a totaling account) and then give details on the fly. Unfortunately, when my client went to their first Jet consultant with this issue (thinking that Jet Reports could do better), they got the same answer. If you want to see detail, the consultant said, you have to enter EVERY account you want to see. (Which is something of a maintenance nightmare.) Further, it just isn’t true. In today’s post, I’ll show...Read more

Converting 1099 Balances in Dynamics NAV

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