Model warehouses the way goods actually move, record every transfer with goods in transit, and let orders reserve stock from the right place.
Why a second warehouse changes everything
With one warehouse, stock is a single number per item. With two or more, every question gets harder. Where is the stock? Is the stock in the other city available for this order? Has the transfer left yet? Who owns the goods in the truck?
Businesses often handle a second location with a separate spreadsheet or a separate copy of their accounting software. That works until the first time a customer is told an item is out of stock while it sits in the other warehouse.
Model warehouses the way goods move
In Sundial, warehouses form a tree. A company can have several physical sites, and each site can be split into the locations that matter for operations. A typical structure might be:
- A main warehouse with separate stores for finished goods, raw material and rejected stock.
- A work-in-progress location on the shop floor for material issued to production.
- A regional depot or branch store.
- A goods-in-transit location for stock that has left one site and not yet arrived at another.
Resist the urge to create a location for every rack. Warehouses should reflect decisions you make: what is sellable, what is quarantined, what is consumed, what is on the road. Bin-level detail can come later if you need it.
One view of stock across locations
Because every warehouse posts to the same stock ledger, an item's stock can be seen by location or in total on one screen. For each warehouse, you can see more than the quantity on hand:
- Reserved or ordered: quantity committed to open sales orders.
- Incoming: quantity on open purchase orders and planned production.
- Projected: what will be left once open orders and receipts are completed.
Projected quantity is the number most people actually need. A warehouse can show forty on hand and still be short if forty-five are promised to customers.
Transfers that do not lose stock
Stock moving between warehouses is where multi-site businesses most often lose track. A transfer recorded only on arrival leaves goods invisible for the days they are on the road. A transfer recorded only on dispatch shows goods arriving before they have.
The reliable approach is a two-step transfer:
- The sending warehouse issues a material transfer from its store to the goods-in-transit location when the truck leaves.
- The receiving warehouse records the receipt from goods-in-transit into its store when the truck arrives, noting any shortage or damage.
At any moment, the transit location shows exactly what is on the road. Anything that sits there too long is a question to ask the transporter, not a mystery for the auditor.
Requests for transfers can start as material requests from the receiving site, so the sending warehouse works from a list rather than from phone calls.
Fulfill orders from the right place
When a sales order is created, it names a warehouse for each line. Set sensible defaults by customer territory or item, so orders from the south default to the southern depot. When the default location is short, the order screen shows stock at other warehouses, so the salesperson or the warehouse planner can decide whether to ship from elsewhere or transfer first.
Pick lists then guide the warehouse team to the right location, and delivery trips group deliveries going in the same direction. Each delivery note reduces stock at the warehouse it shipped from, so the numbers stay correct by location.
Accounting by location
With perpetual inventory, each warehouse can be linked to its own stock account, so the balance sheet shows stock value by site and the accounts always agree with the stock ledger. Cost centers let you see the running cost of each location, including rent, staff and freight, alongside the stock it holds.
That makes a useful question easy to answer: is each warehouse earning its place?
Rules worth agreeing early
- Who is allowed to create transfers out of each warehouse, and who confirms receipts.
- Whether negative stock is allowed. In most businesses it should not be.
- How long goods may stay in transit before someone investigates.
- Which locations are sellable and which are not, so quarantined or rejected stock never shows as available.
We are designing Sundial so an AI agent can suggest rebalancing transfers between warehouses based on open orders and projected stock, with a planner approving each one. To try a multi-warehouse setup on sample data, try the demo.





