This project involved the pulling together of over a dozen different Access databases, all of which were being used by relatively experienced users to generate their own datasets and queries. The issue was one of the time all of this took, and also not being confident that data was undamaged, or that the latest datasets were being used.
Management Information for an Ink and Toner Cartridge Recycler
This client recycled cartridges in aid of a range of charities, and had a significant problem in determining how many had been received for each particular charity – it was a heavily manual process, further complicated by the fact that they had just moved the business to SAP Business One – a powerful enterprise system. We were able to build a data warehouse that could be interrogated with relative ease, and the administrative saving was enormous.
We built a shift management system for this client, which replaced manual timesheets, and eliminated the delay in obtaining management information that had previously been caused by the length of time it took to process the data by hand.
Sales Order Processing System
We built a complete sales order processing system for this client, who deals in topsoil and loam. Previously orders were manually processed through a number of different channels and we were able to simplify this process, and bring marketing and sales together into one system, dealing with quotes, orders and supplier purchase orders.
This metal fabricating client had a complex method of manually assembling quotes, often by “gut instinct”. We built a custom quote generator, that allowed them to build items up from the simplest component, and retain total control over the margins generated.