ultramel1987
Well-Known Member
- Joined
- Dec 31, 2010
- Messages
- 193
- Reaction score
- 0
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:
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?
- 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
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?
