We have a small-to-medium company, using Sage50.  Several big issues: at present our departmental managers and directors don't get to see any financial information until after our month-end, so we need real-time reporting e.g. an info.dashboard. We have a complex departmental structure and the standard Sage reports apparently can't produce monthly P&Ls for each department. We do all our budgeting and comparing budgets to results on Excel, with data extracted from Sage

What do we need?  Do we need another version of Sage, or something like sage2sql that links to Sage in real time?