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
Ironbark Steel$37,995
Arndell Building Supplies$20,300
Prestons Trade Centre$15,790
Northwest Electrical$15,295
Marsden Park Supplies$13,300
Metal Fabrication Co$12,320
Deliveries by suburb
Prestons2
Smithfield2
Blacktown2
Wetherill Park2
Silverwater2
Penrith2
Warehouse board
Awaiting stock4
SO-8805
Halstead Fasteners
SO-8809
Ironbark Steel
SO-8812
Girraween Engineering
SO-8820
Penrith Plumbing Co
Picking7
SO-8801
Prestons Trade Centre
SO-8804
Metal Fabrication Co
SO-8808
Ingleburn Plumbing Co
SO-8813
Moorebank Steel
SO-8816
Northwest Electrical
+2 more
1Dispatched7
SO-8802
Smithfield Plumbing Co
SO-8806
Penrith Trade Centre
SO-8810
Villawood Pipe & Valve
SO-8814
Seven Hills Plumbing
SO-8817
Halstead Fasteners
+2 more
2Delivered7
SO-8803
Blacktown Pipe & Valve
SO-8807
Northwest Electrical
SO-8811
Arndell Building Supplies
SO-8815
Erskine Trade Centre
SO-8818
Prestons Trade Centre
+2 more
3Top products by value
RHS 75x75x3$54,320
Galvanised purlin C15019$46,935
TPS cable 2.5mm 100m$22,610
Treated pine 90x45$16,080
PVC pressure pipe 100mm$13,426
Brass ball valve 20mm$12,610
Copper tube 15mm$12,150
M12 galv bolt pack$10,120
Order flow
Awaiting stock25100%
Picking-42184%
Dispatched-71456%
Delivered-7728%
Order value by month
Delivery run sheet
Grouped by suburb in the real product
| Order No | Customer | Suburb | Product | Qty | Value | Status |
|---|---|---|---|---|---|---|
| SO-8801 | Prestons Trade Centre | Prestons | Galvanised purlin C15019 | 120 | $8,940 | Picking |
| SO-8802 | Smithfield Plumbing Co | Smithfield | PVC pressure pipe 100mm | 300 | $4,110 | Dispatched |
| SO-8803 | Blacktown Pipe & Valve | Blacktown | Copper tube 15mm | 450 | $6,075 | Delivered |
| SO-8804 | Metal Fabrication Co | Wetherill Park | RHS 75x75x3 | 88 | $12,320 | Picking |
| SO-8805 | Halstead Fasteners | Silverwater | M12 galv bolt pack | 1500 | $3,450 | Awaiting stock |
| SO-8806 | Penrith Trade Centre | 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 | Ingleburn Plumbing Co | Ingleburn | Brass ball valve 20mm | 220 | $2,860 | Picking |
| SO-8809 | Ironbark Steel | Chullora | Galvanised purlin C15019 | 200 | $14,900 | Awaiting stock |
| SO-8810 | Villawood Pipe & Valve | 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 |
Showing 12 of 25 rows