Achieving a Single Source of Truth in Data Management
Founded in 1972, AJ Wells & Sons Ltd is a family-owned British company specializing in the design and manufacture of wood-burning stoves, vitreous enamel products, and the import of fair-trade fireside accessories and pumice chimneys. Over the years, the company has expanded its operations, necessitating a more streamlined approach to data management. To support informed decision-making and detect business trends, AJ Wells identified the need for a unified data reporting system across various sales inputs and financial data. This led to the integration of their existing SYSPRO ERP system with ZAP Data Hub, aiming to achieve a single source of truth for the organization’s data.
Their Business Challenge
Before the integration, AJ Wells struggled with timely and accurate data retrieval due to reliance on manual reporting processes. Different sales executives used varied methods to input information, causing discrepancies between the CRM and accounting systems. These inconsistencies hindered the company’s ability to quickly access financial reports and identify business trends, limiting effective decision-making.
SYSPRO Solution
To address these challenges, AJ Wells upgraded from SYSPRO 6.1 to SYSPRO 8 and integrated it with ZAP Data Hub, a data warehouse automation software. This integration provided a centralized platform for accurate and trusted financial and operational reporting. ZAP Data Hub automated the consolidation of data from various sources, including SYSPRO, Microsoft Dynamics CRM, and Excel, ensuring consistency and reliability.
The Outcome
The integration resulted in consistent, timely, and easily accessible data across the organization. With a unified view of information, AJ Wells improved reporting accuracy and gained deeper insights into business performance. The company could now focus on analyzing data and identifying trends, leading to informed decision-making.
– Rob Holgate, Head of Finance, AJ Wells & Sons Ltd.
