This organisation uses a combination of some VBA programs in Excel and the A2E functions to make rapid and simple enquiries into the large stock database held in Accredo Saturn. The ease of use of the application allows users to get the exact data required to answer customer requests without having to open or learn Accredo.
The Freshpork Development has evolved over a number of years which shows the flexibility and power of VBA applications (Excel). The application has grown and changed as the company has experienced significant growth and it is now showing the true value of the software with the smooth and efficient running of the business. The Excel application is tightly integrated with the Exchequer Enterprise accounting system using the COM objects provided by Exchequer.
The main module in the development for Foleys is the Scheduling system. The first part of the scheduling takes information collected from the customer's phone call and creates a Job and if necessary a new Customer record in Accredo. The schedule program extracts any unscheduled jobs in Accredo and allows them to be placed into a daily schedule using a drag and drop feature. Job cards are printed for the day or by individual jobs. Colour coding is used to show suburbs to make for efficient scheduling of the tradesmen.
The scheduled data is automatically sent to the Navman devices in the tradesman's van, and as the job status is updated by the tradesman, it also updates the job status in the Excel scheduler.