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
Được trao cho:
20 freelancer đang chào giá trung bình $112 cho công việc này
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