Not a Data entry freelancing work!!!!!
I currently use excel and it's working fine. But need sacalability. Refer to attached excel . I will give some inputs which will become part of database or impact values in database and will need some outputs from database.
Need a VBA software Google sheet or Access or SQL or anything reliable to manage a warehouse.
Below capabilities required:
1. datewise stock in and Stock out. (Lead time and Supplier name) (Mandatory)
2. Excel Entry import or bulk entry of Sale and Purchase. (Mandatory)
3. Pick up list for orders received (Mandatory) (If possible with Rack number in Warehouse).
4. Order item name can be different from item name in WH so may need some mapping.(Mandatory)
5. Internal movement of stock within Warehouse . (great if one can map)
6. report of days of stock left of a particular item in WH.(Mandatory)
7. it needs to take data either by copying excel or by importing table.(check if we are importing correct data or not) (Madatory)
8. mail or load output data to some google sheet or some users (optional)
9. Inputrs should go in bulks with proper checking that no invalid values are used.
10. Should be able to keep track of what is already reordered and what is to be reordered. With reports