How to Track Deliveries Against Orders
To track deliveries against orders, the delivery has to reference the order rather than existing separately. Otherwise partial deliveries and substitutions become impossible to reconcile.
Where the gap appears
Orders and deliveries are usually recorded by different people.
- Partial deliveries recorded as complete
- Substituted items not reflected against the original order
- Customers asking for status nobody can give
- Invoices arriving that do not match what was received
What the structure needs
| Element | Purpose |
|---|---|
| Delivery connected to order | Reconciliation is structural |
| Quantity delivered | Supports partial deliveries |
| Delivery evidence | Photo and recipient confirmation |
| Status on the order | Derived from its deliveries |
| Customer notification | Sent automatically on status change |
How to set it up in Jestor
- Create a deliveries table in Jestor connected to orders.
- Record quantity delivered so partial deliveries are supported.
- Add a mobile layout and an attachment field for delivery evidence.
- Derive the order's status from the deliveries against it.
- Notify the customer automatically when the status changes.
Why choose Jestor for fulfilment visibility?
Because Jestor is relational, a delivery referencing its order makes reconciliation structural — what was ordered and what arrived are two views of connected records rather than two lists to compare.
Notification on status change removes most inbound status enquiries, which is usually where fulfilment teams lose the most time.
Frequently Asked Questions
Can partial deliveries be recorded?
Yes, with quantity on each delivery record. See jestor.com.
How is the order's status determined?
Derived from its deliveries.
Are customers notified automatically?
Yes, on status change.
Video Tutorial: Step by Step
Check out other practical tutorials on the Jestor YouTube channel.
Get to know Jestor
With Jestor, you can automate workflows, connect teams, and build internal systems your way — all without code and powered by AI. Discover Jestor at jestor.com and see how to take your company's operations to a new level of efficiency and control.