Established in 1976, our client has become a leading branded manufacturer and supplier to the UK electrical Wholesaler and electrical Contractors markets for commercial lighting, emergency lighting and fire safety systems.
Their knowledge, strength of service and attention to detail have earned them multiple accreditations from the industries regulatory and trade bodies with ample affiliations as well as BSI accreditation.
ABM has been working with this client since 2008; looking after the company IT and telecoms infrasture as well as one-off, bespoke development solutions and internal financial reports.
Our clients requirement
Our client manually produces daily / weekly / monthly financial reviews from their supplied financial package. They are unable to produce the data in one step, in the format they require. The ideal solution is to be able to produce the full dataset from within the current package.
Our proposed solution
ABM met with accounts management to determine the overall requirements and layout, provide recommendations through technical specification with fixed timescales and costs. These were to provide a Crystal Report that would output all of the required data, in the specified layout, from within the currently supplied accounting solution. The client should be able to select and produce an extract based on any user selected date range, automatically producing the extract in Excel format. The report was to be made portable across any database from within the package across the client farm.
The introduction of this extract allowed the accounts staff to generate automatic, accurate reports without the need to manually create multiple reports to achieve the same results ensuring time saved and overall increased department efficiencies.