What is on order, what is short, and what ships today
Your order book, turned into a run sheet the warehouse can actually work from.
Synced fromOrder Book.xlsx25 rows · 4 minutes ago
Open orders
11
Open order value
$91,000
Lines awaiting stock
4
Products below 100 on hand
9
Order book value
$188,251
Units on order
3,918
Top customers by value
Deliveries by suburb
Warehouse board
Awaiting stock4
SO-8805
Sydney Fasteners
SO-8809
Steelforce
SO-8812
Girraween Engineering
SO-8820
Reece Plumbing Penrith
Picking7
SO-8801
Bunnings Trade Prestons
SO-8804
Metal Fabrication Co
SO-8808
Reece Plumbing Ingleburn
SO-8813
Moorebank Steel
SO-8816
Northwest Electrical
+2 more
Dispatched7
SO-8802
Reece Plumbing Smithfield
SO-8806
Bunnings Trade Penrith
SO-8810
Tradelink Villawood
SO-8814
Seven Hills Plumbing
SO-8817
Sydney Fasteners
+2 more
Delivered7
SO-8803
Tradelink Blacktown
SO-8807
Northwest Electrical
SO-8811
Arndell Building Supplies
SO-8815
Erskine Trade Centre
SO-8818
Bunnings Trade Prestons
+2 more
Top products by value
Order flow
Order value by month
Delivery run sheet
Grouped by suburb in the real product
| Order No | Customer | Suburb | Product | Qty | Value | Status |
|---|---|---|---|---|---|---|
| SO-8801 | Bunnings Trade Prestons | Prestons | Galvanised purlin C15019 | 120 | $8,940 | Picking |
| SO-8802 | Reece Plumbing Smithfield | Smithfield | PVC pressure pipe 100mm | 300 | $4,110 | Dispatched |
| SO-8803 | Tradelink Blacktown | Blacktown | Copper tube 15mm | 450 | $6,075 | Delivered |
| SO-8804 | Metal Fabrication Co | Wetherill Park | RHS 75x75x3 | 88 | $12,320 | Picking |
| SO-8805 | Sydney Fasteners | Silverwater | M12 galv bolt pack | 1500 | $3,450 | Awaiting stock |
| SO-8806 | Bunnings Trade Penrith | Penrith | Treated pine 90x45 | 640 | $7,680 | Dispatched |
| SO-8807 | Northwest Electrical | Marsden Park | TPS cable 2.5mm 100m | 40 | $5,320 | Delivered |
| SO-8808 | Reece Plumbing Ingleburn | Ingleburn | Brass ball valve 20mm | 220 | $2,860 | Picking |
| SO-8809 | Steelforce | Chullora | Galvanised purlin C15019 | 200 | $14,900 | Awaiting stock |
| SO-8810 | Tradelink Villawood | Villawood | PVC pressure pipe 100mm | 180 | $2,466 | Dispatched |
| SO-8811 | Arndell Building Supplies | Arndell Park | RHS 75x75x3 | 145 | $20,300 | Delivered |
| SO-8812 | Girraween Engineering | Girraween | M12 galv bolt pack | 900 | $2,070 | Awaiting stock |