Technical Case Study · Retail & Franchise

Eliminating retail stock drift with structured delivery notes

Ingesting supplier delivery notes to feed theoretical inventory calculations, combining physical Varetelling anchors with PCKasse sales data.

The problem

The challenge

Franchise operators suffer from inventory blindness (stock drift) when supplier delivery notes do not match the ERP. Resolving these discrepancies manually drastically increases the Mean Time To Resolve (MTTR) for stock incidents, leading to empty shelves or phantom inventory in the PCKasse system.

The solution

The SunnyExtract pipeline

The system ingests delivery notes directly from the store level. SunnyExtract extracts line items, quantities, and supplier SKUs, standardizing the data. This structured payload feeds the Avvik (deviations) dashboard, allowing the reconciliation engine to calculate theoretical inventory by combining the latest Varetelling physical count with incoming orders and POS sales data.

system_payload.json

{
  "document_type": "delivery_note",
  "store_id": "ST-045",
  "supplier": "NordicGoods AS",
  "line_items": [
    {
      "sku": "NG-8812",
      "expected_qty": 50,
      "received_qty": 48,
      "discrepancy": -2
    }
  ],
  "validation": {
    "avvik_alert_triggered": true
  }
}

Outcomes

Operational impact

Instant shipment visibility

Supplier short-shipments are visible immediately, not discovered at month-end.

Faster incident resolution

A drastic reduction in MTTR for store-level stock incidents.

Ready-to-import payloads

Seamless JSON payloads ready for PCKasse SQL Server integration.

Request a private workflow review

Tell us how your document workflow works today. We review every request manually and prepare demos around real operational needs.

Request private workflow review