You will need multiple lists:
1. that stores all the information about items on the warehouse (article_nr, barcode, saldo, location, arival_date, last_counting_date, etc.... - depends on complexity of information this can be an either single list or multiple related lists)
2. list that store information about users (user_id, user_name, etc....)
3. history list that stores information about actions performed by users (user_id, operation_date, operation_type, barcode)
4. suppliers list (supp_id, supp_name, etc...)
5. deliveries list (inv_nr, supp_id, eta_date, etc....)
6 .... it all really depends on how many things You want to track and automatize.
@VincentGiovanni wrote:
- The plan is that the Warehouse staff will add stock value when deliveries arrive, in short, they search for the products article number, the gallery will display the item, and thereafter go into edit mode and add the quantity arrived, then save.
Make dropdown to select article, than scan barcodes into colection, show scanned barcodes in gallery with option to edit their saldo, than transfer collection into sharepoint list.
Or if you have data about upcoming deliveries it can be even easier for end point users:
Make dropdown to select upcoming delivery, show data in gallery and transfer information about delivery into proper lists ...
Really there is a lot of possibilities to do this ... a lot depends on what You already have in place and how advanced You want it to do.
