Open POs where the ship-by has passed and no ASN has been dropped to /outbox. Action immediately.
At a glance
Live alert table of Costco purchase orders where the contractual ship-by date has passed and the matching Advance Ship Notice (EDI 856 ASN) has not yet been dropped to Costco’s /outbox SFTP folder. Costco’s Strategic Industries Program (SIP) supplier rules treat a missing or late ASN as an automatic chargeback against the supplier. Each row on this card is a chargeback waiting to be assessed; this is the most expensive single failure mode on the Costco SIP integration. Treat the dial as a P1 incident queue, not a KPI.
| What it counts | COUNT(purchase_order WHERE ship_by < now() AND no matching ASN in /outbox). The card surfaces individual rows in alert-table format, not just a count. Each row shows po_number, ship_by_date, hours_overdue, total_units, total_value, dc_destination. |
| EDI source | Inbound POs come from Costco as EDI 850 files dropped into the supplier’s /inbox SFTP folder; ASN responses go back as EDI 856 files dropped into /outbox. The card joins the 850 (open POs with ship_by) against the 856 (sent ASNs by po_number) to find unmatched POs past the ship-by. |
| Cancellations | Cancelled POs (Costco sends EDI 860 PO Change with cancellation_indicator=Y) are excluded; the card only surfaces POs Costco still expects. |
| Partial fulfilment | A PO with a partial ASN (some line-items shipped, others not) counts as fulfilled for ASN purposes; Costco accepts partial 856 acknowledgement. The unfulfilled units flow into Fill Rate instead. |
| Chargeback economics | Costco’s standard SIP supplier-handbook chargeback rate for late ASN is roughly USD 250 per PO plus a percentage-of-value penalty (commonly 3 to 5 percent) on POs more than 24 hours late. The dial does not assess the chargeback automatically; it surfaces the chargeback risk. |
| Currency | All values in USD (Costco SIP operates in USD for US suppliers; CAD for the Canadian SIP variant). The card normalises to the supplier’s home currency at the integration layer. |
| DC scope | All Costco depot codes the supplier ships to (typical SIP supplier ships to 8 to 24 distribution centres). The DC mix matters: a missing ASN to Costco’s Tracy CA DC (high-velocity West Coast) is operationally more urgent than a missing ASN to Carlisle PA. |
| Time window | RT (real-time, refreshes on every inbound 850 / outbound 856 file event). |
| Alert trigger | any open PO past ship_by. Triggers immediately. There is no grace period because Costco’s rule does not have one. |
| Roles | owner, operations |
Calculation
Calculated automatically from your Costco SIP data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A US-based household-goods supplier on Costco SIP, trading roughly 60 to 80 POs per week across 14 Costco distribution centres. Reading taken at 09:00 PT on 12 Mar 26.| PO Number | DC | Ship-by date | Hours overdue | Units | Total value (USD) | Estimated chargeback exposure |
|---|---|---|---|---|---|---|
| 4500987612 | Tracy CA (W2) | 11 Mar 26 | 19 | 240 cases | 18,420 | ~750 (250 base + 3% × 18,420) |
| 4500987655 | Mira Loma CA (W3) | 11 Mar 26 | 19 | 96 cases | 7,680 | ~480 (250 base + 3% × 7,680) |
| 4500987801 | Carlisle PA (E1) | 12 Mar 26 | 1 | 180 cases | 14,200 | ~250 (base only, under 24h late) |
| Total open (this card) | 3 POs | 516 cases | 40,300 | ~1,480 |
- The 19-hour-overdue Tracy and Mira Loma POs are the urgent ones. They were due to ship yesterday, missed the West Coast outbound window, and Costco’s Tracy DC will start refusing receipt at 36 hours overdue. Chase same-day: confirm with the warehouse whether the goods physically shipped (label printed but ASN not generated is a process bug; goods sat on dock is a real fulfilment failure).
- The 1-hour-overdue Carlisle PO is recoverable. Most ASN delays inside the first few hours are EDI-translator queue lag, not actual fulfilment issues. The card surfaces it as red because Costco’s rule does not have a grace period; in practice send the 856 within the next 4 to 8 hours and the chargeback typically does not assess.
- The chargeback exposure is roughly USD 1,480 today. Past 24 hours overdue Costco’s percentage-of-value penalty kicks in (an extra 3 to 5 percent on top of the base USD 250). Past 48 hours overdue Costco may reject the PO entirely and re-source from another supplier, which is significantly more expensive than the chargeback.
- All three POs share a common date. When 2 or 3 POs land on the same overdue date, the cause is usually upstream: an EDI translator outage, an SFTP authentication issue, a warehouse pick-pack delay across multiple POs. Investigate the common factor before assuming each PO is an independent failure.
- Pair with Late ASN Count (30d) for trend. A spike in this real-time card paired with a flat 30-day late-ASN count is usually a one-off; a spike paired with a rising 30-day count is a structural pattern that needs process work.
Sibling cards merchants should reference together
POs Missing ASN is a P1 incident queue. Pair with these to triage:| Card | Why pair it with POs Missing ASN | What the combination tells you |
|---|---|---|
| Late ASN Count (30d) | The 30-day cumulative count of ASNs sent past ship-by. | The realtime queue plus the trailing-30-day count tells you whether today’s incident is one-off or part of a pattern. |
| On-Time ASN Rate | The percentage form. | Direct chargeback driver; a missing-ASN spike here moves the rate immediately. |
| PO Acknowledgment Rate | Upstream signal. | Missing ACKs precede missing ASNs; if ACK rate dipped 24 to 48 hours ago, the missing-ASN queue is downstream of that. |
| Late ASN Burst | The Nerve Centre alert that fires on clusters. | Burst = multiple POs late at once = systemic issue (EDI outage, warehouse breakdown). |
| Last Successful Outbound | When did our /outbox last get read? | If hours-since-last-outbound is high AND missing-ASN queue is rising, the SFTP outbound is the bottleneck, not the warehouse. |
| Chargeback Risk (30d) | Dollar form of the consequences. | Today’s missing-ASN queue is tomorrow’s chargeback assessment; the chargeback-risk dial pre-computes the dollar exposure. |
Cross-connector: shipbob.sb_orders_open | If ShipBob handles fulfilment for Costco POs. | Missing-ASN can be upstream warehouse delay; ShipBob’s open-order count and aging tail indicate whether the goods are stuck pre-pick. |
Cross-connector: jira.tracker_open_issues | The escalation queue. | Each missing-ASN row should have a Jira issue when it ages past 24 hours; the cross-connector view confirms triage is happening. |
Reconciling against the vendor’s own dashboard
Where to look in Costco’s own portal: Costco Supplier Portal → Orders → Open POs filter to Past Ship-by. Costco’s view is authoritative for what they expect; the card’s view is authoritative for what we have ASN’d. The two should reconcile to the unit; gaps mean either we sent an ASN Costco did not parse, or Costco closed a PO without notifying us. Why our number may legitimately differ from Costco’s portal:| Reason | Direction | Why |
|---|---|---|
| EDI translator queue lag | Ours sometimes higher | A 856 ASN may have left our /outbox but not yet been parsed by Costco’s EDI gateway; the supplier-portal view shows “no ASN received” while our card shows “ASN sent”. Resolves within 1 to 4 hours typically. |
| PO change orders (EDI 860) | Either | Costco issued a 860 PO Change extending ship-by; if we have not ingested the 860 yet, our card still surfaces the original (now superseded) ship-by. Refresh the inbound feed and the row clears. |
| ASN rejection | Ours lower | Our card reads “ASN sent”. If Costco’s EDI gateway rejected the 856 (line-item mismatch, GTIN error, packing-config drift), the supplier portal still shows “no ASN” while we believe we sent one. Pair with Sync Error Count (7d). |
| Cancelled POs | Either | Costco issued a 860 cancellation; our card excludes cancelled POs by definition, the portal sometimes still shows them in a transition state for 24 to 48 hours. |
| Timezone (PT vs UTC) | Off by hours | Costco’s portal shows ship-by in Pacific Time (Costco corporate is in Issaquah WA); our card stores in UTC. Hours-overdue calculation is consistent but boundary-day display differs. |
| Card | Expected relationship | Causes of legitimate divergence |
|---|---|---|
shipbob.sb_orders_open | If ShipBob fulfils Costco POs, missing-ASN POs should map back to open ShipBob orders. | Some POs may fulfil through internal warehouse, not ShipBob. |
jira.tracker_open_issues | Each aged missing-ASN PO should have a Jira issue. | Triage gap if the count of card rows >24h exceeds the count of open Jira tickets referencing those PO numbers. |