PC Access Ltd
Solve Database Problems, Booking System and export to Sage
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Solve Database Problems & Booking System
Resolve software issues, custom booking system and export to Sage
Based in the Isle of Man, Centigrade Ltd provide a comprehensive repair service for domestic appliances. They cover a full range of appliances from every manufacturer, and have Official Service Partner status for all the major brands.
Key Services
- Solving Database Problems
- Appointment Booking Systems
- Sage Integration
- Job Management
- Invoicing and Billing Systems
- Custom Access Databases
- Contact Management and CRM
- Access Database Upgrades
The Problem
Our client had an existing in-house developed database that was used to track appliance repairs. Although the existing database could manage much of their business, it was not able to support more complex monitoring and billing requirements for their business.
The most urgent database problem to solve was the underlying data structure of his existing system. Our client had a number of ideas for enhancements to the system but needed a more robust data model in order to do this.
Job management was not straightforward. Several visits to a customer's premises may be required, and manufacturers might need to be consulted for technical information. In addition, parts and spares may need to be ordered before the job can be completed and billed.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Our client had a manual booking system for engineers. It was not easy either to see the current allocation of engineers, or to record the time spent on jobs.
The billing process was complicated due to the nature of the parties involved. For instance, the final cost of the job may have to be split between the end consumer, the original product manufacturer and/or the extended warranty insurance company. In addition, parts and labour need to be accounted for separately.
There was an additional requirement for the export to Sage of invoice information. This was not straightforward as different elements of the invoices (such as parts and labour) had to be allocated to different Sage accounts.
The Solution
We re-engineered the data model to more accurately reflect the system requirements. With the underlying database problems solved, this now forms a more solid platform upon which new features can be built.
An improved job management system now includes an active service jobs dashboard. This shows the status of all jobs with their priority. This links to an improved job detail area which brings together the customer, product, timesheet and billing information in a single place.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
The custom booking system incorporates a booking form showing upcoming scheduled engineers' appointments in a consolidated diary view. This can also be used to navigate quickly to current engineer time and job sheets.
The billing section was re-written to streamline the generation of invoices. This now accurately calculates charges relevant to the customer, manufacturer and/or the warranty insurer. This also tracks the cost of parts, with charges allocated to the correct party.
Finally, with the improved data model it was possible to incorporate a customised export module to produce and export data to Sage Accounts. This includes the correct nominal codes for the relevant invoice charges.
Testimonial
Having used several Access Database developers over the years I was fortunate enough to come across Tony and PC Access.
His work has been by far the best, from understanding the requirements, to delivery on time and with a system that works. There have been lots of complex configurations that have saved a lot of man hours and allowed me to understand my business much better.
I wouldn’t hesitate to use his services again should the need arise
William Erani, Centigrade Ltd
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills