This weeks challenge is to create a set of management accounts to be sent to over 250 managers for their business units from Sage X3.
Budgetary constaints have prevented the use of Sage SEI reporting, or a larger brand reporting suite. The solution? An SQL procedure(s), data extration from accounting database to a reporting database. Reporting will be via SSRS (Microsoft Reporting Services) and Excel VBA emailed workbooks with pivot table datasets.
Luckily, we have some SQL views to base the management accounts baseline from SEI. I’ve had a 2 day SQL course and dabbled a little with SSRS so what the hell, what’s the worst that can happen right?