I need help setting up the following process in the system:
I want to first receive items into a main warehouse, then transfer them to a sub-warehouse.
When I create a sales order, I want the system to deduct the items from the sub-warehouse, not the main one.
Also, when I check the stock balance, I want the system to show the balance per warehouse.
Increase/Decrease in Qty in warehouses happens when DeliveryNotes/GoodsReceipts (or at invoice level) are created not on sales order level. Sales Order just increase Qty reserved which has nothing to do with warehouse.
You need to create new locations in the settings. Upon purchases of new stocks, you can set the default form to receive them in the main warehouse.
Use inventory transfer to move them to different location.
Lastly, use the inventory quantity by location under reports for your monitoring.