Linear Customer Query System Version 1.31
The Customer Query System was custom developed in response to a request from a client who deals with the sales of auto spare parts. The main purpose of the system is to enable the counter salespersons to easily and quickly respond to enquiries from their customers.
When a counter salesperson receives a phone call enquiry from a customer, the customer usually wants to know the price of a certain spare part product. The counter salesperson will then use the system to determine whether the customer had purchased the product in the past. The system will list the last two selling prices for the particular product for that customer, along with other information such as quantity sold, unit price etc. The counter salesperson can then quote a price to the customer based on whether the customer is a frequent purchaser of the product or the customer purchases products in bulk and so on.
The system was requested in order to speed up the response time to enquiries from customers. The counter salespersons no longer need to put their customers on hold for a long time while browsing through past invoice files in order to respond to the enquiry. The client believes that providing such efficient service to their customers would benefit both their customers and the company in the long run.
Among the features of this module are:- setup of Customer
- setup of Brand
- setup of Model
- setup of Stock
- entry of Invoice
- screen enquiry showing
- last 2 selling prices
- reports showing
- listings of Customer, Brand, Model and Stock
- past sales for Customer
- purge old transaction
- verify data integrity
- backup and restore data using compression/decompression utility
- counter for automatic generation of Invoice document numbers
- multi-level password protection