There are a few tools available but the one I would give serious thought to would be to use Info-Explorer from Orchid Systems.
What is it?
Info-Explorer is a versatile, intuitive tool providing affordable Business Intelligence, with features normally only available to very large companies. Employ it just for its analysis power, or to prepare detailed budgets and forecasts, from within the same tool.
Consider combining with Orchid Optional Tables to store budget data, and with Orchid Process Scheduler to automate data refresh and distribution of information.
Gain in-depth insight into your true business performance, using current data. Explore many views from within a single cube, rather than relying on multiple reports. Change dimensions (e.g. product, customer, region, period, employee) for clearer insight, and identify trends or exceptions. Drill through to data entry screens for full detail, or keep it high level.
BUDGETING & FORECASTING
Prepare budgets and forecasts quickly and easily. Review and refine your projections, combining multi-dimensional analysis with instant roll-up/consolidation. Control which fields to use, and how they are presented. Save changes back to your cubes, and optionally to the Sage 300 database (or other database) using the Info-Explorer Writeback feature.