I am creating an inventory app. I have 1 Main Inventory table - The Inventory table is the total Inventory on hand from 5 different warehouses. Each warehouse has multiple items and the items in 1 warehouse can be similar to items in another warehouse.
Customer places an order for stock. I don’t want them to choose which warehouse they want the stock from.
Head Office receives the order and approves the order.
Head office need to allocate stock from a warehouse or from multiple warehouses.
Customer receives the confirmation of the order being approved and where he must go to collect each item from.
I have setup the tables for each warehouse and the main inventory table
I have set up the order process
I need assistance in setting up the allocation of the stock from the individual warehouse.
please can you provide some guidance