Odoo Process X-Ray · order-to-cash

Beanline Trading (fictional)

What really happened to every sales order between 1 Sep 2025 – 31 Aug 2026, reconstructed from Odoo's own change history. The company and its data are fictional, generated to demonstrate the tool.

Sales orders analysed
560
1 Sep 2025 – 31 Aug 2026
Quotations confirmed
81%
453 of 560
Order to cash (median)
31.0 days
90% within 57.7 days
Orders with at least one problem
46%
207 orders, 9 kinds of problem

Key findings

Problems that are both frequent and concentrated somewhere specific, so there is something concrete to fix. Click one to jump to its details.

  1. Changed after the customer confirmed: 75 orders (17%), 80% of them handled by Tom Peeters.
  2. Warsaw DC ships late-week orders days later: orders confirmed on Thu and Fri take up to 2.3 days to ship instead of 1.0 days (55 orders).
  3. Paid more than two weeks after the due date: 54 orders (13%), 98% of them from Restauracja Odra, Coworking Praga, Hotel Nad Wisłą and 2 more.
  4. Invoiced before the goods shipped: 49 orders (11%), 100% of them shipped from Warsaw DC.
  5. Shipped more than 3 working days after confirmation: 35 orders (8%), 54% of them containing Espresso Machine Pro.
  6. Needed a credit note: 29 orders (7%), 86% of them shipped from Warsaw DC.
  7. Delivery date pushed back twice or more: 14 orders (3%), 100% of them containing Espresso Machine Pro.
1

Changed after the customer confirmed

75 of 453 confirmed orders (17%).

80% of them are orders handled by Tom Peeters, which make up only 28% of confirmed orders: 48% of those orders are affected, against 17% on average.

Share of confirmed orders affected, by salesperson
average 17%Tom Peeters48% (60/126)Kasia Nowak7% (7/106)Piotr Zieliński6% (5/89)Sophie Lambert2% (3/132)

Why it matters

Every change after confirmation means rework downstream, and a risk that the customer gets a different price or quantity than what they agreed to.

What to do in Odoo

Sales > Settings > Lock Confirmed Sales makes confirmed orders read-only, so a change needs a deliberate unlock. Then ask why these orders change: missing information at quotation time, or price corrections?

Show the 75 orders
OrderCustomerSalespersonWarehouse
S00002Bistro Flagey CornerTom PeetersBrussels DC
S00026Lunchbar KouterSophie LambertBrussels DC
S00029Business Park DiegemTom PeetersBrussels DC
S00031Hotel Horizon NamurTom PeetersBrussels DC
S00034Office Hub LeuvenTom PeetersBrussels DC
S00046Bakkerij ZuidTom PeetersBrussels DC
S00048Office Hub LeuvenTom PeetersBrussels DC
S00050Café Nowa HutaKasia NowakWarsaw DC
S00052Brasserie du CanalTom PeetersBrussels DC
S00054Bistro Flagey CornerTom PeetersBrussels DC
S00056Kantine NoordTom PeetersBrussels DC
S00064Kawiarnia RynekKasia NowakWarsaw DC
S00086Café Sint-PietersTom PeetersBrussels DC
S00091Koffiebar MeirTom PeetersBrussels DC
S00095Kantine NoordTom PeetersBrussels DC
S00097Hotel Nad WisłąKasia NowakWarsaw DC
S00098Lunchbar KouterSophie LambertBrussels DC
S00113Biurowiec MokotowskaKasia NowakWarsaw DC
S00134Office Hub LeuvenTom PeetersBrussels DC
S00152Stołówka PolitechnikaPiotr ZielińskiWarsaw DC
S00156Hotel LindenhofTom PeetersBrussels DC
S00157Business Park DiegemTom PeetersBrussels DC
S00160Bistro Flagey CornerTom PeetersBrussels DC
S00167Campus Kitchen LouvainTom PeetersBrussels DC
S00170Lunchbar KouterTom PeetersBrussels DC
S00172Tearoom DuinenTom PeetersBrussels DC
S00173Co-Work IxellesTom PeetersBrussels DC
S00179Café ParvisTom PeetersBrussels DC
S00188Piekarnia ŻoliborzKasia NowakWarsaw DC
S00189Hotel Atelier BrugesTom PeetersBrussels DC
S00194Co-Work IxellesTom PeetersBrussels DC
S00201Biurowiec MokotowskaPiotr ZielińskiWarsaw DC
S00210Co-Work IxellesTom PeetersBrussels DC
S00216Bakkerij ZuidTom PeetersBrussels DC
S00219Koffiebar MeirTom PeetersBrussels DC
S00222Office Hub LeuvenTom PeetersBrussels DC
S00233Tearoom DuinenTom PeetersBrussels DC
S00237Brasserie du CanalTom PeetersBrussels DC
S00259Office Hub LeuvenTom PeetersBrussels DC
S00288Hotel LindenhofTom PeetersBrussels DC
S00290Kawiarnia MokotówPiotr ZielińskiWarsaw DC
S00295Espresso Point WavreTom PeetersBrussels DC
S00298Hotel Horizon NamurTom PeetersBrussels DC
S00299Hotel Horizon NamurTom PeetersBrussels DC
S00300Biurowiec MokotowskaPiotr ZielińskiWarsaw DC
S00318Café Sint-PietersTom PeetersBrussels DC
S00322Café Sint-PietersTom PeetersBrussels DC
S00326Koffiebar MeirSophie LambertBrussels DC
S00327Hotel Tatry ViewKasia NowakWarsaw DC
S00334Tearoom DuinenTom PeetersBrussels DC
S00359Tearoom DuinenTom PeetersBrussels DC
S00375Café Sint-PietersTom PeetersBrussels DC
S00385Office Hub LeuvenTom PeetersBrussels DC
S00404Business Park DiegemTom PeetersBrussels DC
S00408Hotel Horizon NamurTom PeetersBrussels DC
S00410Bistro Flagey CornerTom PeetersBrussels DC
S00423Hotel LindenhofTom PeetersBrussels DC
S00429Café des Arts MonsTom PeetersBrussels DC
S00432Campus Kitchen LouvainTom PeetersBrussels DC
S00445Café ParvisTom PeetersBrussels DC
S00464Office Hub LeuvenTom PeetersBrussels DC
S00475Hotel Horizon NamurTom PeetersBrussels DC
S00480Bistro Flagey CornerTom PeetersBrussels DC
S00483Brasserie du CanalTom PeetersBrussels DC
S00495Hotel Atelier BrugesTom PeetersBrussels DC
S00498Co-Work IxellesTom PeetersBrussels DC
S00505Station Coffee MechelenTom PeetersBrussels DC
S00512Café ParvisTom PeetersBrussels DC
S00535Kawiarnia OgródPiotr ZielińskiWarsaw DC
S00537Hotel Horizon NamurTom PeetersBrussels DC
S00539Café des Arts MonsTom PeetersBrussels DC
S00543Hotel LindenhofTom PeetersBrussels DC
S00545Office Hub LeuvenTom PeetersBrussels DC
S00549Kawiarnia RynekKasia NowakWarsaw DC
S00553Koffiebar MeirTom PeetersBrussels DC
2

Warsaw DC ships late-week orders days later

Orders confirmed on Thu and Fri wait up to 2.3 days (working days) before shipping from Warsaw DC, against 1.0 days on its fastest days.

55 orders were affected over the period.

Median working days from confirmation to shipment at Warsaw DC, by the day the order was confirmed
fastest days: 1.0 dMon1.0 d (53 orders)Tue1.1 d (35 orders)Wed1.0 d (47 orders)Thu2.0 d (27 orders)Fri2.3 d (28 orders)

Why it matters

The delay is not spread evenly: it depends on the day the order comes in, which points to capacity or planning at the end of the week rather than to the products.

What to do in Odoo

Check staffing and picking capacity at the end of the week. Inventory > Settings > Batch, Wave & Cluster Transfers helps a team clear a backlog, and a clear same-week cut-off time sets honest expectations.

3

Paid more than two weeks after the due date

54 of 404 paid orders (13%).

98% of them are orders from Restauracja Odra, Coworking Praga, Hotel Nad Wisłą, Brasserie du Canal and Salon Mosan, which make up only 13% of paid orders: 98% of those orders are affected, against 13% on average.

Share of paid orders affected, by customer
average 13%Brasserie du Canal100% (10/10)Coworking Praga100% (13/13)Restauracja Odra100% (14/14)Salon Mosan100% (5/5)Hotel Nad Wisłą92% (11/12)Kawiarnia Rynek8% (1/13)Bakkerij Zuid0% (0/12)

Why it matters

Late payment costs working capital. It is usually concentrated on a few customers.

What to do in Odoo

Enable Accounting > Settings > Sales Credit Limit for these customers, send payment reminders before the due date (follow-up reports in Odoo Enterprise), and consider shorter payment terms.

Show the 54 orders
OrderCustomerSalespersonWarehouse
S00003Coworking PragaKasia NowakWarsaw DC
S00009Hotel Nad WisłąPiotr ZielińskiWarsaw DC
S00011Kawiarnia RynekPiotr ZielińskiWarsaw DC
S00014Coworking PragaPiotr ZielińskiWarsaw DC
S00015Restauracja OdraKasia NowakWarsaw DC
S00019Restauracja OdraKasia NowakWarsaw DC
S00023Restauracja OdraKasia NowakWarsaw DC
S00025Salon MosanTom PeetersBrussels DC
S00043Coworking PragaKasia NowakWarsaw DC
S00055Hotel Nad WisłąKasia NowakWarsaw DC
S00076Hotel Nad WisłąPiotr ZielińskiWarsaw DC
S00080Restauracja OdraPiotr ZielińskiWarsaw DC
S00083Restauracja OdraKasia NowakWarsaw DC
S00088Restauracja OdraKasia NowakWarsaw DC
S00097Hotel Nad WisłąKasia NowakWarsaw DC
S00099Hotel Nad WisłąPiotr ZielińskiWarsaw DC
S00105Coworking PragaPiotr ZielińskiWarsaw DC
S00108Coworking PragaPiotr ZielińskiWarsaw DC
S00115Hotel Nad WisłąKasia NowakWarsaw DC
S00127Restauracja OdraPiotr ZielińskiWarsaw DC
S00129Hotel Nad WisłąKasia NowakWarsaw DC
S00154Brasserie du CanalSophie LambertBrussels DC
S00155Restauracja OdraPiotr ZielińskiWarsaw DC
S00166Coworking PragaKasia NowakWarsaw DC
S00187Brasserie du CanalSophie LambertBrussels DC
S00190Brasserie du CanalSophie LambertBrussels DC
S00202Brasserie du CanalSophie LambertBrussels DC
S00232Restauracja OdraKasia NowakWarsaw DC
S00237Brasserie du CanalTom PeetersBrussels DC
S00250Hotel Nad WisłąPiotr ZielińskiWarsaw DC
S00255Brasserie du CanalSophie LambertBrussels DC
S00267Coworking PragaPiotr ZielińskiWarsaw DC
S00274Coworking PragaPiotr ZielińskiWarsaw DC
S00276Hotel Nad WisłąPiotr ZielińskiWarsaw DC
S00286Coworking PragaKasia NowakWarsaw DC
S00297Salon MosanSophie LambertBrussels DC
S00303Brasserie du CanalSophie LambertBrussels DC
S00316Restauracja OdraPiotr ZielińskiWarsaw DC
S00337Restauracja OdraKasia NowakWarsaw DC
S00349Coworking PragaPiotr ZielińskiWarsaw DC
S00366Restauracja OdraKasia NowakWarsaw DC
S00377Coworking PragaKasia NowakWarsaw DC
S00380Hotel Nad WisłąKasia NowakWarsaw DC
S00394Restauracja OdraPiotr ZielińskiWarsaw DC
S00395Brasserie du CanalSophie LambertBrussels DC
S00396Coworking PragaPiotr ZielińskiWarsaw DC
S00407Salon MosanTom PeetersBrussels DC
S00414Brasserie du CanalSophie LambertBrussels DC
S00416Restauracja OdraPiotr ZielińskiWarsaw DC
S00441Hotel Nad WisłąPiotr ZielińskiWarsaw DC
S00451Salon MosanSophie LambertBrussels DC
S00462Brasserie du CanalSophie LambertBrussels DC
S00485Coworking PragaPiotr ZielińskiWarsaw DC
S00511Salon MosanSophie LambertBrussels DC
4

Invoiced before the goods shipped

49 of 441 invoiced and shipped orders (11%).

100% of them are orders shipped from Warsaw DC, which make up only 43% of invoiced and shipped orders: 26% of those orders are affected, against 11% on average.

Share of invoiced and shipped orders affected, by warehouse
average 11%Warsaw DC26% (49/190)Brussels DC0% (0/251)

Why it matters

Invoicing what hasn't shipped yet leads to disputes and credit notes whenever the delivery changes.

What to do in Odoo

Set the Invoicing Policy to 'Delivered quantities' (Sales > Settings, or per product) so invoices only contain what has actually shipped.

Show the 49 orders
OrderCustomerSalespersonWarehouse
S00037Cukiernia Stare MiastoKasia NowakWarsaw DC
S00042Kawiarnia OgródKasia NowakWarsaw DC
S00063Hotel Poznań ParkKasia NowakWarsaw DC
S00072Kawiarnia RynekPiotr ZielińskiWarsaw DC
S00097Hotel Nad WisłąKasia NowakWarsaw DC
S00108Coworking PragaPiotr ZielińskiWarsaw DC
S00116Stołówka PolitechnikaKasia NowakWarsaw DC
S00122Piekarnia ŻoliborzKasia NowakWarsaw DC
S00131Bistro KazimierzPiotr ZielińskiWarsaw DC
S00142Stołówka PolitechnikaKasia NowakWarsaw DC
S00174Biurowiec MokotowskaPiotr ZielińskiWarsaw DC
S00177Kawiarnia Sopot MoloKasia NowakWarsaw DC
S00183Kawiarnia OgródKasia NowakWarsaw DC
S00199Kawiarnia OgródPiotr ZielińskiWarsaw DC
S00201Biurowiec MokotowskaPiotr ZielińskiWarsaw DC
S00204Bistro KazimierzKasia NowakWarsaw DC
S00206Kawiarnia Sopot MoloKasia NowakWarsaw DC
S00215Café Nowa HutaPiotr ZielińskiWarsaw DC
S00220Piekarnia ŻoliborzKasia NowakWarsaw DC
S00242Hotel Poznań ParkKasia NowakWarsaw DC
S00251Piekarnia ŻoliborzPiotr ZielińskiWarsaw DC
S00266Café Nowa HutaKasia NowakWarsaw DC
S00267Coworking PragaPiotr ZielińskiWarsaw DC
S00286Coworking PragaKasia NowakWarsaw DC
S00290Kawiarnia MokotówPiotr ZielińskiWarsaw DC
S00296Café Nowa HutaKasia NowakWarsaw DC
S00301Kawiarnia MokotówKasia NowakWarsaw DC
S00312Café Nowa HutaKasia NowakWarsaw DC
S00330Piekarnia ŻoliborzKasia NowakWarsaw DC
S00337Restauracja OdraKasia NowakWarsaw DC
S00365Kawiarnia OgródKasia NowakWarsaw DC
S00366Restauracja OdraKasia NowakWarsaw DC
S00396Coworking PragaPiotr ZielińskiWarsaw DC
S00397Stołówka PolitechnikaKasia NowakWarsaw DC
S00399Biurowiec MokotowskaPiotr ZielińskiWarsaw DC
S00420Kawiarnia Sopot MoloKasia NowakWarsaw DC
S00430Cukiernia Stare MiastoKasia NowakWarsaw DC
S00435Piekarnia ŻoliborzKasia NowakWarsaw DC
S00441Hotel Nad WisłąPiotr ZielińskiWarsaw DC
S00442Hotel Tatry ViewKasia NowakWarsaw DC
S00477Piekarnia ŻoliborzPiotr ZielińskiWarsaw DC
S00485Coworking PragaPiotr ZielińskiWarsaw DC
S00499Restauracja OdraPiotr ZielińskiWarsaw DC
S00519Bistro KazimierzPiotr ZielińskiWarsaw DC
S00542Biuro Centrum WolaPiotr ZielińskiWarsaw DC
S00546Kawiarnia Sopot MoloKasia NowakWarsaw DC
S00548Cukiernia Stare MiastoPiotr ZielińskiWarsaw DC
S00556Cukiernia Stare MiastoPiotr ZielińskiWarsaw DC
S00559Bistro KazimierzKasia NowakWarsaw DC
5

Shipped more than 3 working days after confirmation

35 of 441 shipped orders (8%).

54% of them are orders containing Espresso Machine Pro, which make up only 5% of shipped orders: 79% of those orders are affected, against 8% on average. Also concentrated in orders confirmed on Thu and Fri (54% of the problem, 29% of the orders).

Share of shipped orders affected, by product
average 8%Espresso Machine Pro79% (19/24)Paper Cups 12oz x100012% (7/60)Barista Apron11% (2/19)Decaf Colombia Beans 1kg10% (4/39)Coffee Grinder Compact10% (2/20)Espresso Beans Ethiopia 1…10% (8/82)Oat Milk Barista 12x1L7% (5/71)

Why it matters

Slow shipping delays the invoice (and therefore the cash) and frustrates customers.

What to do in Odoo

Compare picking capacity by warehouse and weekday. Inventory > Settings > Batch, Wave & Cluster Transfers helps a team clear a backlog faster.

Show the 35 orders
OrderCustomerSalespersonWarehouse
S00043Coworking PragaKasia NowakWarsaw DC
S00046Bakkerij ZuidTom PeetersBrussels DC
S00055Hotel Nad WisłąKasia NowakWarsaw DC
S00064Kawiarnia RynekKasia NowakWarsaw DC
S00099Hotel Nad WisłąPiotr ZielińskiWarsaw DC
S00131Bistro KazimierzPiotr ZielińskiWarsaw DC
S00155Restauracja OdraPiotr ZielińskiWarsaw DC
S00177Kawiarnia Sopot MoloKasia NowakWarsaw DC
S00220Piekarnia ŻoliborzKasia NowakWarsaw DC
S00241Business Park DiegemSophie LambertBrussels DC
S00247Hotel Poznań ParkPiotr ZielińskiWarsaw DC
S00261Bistro KazimierzPiotr ZielińskiWarsaw DC
S00287Hotel Atelier BrugesTom PeetersBrussels DC
S00290Kawiarnia MokotówPiotr ZielińskiWarsaw DC
S00296Café Nowa HutaKasia NowakWarsaw DC
S00297Salon MosanSophie LambertBrussels DC
S00302Cukiernia Stare MiastoPiotr ZielińskiWarsaw DC
S00316Restauracja OdraPiotr ZielińskiWarsaw DC
S00328Hotel Tatry ViewKasia NowakWarsaw DC
S00334Tearoom DuinenTom PeetersBrussels DC
S00359Tearoom DuinenTom PeetersBrussels DC
S00365Kawiarnia OgródKasia NowakWarsaw DC
S00375Café Sint-PietersTom PeetersBrussels DC
S00393Tearoom DuinenTom PeetersBrussels DC
S00394Restauracja OdraPiotr ZielińskiWarsaw DC
S00415Café Nowa HutaKasia NowakWarsaw DC
S00425Espresso Point WavreSophie LambertBrussels DC
S00440Hotel Poznań ParkKasia NowakWarsaw DC
S00442Hotel Tatry ViewKasia NowakWarsaw DC
S00456Hotel Horizon NamurTom PeetersBrussels DC
S00470Biuro Centrum WolaKasia NowakWarsaw DC
S00519Bistro KazimierzPiotr ZielińskiWarsaw DC
S00547Lunchbar KouterSophie LambertBrussels DC
S00548Cukiernia Stare MiastoPiotr ZielińskiWarsaw DC
S00550Piekarnia ŻoliborzKasia NowakWarsaw DC
6

Needed a credit note

29 of 441 invoiced orders (7%).

86% of them are orders shipped from Warsaw DC, which make up only 43% of invoiced orders: 13% of those orders are affected, against 7% on average.

Share of invoiced orders affected, by warehouse
average 7%Warsaw DC13% (25/190)Brussels DC2% (4/251)

Why it matters

A credit note is an invoice that had to be corrected: extra work for accounting and a worse experience for the customer.

What to do in Odoo

Fix the cause, not the symptom: check whether these orders were invoiced before shipping or changed after confirmation.

Show the 29 orders
OrderCustomerSalespersonWarehouse
S00043Coworking PragaKasia NowakWarsaw DC
S00063Hotel Poznań ParkKasia NowakWarsaw DC
S00072Kawiarnia RynekPiotr ZielińskiWarsaw DC
S00097Hotel Nad WisłąKasia NowakWarsaw DC
S00102Biurowiec MokotowskaKasia NowakWarsaw DC
S00107Station Coffee MechelenTom PeetersBrussels DC
S00116Stołówka PolitechnikaKasia NowakWarsaw DC
S00122Piekarnia ŻoliborzKasia NowakWarsaw DC
S00123Lunchbar KouterSophie LambertBrussels DC
S00142Stołówka PolitechnikaKasia NowakWarsaw DC
S00201Biurowiec MokotowskaPiotr ZielińskiWarsaw DC
S00215Café Nowa HutaPiotr ZielińskiWarsaw DC
S00216Bakkerij ZuidTom PeetersBrussels DC
S00242Hotel Poznań ParkKasia NowakWarsaw DC
S00266Café Nowa HutaKasia NowakWarsaw DC
S00279Piekarnia ŻoliborzKasia NowakWarsaw DC
S00349Coworking PragaPiotr ZielińskiWarsaw DC
S00365Kawiarnia OgródKasia NowakWarsaw DC
S00366Restauracja OdraKasia NowakWarsaw DC
S00378Café des Arts MonsSophie LambertBrussels DC
S00380Hotel Nad WisłąKasia NowakWarsaw DC
S00396Coworking PragaPiotr ZielińskiWarsaw DC
S00415Café Nowa HutaKasia NowakWarsaw DC
S00420Kawiarnia Sopot MoloKasia NowakWarsaw DC
S00435Piekarnia ŻoliborzKasia NowakWarsaw DC
S00441Hotel Nad WisłąPiotr ZielińskiWarsaw DC
S00485Coworking PragaPiotr ZielińskiWarsaw DC
S00519Bistro KazimierzPiotr ZielińskiWarsaw DC
S00559Bistro KazimierzKasia NowakWarsaw DC
7

Delivery date pushed back twice or more

14 of 453 confirmed orders (3%).

100% of them are orders containing Espresso Machine Pro, which make up only 6% of confirmed orders: 52% of those orders are affected, against 3% on average.

Share of confirmed orders affected, by product
average 3%Espresso Machine Pro52% (14/27)Descaler Tablets x106% (2/32)Espresso Beans Ethiopia 1…5% (4/83)Green Tea Sencha 500g4% (2/49)Paper Cups 12oz x10003% (2/61)Ground Coffee 250g3% (2/69)Chai Latte Mix 1kg3% (1/35)

Why it matters

Each postponement is a broken promise to the customer, and usually points to a stock or supplier problem on specific products.

What to do in Odoo

For the products involved, set reordering rules (Inventory > Operations > Replenishment) and realistic vendor lead times, so promised dates can be kept.

Show the 14 orders
OrderCustomerSalespersonWarehouse
S00099Hotel Nad WisłąPiotr ZielińskiWarsaw DC
S00177Kawiarnia Sopot MoloKasia NowakWarsaw DC
S00241Business Park DiegemSophie LambertBrussels DC
S00287Hotel Atelier BrugesTom PeetersBrussels DC
S00296Café Nowa HutaKasia NowakWarsaw DC
S00316Restauracja OdraPiotr ZielińskiWarsaw DC
S00334Tearoom DuinenTom PeetersBrussels DC
S00359Tearoom DuinenTom PeetersBrussels DC
S00393Tearoom DuinenTom PeetersBrussels DC
S00394Restauracja OdraPiotr ZielińskiWarsaw DC
S00425Espresso Point WavreSophie LambertBrussels DC
S00456Hotel Horizon NamurTom PeetersBrussels DC
S00470Biuro Centrum WolaKasia NowakWarsaw DC
S00550Piekarnia ŻoliborzKasia NowakWarsaw DC

Other checks

These rules found problems too, but with no clear pattern behind them.

CheckOrders affectedShare
Overdue and still unpaid266%
Cancelled after confirmation123%

The process map

Every box is a step, every arrow means "this step came right after that one". Thicker arrows carry more orders, and the colour shows how long orders waited before the next step (scale below). Numbers read as orders · median wait. Rare paths (under 1.5% of orders) are hidden.

Normal flowDetours and correctionsQuotation created560 ordersQuotation sent427 ordersOrder cancelled90 ordersOrder confirmed453 ordersOrder changed after confirmation75 ordersDelivery rescheduled42 ordersGoods shipped441 ordersInvoice posted441 ordersCredit note posted29 ordersPayment received404 orders427 · 4 h392 · 1.1 d351 · 27.8 d345 · 1.9 d291 · 1.0 d108 · 1.8 d70 · 12 h69 · 23 h59 · 27.7 d49 · 5 h41 · 24 h39 · 3.0 d32 · 1.0 d27 · 27.0 d26 · 20.3 d22 · 2.9 d19 · 27.0 d19 · 11.1 d12 · 2.6 d10 · 9.9 d
Arrow colour = median wait: short → longArrow width = number of orders
Show the map as a table
FromToOrdersMedian wait
StartQuotation created560–
Quotation createdQuotation sent4274 hours
Payment receivedEnd404–
Goods shippedInvoice posted3921.1 days
Invoice postedPayment received35127.8 days
Quotation sentOrder confirmed3451.9 days
Order confirmedGoods shipped2911.0 days
Quotation createdOrder confirmed1081.8 days
Order cancelledEnd90–
Order changed after confirmationGoods shipped7012 hours
Order confirmedOrder changed after confirmation6923 hours
Quotation sentOrder cancelled5927.7 days
Order confirmedInvoice posted495 hours
Invoice postedGoods shipped4124 hours
Delivery rescheduledGoods shipped393.0 days
Order confirmedDelivery rescheduled321.0 days
Invoice postedEnd31–
Goods shippedPayment received2727.0 days
Credit note postedPayment received2620.3 days
Quotation sentEnd23–
Delivery rescheduledDelivery rescheduled222.9 days
Quotation createdOrder cancelled1927.0 days
Goods shippedCredit note posted1911.1 days
Order confirmedOrder cancelled122.6 days
Invoice postedCredit note posted109.9 days
Quotation createdEnd6–
Order changed after confirmationDelivery rescheduled524 hours
Invoice postedDelivery rescheduled51.8 days
Goods shippedEnd3–
Delivery rescheduledOrder changed after confirmation31 hours
Invoice postedOrder changed after confirmation316 hours
Credit note postedEnd3–

Where the time goes

Median calendar days for each step, from the first time it happened to the first time the next one did. The whisker shows how long it takes for 90% of orders.

Quote to order2.0 days · 90% ≤ 5.7 dOrder to shipment1.1 days · 90% ≤ 4.2 dShipment to invoice1.1 days · 90% ≤ 4.0 dInvoice to payment27.9 days · 90% ≤ 55.6 dOrder to cash31.0 days · 90% ≤ 57.7 dmedian90% of orders
Show as a table
StepOrdersMedian90th percentile
Quote to order4532.0 days5.7 days
Order to shipment4411.1 days4.2 days
Shipment to invoice3921.1 days4.0 days
Invoice to payment40427.9 days55.6 days
Order to cash40431.0 days57.7 days

Shipping speed by warehouse and weekday

Median working days from confirmation to shipment, by the weekday the order was confirmed. Weekends are excluded, so a Friday order shipped on Monday counts as one day. Outlined cells were flagged as unusually slow.

MonTueWedThuFri
Brussels DC1.064 orders1.068 orders1.048 orders1.139 orders1.032 orders
Warsaw DC1.053 orders1.135 orders1.047 orders2.027 orders2.328 orders

Most common paths

The 36 different routes orders took, most frequent first (repeated steps are counted once).

20637%Quotation created → Quotation sent → Order confirmed → Goods shipped → Invoice posted → Payment received
6211%Quotation created → Order confirmed → Goods shipped → Invoice posted → Payment received
5911%Quotation created → Quotation sent → Order cancelled
366%Quotation created → Quotation sent → Order confirmed → Order changed after confirmation → Goods shipped → Invoice posted → Payment received
234%Quotation created → Quotation sent
193%Quotation created → Order cancelled
183%Quotation created → Quotation sent → Order confirmed → Invoice posted → Goods shipped → Payment received
173%Quotation created → Order confirmed → Order changed after confirmation → Goods shipped → Invoice posted → Payment received

About this analysis