Northwind ERP
Supply-chain decision automation for the Northwind Components ERP. Covers five
workflows: expedite dispatch, allocation transfers, kit replenishment, supplier
incident scorecards, and procurement quality controls.
Workflow Selection
Identify the task type from the prompt and input materials:
Expedite Dispatch — a queue memo (JSON) with order IDs, operator notes,
and an answer template requiring inventory status, customer exception,
final decision, next action, SKU exception lists, and shipping quote
per order. See references/business_rules.md
sections 1-3.
Allocation Desk — a transfer wave memo (markdown or JSON) with per-line
warehouse actions (ship, transfer, backorder, manual review),
transfer requests, and blocked orders. See
references/business_rules.md section 4.
Kit Replenishment — a production memo (JSON) with BOM targets,
build quantities, and build dates. Requires component-level coverage,
transfer requests, purchase requisitions, and exclusions. See
references/business_rules.md section 5.
Supplier Incident Scorecard — a scorecard request (JSON) with a date
filter, recommendation policy, and an answer template requiring
supplier-level aggregation, percentages, and recommendation codes. See
references/business_rules.md section 6.
Procurement Quality Control — a quality hold review memo (JSON) listing
target supplier IDs with a recent-incident window and decision choices
(freeze, buyer review, monitor). See
references/business_rules.md section 7.
API Reference
See references/api.md for the full endpoint catalog,
response shapes, effective-available formula, timely-PO rules, shipping quote
parameters, and incident duration calculations.
Core Patterns
Before Solving Any Workflow
Read the memo/payload and the answer template from the task input.
Understand what keys, enumerations, sort orders, and precision rules the
template enforces.
Fetch all live data in one batch: call all list endpoints once and cache
in Python dicts keyed by ID. These collections are small enough to hold
entirely in memory.
Fetch shipping quotes per order only when the template requires them.
Compute total order weight as the sum over all lines of quantity times
product weight_lb, then call the shipping quote endpoint with the order's
warehouse ID, destination ZIP, total weight, and shipping speed.
Effective Available Formula
effective = on_hand - reserved - quarantined - safety_stock
Apply per SKU per warehouse. Safety stock comes from the product record.
See references/api.md for details.
Customer Exception Precedence
For each order, look up the customer by ID. Apply in order:
- fraud_watch if risk_flag matches
- credit_watch if risk_flag matches
- account_blocked if account_status is blocked
- review_required if account_status requires review
- none otherwise
Full decision tables in references/business_rules.md
sections 2-4.
Shipping Quote
GET /shipping/quote?warehouse_id=...&destination_zip=...&weight_lb=...&service=...
Compute total weight by summing line quantity times product weight_lb across
all lines. Use the order's shipping speed as the service parameter. Return
zone_distance (int), service_days (int), and total_cost (number, 2 decimals).
Formatting Rules
- Currency values: round to 2 decimal places.
- Percentages: round to 1 decimal place.
- Durations in days: round to 2 decimal places.
- Sort all lists ascending by the primary key specified in the answer template.
- Output only the JSON object, no narrative text outside it.
- Derive all values from live API calls, never hard-code from memos.
Reference Files
- references/api.md — Complete API endpoint catalog with
field descriptions, response shapes, and parameter rules.
- references/business_rules.md — Decision
tables for all five workflows, inventory classification, customer exception
rules, recommendation policies, and procurement control logic.
1---2name: northwind-erp-53description: Supply-chain decision workflows for the Northwind Components ERP system including expedite dispatch, allocation desk transfers, kit replenishment planning, supplier incident scorecards, and procurement quality controls. Use when tasks involve Northwind ERP API calls to products, inventory, orders, customers, suppliers, purchase orders, BOMs, incidents, or shipping quote endpoints, or when filling structured JSON decision templates for supply-chain operations.4metadata:5 source: https://skillmd.com/skills/prism-shadow/northwind-erp-56---78# Northwind ERP910Supply-chain decision automation for the Northwind Components ERP. Covers five11workflows: expedite dispatch, allocation transfers, kit replenishment, supplier12incident scorecards, and procurement quality controls.1314## Workflow Selection1516Identify the task type from the prompt and input materials:17181. **Expedite Dispatch** — a queue memo (JSON) with order IDs, operator notes,19 and an answer template requiring inventory status, customer exception,20 final decision, next action, SKU exception lists, and shipping quote21 per order. See [references/business_rules.md](references/business_rules.md)22 sections 1-3.23242. **Allocation Desk** — a transfer wave memo (markdown or JSON) with per-line25 warehouse actions (ship, transfer, backorder, manual review),26 transfer requests, and blocked orders. See27 [references/business_rules.md](references/business_rules.md) section 4.28293. **Kit Replenishment** — a production memo (JSON) with BOM targets,30 build quantities, and build dates. Requires component-level coverage,31 transfer requests, purchase requisitions, and exclusions. See32 [references/business_rules.md](references/business_rules.md) section 5.33344. **Supplier Incident Scorecard** — a scorecard request (JSON) with a date35 filter, recommendation policy, and an answer template requiring36 supplier-level aggregation, percentages, and recommendation codes. See37 [references/business_rules.md](references/business_rules.md) section 6.38395. **Procurement Quality Control** — a quality hold review memo (JSON) listing40 target supplier IDs with a recent-incident window and decision choices41 (freeze, buyer review, monitor). See42 [references/business_rules.md](references/business_rules.md) section 7.4344## API Reference4546See [references/api.md](references/api.md) for the full endpoint catalog,47response shapes, effective-available formula, timely-PO rules, shipping quote48parameters, and incident duration calculations.4950## Core Patterns5152### Before Solving Any Workflow53541. **Read the memo/payload and the answer template** from the task input.55 Understand what keys, enumerations, sort orders, and precision rules the56 template enforces.57582. **Fetch all live data in one batch**: call all list endpoints once and cache59 in Python dicts keyed by ID. These collections are small enough to hold60 entirely in memory.61623. **Fetch shipping quotes per order** only when the template requires them.63 Compute total order weight as the sum over all lines of quantity times64 product weight_lb, then call the shipping quote endpoint with the order's65 warehouse ID, destination ZIP, total weight, and shipping speed.6667### Effective Available Formula6869```70effective = on_hand - reserved - quarantined - safety_stock71```7273Apply per SKU per warehouse. Safety stock comes from the product record.74See [references/api.md](references/api.md) for details.7576### Customer Exception Precedence7778For each order, look up the customer by ID. Apply in order:791. fraud_watch if risk_flag matches802. credit_watch if risk_flag matches813. account_blocked if account_status is blocked824. review_required if account_status requires review835. none otherwise8485Full decision tables in [references/business_rules.md](references/business_rules.md)86sections 2-4.8788### Shipping Quote8990```91GET /shipping/quote?warehouse_id=...&destination_zip=...&weight_lb=...&service=...92```9394Compute total weight by summing line quantity times product weight_lb across95all lines. Use the order's shipping speed as the service parameter. Return96zone_distance (int), service_days (int), and total_cost (number, 2 decimals).9798### Formatting Rules99100- Currency values: round to 2 decimal places.101- Percentages: round to 1 decimal place.102- Durations in days: round to 2 decimal places.103- Sort all lists ascending by the primary key specified in the answer template.104- Output only the JSON object, no narrative text outside it.105- Derive all values from live API calls, never hard-code from memos.106107## Reference Files108109- [references/api.md](references/api.md) — Complete API endpoint catalog with110 field descriptions, response shapes, and parameter rules.111- [references/business_rules.md](references/business_rules.md) — Decision112 tables for all five workflows, inventory classification, customer exception113 rules, recommendation policies, and procurement control logic.