Why a back order list can still leave you searching

A back order report can be accurate and still leave the sales team with a lot of work. It may show every customer waiting for stock, the quantities outstanding and the expected deliveries. When a supplier says a shipment is late, someone still has to work out which customers that affects.

This came up in a recent conversation with a business whose incoming stock was sometimes sold before it arrived. Some shipments took months, with customer orders accumulating against them. The team wanted to start with a particular incoming purchase order and find the customer orders depending on it. A list of all outstanding sales orders left them searching through work that could not move yet.

Starting with the shipment

When a shipment is delayed, the immediate job is to contact the customers relying on it. When it arrives, the job is to find the orders it can fulfil. In both cases, the shipment gives the team a way to narrow the work to the orders affected by that event.

Searching by product only gets part of the way there. Several deliveries may contain the same item, with different customers waiting for each. A delay to the next shipment does not necessarily change the date for someone already waiting for a later one. The team needs to see which incoming quantities are expected to cover which outstanding orders.

An arrival also needs a little more detail than a list of customers who ordered that product. For one order, it may supply the last missing item, allowing the whole order to leave. Another may still be waiting for something else. That distinction tells the team whether they can despatch now or need to discuss a partial delivery.

Starting with the customer

On the phone, the question comes from the other direction. A customer wants to know when they can have an item. The next supplier delivery date is useful only if there is enough in that delivery to cover their order.

Suppose 30 units are due, with 20 promised to one customer and 10 to another. A new customer will need stock from a later shipment unless the business changes those commitments. Showing the next arrival date beside the product can give a misleading impression if the quantities already spoken for are elsewhere.

The business we spoke to sometimes reconsidered those commitments. Stock being held for a customer who was waiting for other items might be used to fulfil another order sooner. That involves a decision about the existing promise. Seeing the waiting orders and the deliveries expected to cover them gives the team the information to make it; a stock total alone does not.

Keeping the connection useful

Those connections need to reflect what has actually happened. If a supplier delivers only part of a shipment, some customer orders will still be waiting. If a customer cancels the undelivered balance, that demand should no longer make incoming stock appear spoken for. An old link between an order and a shipment can be just as unhelpful as having no link at all.

An outstanding-orders list remains useful for seeing the backlog as a whole. But the work often begins with a narrower question: a particular delivery has changed, or a particular customer is asking for a date. Being able to follow the relationship in either direction saves the team having to reconstruct it each time.