I require an Excel based system for warehousing of stock.
Macro's would be required for entrance and exit of stock, with an area to include details of the exit (ie: date, stock code, customer name and suburb and order number).
Entrance of stock will need an area to add details also (date, stock code, order number, delivery docket number)
I require a reporting system that totals:
-current stock levels for stocktake purposes
-end of month figures of entrances and exits
-ability to filter results by manufacturer
-search option for names and order/delivery docket numbers
-number of days each item has been in warehouse since entrance
-ability to add new products, with a description section allowing for Manufacturer, Quality of Stock, Description.
I have attached a copy of another macro system I have trialled, but am not happy with. I would like more ability to add information, more reporting ability for end of month billing.
By using this copy I have supplied, it should make the task of adding new options very easy. I can supply another spreadsheet I have used in the past, which has
20 freelance font une offre moyenne de $112 pour ce travail
Hi. I am expert for this job. Just have an look my review here. So kindly select me for get 100% satisfied your satisfaction is my success muthumuni
Hello, I have gone through your requirements. As such, I genuinely feel that if you get the project developed in Microsoft Access using VBA, the overlook look and user-friendliness of the software will be better. A Plus
I can design an inventory system for you in Php an Mysql. It is a web base project so you can view it any [url removed, login to view] is more easy to handle than macros
It is good to choose Ms-Access for inventory management but i will make it in 5-6 hours only.
I am currently apprenticing under excel and have a mentor who is willing to aid me if needed to complete a project like this.