I have an excel spreadsheet with inventory product listings. This sheet may have listings for the same product number in numerous warehouse locations.
When a product is delivered and a current location is full, the product is entered on a new row on the sheet with its description and new location and count at that location.
The project is to create an access database linked to this spreadsheet so the excel sheet can be searched and reports created. Specifically, I want to create pick lists from orders that come in every day..Product numbers will be entered on a form to search for all the locations in all warehouses for that product, and the inventory count at each location. These found locations will be sent to a "pick list". The next item will be searched for locations, and the results sent to the pick list and appended to the first search list. The operator will repeat this until a complete list is created with all the items to be picked with all their respective locations. An "amount to be picked" field will be provided for each product so that a quantity to be picked can be entered.
Then, this list(report) can be printed out. The warehouse worker will use this list to locate and pick amounts required for each item.
Warehouse worker will have the option to correct the count at each location should he find it is incorrect.
A "Pick List Tab is included in this attached excel, but it does not work reliably. I think it is beyond fixing. The sheet to link will be tab "Consolidated"
27 pekerja bebas membida secara purata $2262 untuk pekerjaan ini
Hello sir, i read your requirements very-well and ready to start work from now. Hope you will give me a chance to do work with you, waiting for your reply, Thank you
Hello! I have 8 years experience in programming and know Excel and Access well. I can make this project for you. Everything will be done according to your requirements.
Hello, I can develop your application. I'm a Freelance With 10 Years of Experience In Developing Applications On Ms Access For Small, Medium And Large Companies For Public And Private Sector.