Inventory app with multiple warehouses

[dessie_moonsamy]

Hi All,

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.

Step 1
Customer places an order for stock. I don’t want them to choose which warehouse they want the stock from.

Step 2
Head Office receives the order and approves the order.

Step 3
Head office need to allocate stock from a warehouse or from multiple warehouses.

Step 4
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

thank you
Dessie