When updating At Your Service – Repair Centre to the latest version, you may come across the above error. This article will help you resolve the issue and upgrade your SQL Server database to the latest version.
Specific MySQL server permissions are necessary for AYS users to access the data and run reports. Some additional permissions may be necessary for those that administer the AYS database on the server. This article will assist you in configuring the security on MySQL for both of these cases.
A quick guide to getting started with Repair Center
The software consists of a single database containing records organised into modules. The ones you will most likely need to look at first are “Customers”, Repair Orders”, and “Inventory”.
Each module opens as a browse window. Here you can view, hide or sort the columns, click on each column to sort the records, or filter the records by entering data in the filter line (top row). Each column can be renamed to suit your business, although some have special meaning, e.g. Make/Model/Serial Number are used to uniquely identify items, but you can rename them, as perhaps serial number could be IMEI or ESN.
You can begin a new Repair Order in three ways:
- Open the Customer Module, select a customer, then click on New RO.
- Open the Repair Order module, click on New RO, then select the customer from a drop down list, or leave it as the default “miscellaneous” if you don’t need to create an account.
- Open the Warranty Module, select an existing record and select New RO. This is used if the customer has previous history and has either a warranty or a product registration with you.
The Repair Order module allows you to progress from initial order, receipt, evaluation, estimate, and repair, through to billing. There are default’Repair Statusses’ in the demo, but you can customize these to suit your process.
Vendors can be set up as third party repair shops, or as warranty providers for billing purposes. Any repair can be billed to the customer, a third party, or split between them.
While the main program interface is only available in English, a number of features in the AYS program can be configured for communicating with French-speaking customers and vendors.