One of the Largest County Councils in England.
Due to the implementation of PSe, a new HR and payroll system, all statutory forms (P11, P45, P60, etc), Payslips and Management Reports required rewriting. Report development requires an analytical mind as inevitably you end up performing “final quality inspection” and validation over and prior data take on.
This customer had some requests that proved ‘too resource hungry’ for Impromptu and SQL, and integration to Gandlake’s Laserserve. We provided the solution to these problems with some small utility programs written in Borland Delphi in combination with SQL Stored procedures.
With the payslips via Impromptu, on a pay group of 9000 + payslips, was taking in excess of nine hours to run. Our solution reduced this to less than 10 minutes.
High in volumes of audit data prohibited processing via the application and was not to be in a format suitable for reporting on. By using Borland Delphi, Stored procedures and two new tables we normalised the data and were able to process the data very quickly. If auditing is required from the data take on period then high volumes would be expected, this is also a high risk period where an audit trail could prove useful.
Some work on SQL views to enable easier Impromptu reporting for BVPI (Best Value Performance Indicator) which are used for national statistics.
Undoubtedly our multi skills and understanding of the customer requirements helped in providing acceptable solutions.
A Building Maintenance Contractor.
A typical case for report writing, “the data is in there somewhere”. Reports have been requested and provided for:-
- Jobs completed but not invoiced.
- Aged jobs not invoiced.
- Jobs at different value bands.
- Jobs by customer.
- Spend per item with supplier and with price variance per item.
Most reports of this nature that analyse either sales or purchasing should pay for themselves and help to tune your company. In this case jobs were invoiced quicker and suppliers were rationalised, giving lower procurement costs and greater purchasing power with suppliers.
Application and utility solutions.
An application that reads formatted e-mails received from one of their customers and feeds the data directly into an order entry system. This saved a high volume of keying and kept the system up to date. An application to allocate the cost of items booked out from stock to a job. We are in the progress of writing a stock and purchasing system.
