Northwind ERP Decision Files
Treat the memo and answer template as the contract. The template defines the exact keys, allowed values, ordering, and rounding; the live API supplies the facts.
Workflow
- Read every attached memo and the answer template first.
- Identify the task family and the fields that matter.
- Query the live API only for the entities the task needs.
- Build a scratch table for the facts, then map those facts to the template exactly.
- Return JSON only. No commentary, markdown, or fenced code.
Reference
Load references/northwind_api.md when you need endpoint names, response fields, or calculation notes.
Core rules
- Use the live API as the source of truth. Do not rely on cached snapshots or memory.
- Follow memo policy and template precedence literally when they are explicit.
- Keep every array sorted exactly as the template says.
- Round currency to 2 decimals unless the template says otherwise.
- Round percentages and durations to the precision in the template.
- Do not add fields that the template does not ask for.
- Prefer narrow, traceable calculations over clever shortcuts.
Common task families
Order waves and allocation files
- Pull orders, customers, products, inventory, warehouses, and shipping quotes.
- Use product
active as a hard status signal.
- Use inventory
on_hand, reserved, and quarantined to compute effective availability.
- If the task needs a shipping quote, quote the requested warehouse, destination zip, weight, and speed from the order or memo.
- Let account, risk, or product blocks override simple stock release when the template or memo says they do.
BOM and replenishment plans
- Pull BOMs, products, inventory, and purchase orders.
- Compute component demand from
build_quantity x quantity_per_kit.
- Split coverage into current stock, internal transfers, timely PO coverage, and new purchase needs.
- Exclude components that are already covered or should not receive more stock when the template asks for exclusions.
Supplier quality and incident scorecards
- Pull incidents and suppliers, and use purchase orders if the memo asks for held or released PO decisions.
- Filter incidents by the memo's window and status rules.
- Count incidents, RMAs, work orders, open cases, and severe cases exactly as requested.
- Apply the recommendation policy in precedence order.
Final pass
Before you answer, compare the draft against the template one more time:
- top-level keys
- nested keys
- sort order
- enum values
- numeric precision
- presence of every required summary field
1---2name: northwind-erp3description: Solve Northwind ERP decision-file tasks from a memo plus answer template by querying the live ERP API and returning strict JSON. Use whenever the user mentions Northwind Components, ERP order waves, BOM replenishment, supplier quality scorecards, allocation or transfer decisions, procurement holds, shipping quotes, or any similar workflow that needs live orders, inventory, products, customers, suppliers, incidents, purchase orders, or BOM data.4metadata:5 source: https://skillmd.com/skills/prism-shadow/northwind-erp6---78# Northwind ERP Decision Files910Treat the memo and answer template as the contract. The template defines the exact keys, allowed values, ordering, and rounding; the live API supplies the facts.1112## Workflow131. Read every attached memo and the answer template first.142. Identify the task family and the fields that matter.153. Query the live API only for the entities the task needs.164. Build a scratch table for the facts, then map those facts to the template exactly.175. Return JSON only. No commentary, markdown, or fenced code.1819## Reference20Load [`references/northwind_api.md`](references/northwind_api.md) when you need endpoint names, response fields, or calculation notes.2122## Core rules23- Use the live API as the source of truth. Do not rely on cached snapshots or memory.24- Follow memo policy and template precedence literally when they are explicit.25- Keep every array sorted exactly as the template says.26- Round currency to 2 decimals unless the template says otherwise.27- Round percentages and durations to the precision in the template.28- Do not add fields that the template does not ask for.29- Prefer narrow, traceable calculations over clever shortcuts.3031## Common task families3233### Order waves and allocation files34- Pull orders, customers, products, inventory, warehouses, and shipping quotes.35- Use product `active` as a hard status signal.36- Use inventory `on_hand`, `reserved`, and `quarantined` to compute effective availability.37- If the task needs a shipping quote, quote the requested warehouse, destination zip, weight, and speed from the order or memo.38- Let account, risk, or product blocks override simple stock release when the template or memo says they do.3940### BOM and replenishment plans41- Pull BOMs, products, inventory, and purchase orders.42- Compute component demand from `build_quantity x quantity_per_kit`.43- Split coverage into current stock, internal transfers, timely PO coverage, and new purchase needs.44- Exclude components that are already covered or should not receive more stock when the template asks for exclusions.4546### Supplier quality and incident scorecards47- Pull incidents and suppliers, and use purchase orders if the memo asks for held or released PO decisions.48- Filter incidents by the memo's window and status rules.49- Count incidents, RMAs, work orders, open cases, and severe cases exactly as requested.50- Apply the recommendation policy in precedence order.5152## Final pass53Before you answer, compare the draft against the template one more time:54- top-level keys55- nested keys56- sort order57- enum values58- numeric precision59- presence of every required summary field