ERP Planning Lab
ERP-style planning, demand-supply review, planned order release, PO/job output, score validation, and registers.
Open ERP Planning LabHelp & Test Cases
ERP/SCM Data Quality & Planning Exception Analyzer
Use this page to understand expected CSV formats and perform an end-to-end test.
End-to-end browser test
- Download sample CSVs for Items, BOM, On-hand, Sales Orders, Purchase Orders, Work Orders, Suppliers, Resources, and Routings.
- Open the analyzer page and upload the sample files in matching fields.
- Click Analyze Planning Readiness.
- Expected result: readiness score, high/medium/low exceptions, planning scorecards, and corrective actions.
Sample CSV files
Main validation checks
Item Master
Missing item type, lead time, planner code, duplicate item, make item without BOM, buy item without supplier, inactive item with demand.
BOM / Routing
Missing parent/component item, invalid component quantity, inactive component, undefined resource, missing capacity.
Demand / Supply
Demand shortage, bad on-hand quantity, late/invalid purchase order, unknown items, open work order risk.
Scorecard
Creates item-level planning readiness score and recommends planner/buyer corrective action.
Command-line smoke test
curl -sS https://www.technopkg.com/api/erp-dq/healthExpected response contains "ok": true.