Legacy ERP Modernisation: Sage 200 Upgrade Across a 36-Store Retail Operation

M.I. Dicksons Ltd, a well-established North East retailer operating across 36 stores and employing 300 people, had accumulated significant technical debt around its Sage 200 ERP platform. The business had been running an ageing, heavily customised version of Sage 200 that had grown increasingly unstable, difficult to maintain, and disconnected from the wider technology stack. Customisations built up over many years had made upgrades prohibitively complex, creating a vicious cycle where the cost of change continued to grow while system reliability declined. Month-end financial processes were slow and error-prone, integration between Sage and the wider business systems was fragile, and the finance and operations teams lacked the real-time data visibility needed to make timely commercial decisions. The total cost of maintaining the legacy estate had become a material drag on the business, and the risk of a critical system failure across peak trading periods was a growing concern for the board.

Appointed as Fractional CIO with a mandate to stabilise, modernise, and future-proof the technology estate. The Sage 200 programme was identified as the foundational workstream — without a stable, current ERP platform, the broader digital roadmap could not be delivered. The first phase involved a thorough audit of the existing Sage 200 environment: cataloguing all legacy customisations, identifying which were genuinely business-critical, and establishing a clean upgrade path to the latest version. A structured decommissioning plan was produced for redundant customisations and integrations, replacing bespoke workarounds with native Sage 200 functionality wherever possible. The upgrade was planned and executed in phases to avoid disruption to trading operations, with parallel-run testing conducted across key financial processes prior to go-live. Post-upgrade, the clean Sage 200 environment was integrated with Power BI to deliver real-time financial and operational dashboards — giving the finance team and senior leadership the data visibility that had previously required significant manual effort. Legacy third-party software that had been propped up alongside Sage was systematically decommissioned as part of the programme, removing ongoing licence costs and maintenance overhead.