In this guide 6 sections
Keep one sales order open and issue a delivery note for each trip. Show the balance quantity on the order. Tie every return to its trip, and raise invoices from delivery notes. The invoice then matches what the site received.
Start with one order and many trips
A contractor orders two hundred lengths of GI pipe, a carton of unions and forty bags of cement, to be supplied as the slab work proceeds. You send a truck on Monday, another on Thursday and a third the week after.
Treat that as one sales order with three deliveries. Do not raise three orders. One order, three draw-downs.
The order carries the agreed rates and total quantity, and each trip draws it down. Commercial terms stay in one place, while the physical movement is recorded in another, trip by trip and truck by truck. The salesman quotes once, and the yard fulfils over weeks.
Step one is a delivery note for every trip
Raise the delivery note before the vehicle leaves the yard, listing items, quantities, vehicle number, driver and the site contact. The store keeper signs it. The driver carries a duplicate for the site engineer to countersign, with the truck registration pencilled beside the signature. That signed copy proves what was unloaded and who received it, which protects the driver as much as the yard.
Number the notes in sequence. The stores manager can then reconcile the day’s dispatches with the gate register in a few minutes, instead of hunting through loose slips at closing time.
No stock leaves without a note. Every note ties to an open order. The gate guard checks both.
- Order number and line reference
- Vehicle, driver and dispatch time
- Quantity sent per line
- Signed copy returned from the site
Step two shows the balance where the salesman looks
The site engineer phones to ask how much is still coming. The salesman should answer from the order screen, which shows ordered, delivered, returned and balance for every line, rather than walking across to the store.
Add a flag for lines past their promised date. One missing elbow can stall a whole bathroom. The plumber waits. The site loses a day. Someone in your office should hear about it before the engineer calls.
Where stock is short, deliver part of that line and keep the remainder open. Never close the order just to hide a gap that the buyer will notice on site the next morning when the mason asks where the rest is.
Step three ties each return to its trip
Returns come back on a later truck or a hired pickup, perhaps a box of reducers sent in error or a cracked cistern rejected by the engineer. Record each against the delivery note it left on. A sealed carton of fittings goes back to the shelf, while a chipped basin goes to the damaged bin and out of saleable stock.
A loose credit hides the link. Nobody knows whether it belongs to the first trip or the third. The site’s count never matches yours. The invoice dispute starts.
Check that quantity returned never exceeds quantity delivered on that trip. Then record a reason: damaged, wrong size, excess or rejected.
- Original delivery note number
- Reason code for the return
- Condition and restock decision
- Credit note linked to the trip
Step four raises the invoice from delivery notes
Invoice from delivered quantities net of returns, not from the order. Some suppliers invoice every trip, while others bill monthly across several notes and attach a covering list. Either way, the invoice must name the notes it covers.
Close the order only at zero balance, or when someone with authority cancels the remainder and gives a reason that is written on the order.
This week, pick one open order with three or more trips and check that delivered, returned and billed quantities agree line by line.
Part supply order tracker
A sheet with the order header on top and a grid below. Rows are order lines. Columns show ordered quantity, then trip one, trip two and trip three delivered, returned per trip, balance, promised date and invoice number. A side block lists delivery note numbers, vehicles and the names of those who signed at site, so any dispute can be traced to a person.
Open a blank worksheet to printQuestions owners ask
Should each trip have its own invoice?
It can, or one invoice can cover several delivery notes. Choose by what the buyer’s accounts team can reconcile. List the note numbers on every invoice either way.
What if the site rejects goods after they were invoiced?
Raise a credit note linked to the delivery note. Restock or write off the goods by condition, and adjust the balance on the order so the salesman sees the true figure.
How do we stop the balance quantity going stale?
Update it from delivery notes only, never by hand. When every dispatch needs a note, the balance reflects what physically left the yard. Staff stop trusting memory.
Can a salesman change the order midway?
Yes, with a revision that keeps the old lines visible. Quantities already delivered stay fixed. The revision applies only to what remains on the balance.