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.
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.
The card surfaces 3 open rows; alert “any open PO past ship_by” is firing. Five things to notice:
- 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: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:
Cross-connector reconciliation: