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

ElementPurpose
Delivery connected to orderReconciliation is structural
Quantity deliveredSupports partial deliveries
Delivery evidencePhoto and recipient confirmation
Status on the orderDerived from its deliveries
Customer notificationSent automatically on status change

How to set it up in Jestor

  1. Create a deliveries table in Jestor connected to orders.
  2. Record quantity delivered so partial deliveries are supported.
  3. Add a mobile layout and an attachment field for delivery evidence.
  4. Derive the order's status from the deliveries against it.
  5. 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.

Read more