Inventory / Stock Reconciliation

What it is: Physical stock counts against book quantities, differences investigated, and authorised adjustments recorded.

Overview

Works out the smallest useful Inventory / Stock Reconciliation setup for the business in front of it, then builds it only when asked. The default output is a short recommendation, not a spreadsheet. Artifacts - CSV, SQL DDL, JSON Schema, Notion mapping - are produced on request, from one field list so they cannot drift apart.

Three guardrails shape the whole table.

The artifact stage is template-only. What the user receives is a structure: a CSV that is a header row and no data row, DDL with no INSERTs, a schema with no example values, and a property mapping table. Add one clearly labelled illustrative row only when the user explicitly asks for one. The failure this prevents is an unknown quietly turning into fake data inside a generated artifact.