software should include :
1- clients database form including : name, type of customer (retail, service, wholesaler, etc...), code (generated as unique for each customer), phone, address, e-mail, other info
2- sales form including : name of client (according to the clients database) (type and code of customer to be shown as read only), quantity (sum of paid quantity and bonus quantity if present), price, total amount due (price x paid quantity), product (choosen from a list), payment method, invoice no., sales representative (that made/delivered the deal), tax calculated as 10 % on total (if needed), etc.....
3- monthly report (read only) showing by quantity of products sold and money : per client, product per month, per sales rep., profit
4- annual report : just as the above point + year to date report (ytd)
5- Taxes to be paid per month according to the sales (sum of all taxes paid by clients duirng each month) (read only)
6- table to enter cost of each product.
7- categorized monthly expenses form.
8- monthly profit calculated (read only) according to cost and expenses and price sold. (total, per client, per product, per sales rep.)
31 freelancers are bidding on average $514 for this job
Dear Sir, We are interested in developing this inventory management system. Do you need it in English or the Arabic? Also we would like to discuss minor details to fully understand the excel sheet.
See my existing applications as a sample. I can do the project for you. http://www.youtube.com/watch?v=nzyx9jEnGUo http://www.youtube.com/watch?v=sc27UF_aAQw