We are currently using a MsOffice Access database for our company jobs lists and reporting for the last 15 years. We need to replace this system with something more stable for larger amounts of data, which has the following capabilities:
Loading our customers and customer information This need to include prices for each client for different inventory items - pricing only visible for management level users.
Loading our suppliers Including supplier costs (to be able to calculate profit on each job based on charge to client) (Eg. Supplier charges R5000 for transportation of goods to KZN Province, client is billed R7500 -
therefore profit on jobNr 001 is R2500
Job Cards / Authorization lists Each job completed for each client is linked to an authorization or job number - all details pertaining to this job are captured here (each job is linked to a customer as well as which supplier completed this job) - documents need to be able to be scanned in and linked to each completed job
Job status go from "requested" to "in process" to "awaiting docs" to "completed" at which time it would be sent for invoicing.
Various reporting necessary including: client reporting for invoices to be issued
Supplier reporting - to cross check invoices from suppliers
Profit reports (client charges less supplier costs)
Jobs Requested, jobs still in process, jobs awaiting documentation
Please kindly provide any software or platform suggestions which could allow us to develop a type of system which can be used by our main office as well as at our one other branch.
Perhaps something similar to msAccess but more stable and with the ability of being loaded in a web browser to allow for off site capturing etc?