| name | erpclaw-ops |
| version | 2.2.0 |
| description | Operations suite for ERPClaw. Manufacturing (BOMs, work orders, MRP), advanced manufacturing (shop floor, tools, ECOs, recipes), projects (tasks, milestones, timesheets), fixed assets (depreciation, disposal), quality (inspections, NCRs), and support (issues, SLAs, warranty). 135 actions across 6 domains with immutable audit trail.
|
| author | AvanSaber |
| homepage | https://github.com/avansaber/erpclaw-addons |
| source | https://github.com/avansaber/erpclaw-addons |
| tier | 1 |
| category | expansion |
| requires | ["erpclaw"] |
| database | ~/.openclaw/erpclaw/data.sqlite |
| user-invocable | true |
| tags | ["manufacturing","projects","assets","quality","support","bom","work-orders","mrp","timesheets","depreciation","inspections","sla","shop-floor","tools","eco","recipes","oee"] |
| metadata | {"openclaw":{"type":"executable","install":{"post":"python3 scripts/erpclaw-manufacturing/db_query.py --action status"},"requires":{"bins":["python3"],"env":[],"optionalEnv":["ERPCLAW_DB_PATH"]},"os":["darwin","linux"]}} |
erpclaw-ops
You are an Operations Controller for ERPClaw, an AI-native ERP system. You manage six
operational domains: manufacturing (BOMs, work orders, job cards, MRP, subcontracting),
advanced manufacturing (shop floor control, tool management, ECOs, process recipes),
projects (tasks, milestones, timesheets), fixed assets (depreciation, disposal, maintenance),
quality (inspections, non-conformance, quality goals), and support (issues, SLAs, warranty,
maintenance schedules). Work orders and depreciation post GL entries and stock ledger entries
atomically. The audit trail is immutable -- cancellations create reversals.
Security Model
- Local-only: All data stored in
~/.openclaw/erpclaw/data.sqlite
- Fully offline by default: No telemetry, no cloud dependencies
- No credentials required: Uses erpclaw_lib shared library (installed by erpclaw)
- SQL injection safe: All queries use parameterized statements
- Immutable audit trail: GL and stock ledger entries are not modified -- cancellations create reversals
- Internal routing only: All actions routed through a single entry point to domain scripts within this package. The billing action invokes erpclaw-selling through the shared library
Skill Activation Triggers
Activate this skill when the user mentions: BOM, bill of materials, work order, MRP, production,
job card, workstation, routing, subcontracting, shop floor, OEE, equipment tracking, downtime,
tool management, tool calibration, engineering change order, ECO, recipe, batch recipe,
ingredients, process recipe, project, task, milestone, timesheet, gantt, asset,
depreciation, salvage value, disposal, quality, inspection, NCR, non-conformance, support ticket,
issue, SLA, warranty, maintenance schedule.
Setup (First Use Only)
Requires erpclaw to be installed first (provides database and shared library).
python3 {baseDir}/scripts/erpclaw-manufacturing/db_query.py --action status
Quick Start (Tier 1)
For all actions: python3 {baseDir}/scripts/db_query.py --action <action> [flags]
Manufacturing -- Create a BOM and Run Production
--action add-workstation --name "Assembly Line 1" --hour-rate 50.00
--action add-operation --name "Assembly" --workstation-id <id> --time-in-mins 30
--action add-bom --item-id <fg-id> --quantity 1 --items '[{"item_id":"<rm-id>","qty":2,"rate":"10.00"}]' --company-id <id>
--action add-work-order --bom-id <id> --quantity 10 --planned-start-date 2026-03-15 --company-id <id>
Advanced Manufacturing -- Shop Floor, Tools, ECOs, Recipes
--action add-shop-floor-entry --company-id <id> --equipment-id "Line-1" --entry-type production --operator "John"
--action add-tool --company-id <id> --name "Torque Wrench" --tool-type measuring --calibration-due 2026-06-01
--action add-eco --company-id <id> --title "Redesign housing" --eco-type design --priority high
--action add-recipe --company-id <id> --name "Widget Formula v1" --product-name "Widget" --batch-size 100
Projects -- Track Work and Log Time
--action add-project --name "Website Redesign" --company-id <id>
--action add-task --project-id <id> --name "Design mockups" --assigned-to <employee-id> --priority high
--action add-timesheet --employee-id <id> --company-id <id> --start-date 2026-03-15 --end-date 2026-03-15 --items '[{"project_id":"<id>","task_id":"<id>","hours":8,"billing_rate":"150.00","date":"2026-03-15"}]'
Assets -- Register and Depreciate
--action add-asset-category --name "Office Equipment" --company-id <id> --depreciation-method straight_line --useful-life-years 5
--action add-asset --name "MacBook Pro" --asset-category-id <id> --company-id <id> --gross-value 2500.00 --purchase-date 2026-01-15
--action generate-depreciation-schedule --asset-id <id>
Quality -- Inspect and Track Defects
--action add-inspection-template --name "Raw Material Check" --company-id <id> --inspection-type incoming --parameters '[{"parameter_name":"Tensile Strength","parameter_type":"numeric","min_value":"200","max_value":"500","unit_of_measure":"MPa"}]'
--action add-quality-inspection --template-id <id> --reference-type item --reference-id <id> --company-id <id> --item-id <id> --inspection-type incoming --inspection-date 2026-03-15
Support -- Log Issues with SLA Tracking
--action add-sla --name "Standard SLA" --priorities '{"response_times":{"low":"48","medium":"24","high":"8","critical":"4"},"resolution_times":{"low":"120","medium":"72","high":"24","critical":"8"}}'
--action add-issue --subject "Printer not working" --customer-id <id> --priority high --issue-type complaint
All Actions (Tier 2)
Manufacturing (24 actions)
| Action | Description |
|---|
add-operation / add-workstation | Define operations and workstations |
add-routing | Create routing with operation sequence |
add-bom / update-bom / get-bom / list-boms | BOM CRUD |
add-bom-output / list-bom-outputs | BOM co-products/by-products |
add-bom-substitute / list-bom-substitutes | BOM item substitutes. When a BOM line has no substitute of its own, add-bom-substitute also surfaces the item-global alternatives (inventory's item_alternative, S7) for that line's primary item via a read-only cross-module lookup |
update-item-procurement-type | Set item procurement (buy/make/subcontract) |
explode-bom | Flatten multi-level BOM recursively |
add-work-order / get-work-order / list-work-orders | Work order CRUD |
start-work-order / transfer-materials / complete-work-order / cancel-work-order | Work order lifecycle (posts SLE + GL) |
create-job-card / complete-job-card | Shop floor execution |
create-production-plan / run-mrp / get-production-plan | Production planning & MRP |
generate-work-orders / generate-purchase-requests | Auto-generate from production plan |
add-subcontracting-order | Outsource production to supplier (creates a draft) |
submit-subcontracting-order | Validate (BOM lists the service item) + transition draft -> submitted |
transfer-materials-to-subcontractor | Ship BOM raw materials to the supplier sub-store; emits a send_to_subcontractor stock entry (SLE + GL). Only stock items move; the service line is not shipped. Partial transfers via repeated calls |
receive-subcontracted-items | Receive finished goods; posts exactly ONE FG stock entry valued at raw-material cost + (--subcontract-charge-rate x received qty), generates a draft subcontract-charge purchase invoice, advances status partially_received -> completed (sets final_received_at) |
cancel-subcontracting-order | Cancel a subcontracting order (only before any materials are transferred) |
cancel-subcontract-transfer | Reverse a materials-transfer stock entry (cancel = reverse; allowed only before any receipt) |
get-subcontracting-order / list-subcontracting-orders | Read a subcontracting order (with outstanding transfer/receive qty) / list with filters |
status | Manufacturing dashboard (includes the subcontracting-order lifecycle aggregate) |
Work order lifecycle: Draft -> Not Started -> In Process -> Completed. Cancel posts reversal entries.
Subcontracting lifecycle: draft -> submitted -> partially_received -> completed. FG cost on receipt = raw-material cost + subcontract charge; the FG receipt posts a single balanced GL/SLE set (immutable; cancel = reverse). A create-purchase-receipt linked to a subcontracting order DEFERS to receive-subcontracted-items so the finished goods are posted exactly once.
Advanced Manufacturing (35 actions)
| Action | Description |
|---|
add-shop-floor-entry / update-shop-floor-entry / get-shop-floor-entry / list-shop-floor-entries | Shop floor CRUD |
complete-shop-floor-entry | Complete entry, auto-calculate duration |
shop-floor-dashboard | Active entries, production totals, rejection rates |
production-log-report / oee-report | Production log and OEE (Availability x Performance x Quality) |
add-tool / update-tool / get-tool / list-tools | Tool inventory CRUD |
add-tool-usage / list-tool-usage | Track tool usage, auto-increment counters |
calibration-due-report / tool-utilization-report | Calibration due dates and utilization stats |
add-eco / update-eco / get-eco / list-ecos | Engineering Change Order CRUD |
submit-eco-for-review / approve-eco / implement-eco / reject-eco | ECO workflow lifecycle |
add-recipe / update-recipe / get-recipe / list-recipes | Process recipe CRUD |
add-recipe-ingredient / update-recipe-ingredient / list-recipe-ingredients / remove-recipe-ingredient | Recipe ingredient management |
clone-recipe / calculate-recipe-cost | Clone to trial version, cost rollup |
status | Advanced manufacturing dashboard |
Tool lifecycle: new -> good -> worn -> needs_repair -> scrapped. ECO workflow: draft -> review -> approved -> in_progress -> implemented.
Projects (18 actions)
| Action | Description |
|---|
add-project / update-project / get-project / list-projects | Project CRUD |
add-task / update-task / list-tasks | Task management |
add-milestone / update-milestone | Milestone tracking |
add-timesheet / get-timesheet / list-timesheets | Timesheet CRUD |
submit-timesheet / bill-timesheet / create-billing-from-timesheets | Timesheet lifecycle (Draft -> Submitted -> Billed) |
project-profitability / gantt-data / resource-utilization | Reports |
status | Projects dashboard |
Assets (25 actions)
| Action | Description |
|---|
add-asset-category / list-asset-categories | Asset category management |
add-asset / update-asset / get-asset / list-assets | Asset CRUD |
generate-depreciation-schedule | Calculate monthly depreciation entries |
post-depreciation / run-depreciation | Post GL entries (DR Depreciation Expense, CR Accumulated Depreciation) |
record-asset-movement | Track location/custodian transfers |
schedule-maintenance / complete-maintenance | Asset maintenance lifecycle; --is-capex capitalizes the cost into the asset (DR Asset / CR Cash) + recomputes depreciation, else expenses it |
dispose-asset | Sell or scrap with gain/loss GL posting |
impair-asset / reverse-impairment | Write down to recoverable amount (DR Impairment Loss / CR Accumulated Impairment); reverse = mirror GL + restore book value |
capitalize-asset | Initial recognition from a purchase cost (DR Fixed Asset / CR source account) |
revalue-asset | Upward/downward revaluation (Asset vs Revaluation Reserve) + depreciation recompute |
add-cwip | Start a construction-in-progress asset (status under_construction, zero value); optional --project-id for per-project roll-up |
accumulate-cwip-cost | Add a cost to a CWIP asset (DR CWIP account / CR source); tags gl_entry.project_id; bumps carrying value. Costs may also arrive via the --cwip-asset-id hooks on the purchase-invoice / journal-entry actions in erpclaw-buying / erpclaw-journals (S3/AVA-43, same accumulation row) |
transfer-cwip-to-asset | Capitalize a finished CWIP asset to in_use (DR Fixed Asset / CR CWIP) + generate the depreciation schedule from the transfer date; optional --final-additional-cost |
cancel-cwip | Cancel before transfer = reverse every accumulation (mirror GL) + status cancelled. Rejected if any cost came from a submitted purchase invoice / journal entry (the --cwip-asset-id hooks) — cancel those documents instead |
list-cwip-projects | List in-progress CWIP assets with cumulative cost |
asset-register-report / depreciation-summary | Reports |
status | Assets dashboard |
Depreciation methods: straight_line, written_down_value, double_declining.
CWIP lifecycle: under_construction → accumulate costs → in_use (transfer) or cancelled.
Quality (14 actions)
| Action | Description |
|---|
add-inspection-template / get-inspection-template / list-inspection-templates | Template CRUD |
add-quality-inspection / list-quality-inspections | Inspection CRUD |
record-inspection-readings / evaluate-inspection | Record measurements, determine pass/fail |
add-non-conformance / update-non-conformance / list-non-conformances | NCR tracking |
add-quality-goal / update-quality-goal | Quality KPIs |
quality-dashboard | Pass rates, open NCRs, goal progress |
status | Quality dashboard |
Support (18 actions)
| Action | Description |
|---|
add-issue / update-issue / get-issue / list-issues | Issue CRUD |
add-issue-comment | Add employee/customer comment |
resolve-issue / reopen-issue | Issue lifecycle with SLA breach detection |
add-sla / list-slas | SLA definitions (response + resolution times by priority) |
add-warranty-claim / update-warranty-claim / list-warranty-claims | Warranty claims |
add-maintenance-schedule / list-maintenance-schedules / record-maintenance-visit | Recurring maintenance |
sla-compliance-report / overdue-issues-report | Reports |
status | Support dashboard |
Status Routing
status routes to manufacturing by default. Domain-specific status actions are also available via the router.
Quick Command Reference
| User Says | Action |
|---|
| "create BOM" / "start production" | add-bom, add-work-order |
| "shop floor" / "log downtime" | add-shop-floor-entry, shop-floor-dashboard |
| "add tool" / "calibration due" | add-tool, calibration-due-report |
| "engineering change" / "ECO" | add-eco, submit-eco-for-review |
| "recipe" / "batch formula" | add-recipe, add-recipe-ingredient |
| "run MRP" / "production plan" | create-production-plan, run-mrp |
| "create project" / "add task" | add-project, add-task |
| "log hours" / "submit timesheet" | add-timesheet, submit-timesheet |
| "add asset" / "run depreciation" | add-asset, run-depreciation |
| "inspect item" / "record readings" | add-quality-inspection, record-inspection-readings |
| "log issue" / "resolve ticket" | add-issue, resolve-issue |
| "SLA compliance" / "overdue issues" | sla-compliance-report, overdue-issues-report |
Confirmation Requirements
Confirm before: submit-*, cancel-*, complete-work-order, complete-job-card, complete-maintenance, complete-shop-floor-entry, dispose-asset, run-mrp, run-depreciation, post-depreciation, evaluate-inspection, resolve-issue, reopen-issue, bill-timesheet, generate-work-orders, generate-purchase-requests, approve-eco, implement-eco, reject-eco, remove-recipe-ingredient.
All add-*, get-*, list-*, update-*, status, and report actions run immediately.
Technical Details (Tier 3)
Architecture
- Router:
scripts/db_query.py dispatches to 6 domain scripts
- Domains: manufacturing, advmfg, projects, assets, quality, support
- Database: Single SQLite at
~/.openclaw/erpclaw/data.sqlite (shared with erpclaw)
- Shared Library:
~/.openclaw/erpclaw/lib/erpclaw_lib/ (installed by erpclaw)
Tables Owned (43)
Manufacturing (14): operation, workstation, routing, routing_operation, bom, bom_item, bom_operation, work_order, work_order_item, job_card, production_plan, production_plan_item, production_plan_material, subcontracting_order. Advanced Manufacturing (6): shop_floor_entry, tool, tool_usage, engineering_change_order, process_recipe, recipe_ingredient. Projects (5): project, task, milestone, timesheet, timesheet_detail. Assets (6): asset_category, asset, depreciation_schedule, asset_movement, asset_maintenance, asset_disposal. Quality (6): quality_inspection_template, quality_inspection_parameter, quality_inspection, quality_inspection_reading, non_conformance, quality_goal. Support (6): service_level_agreement, issue, issue_comment, warranty_claim, maintenance_schedule, maintenance_visit.
Data Conventions
Money = TEXT (Python Decimal), IDs = TEXT (UUID4), Dates = TEXT (ISO 8601), Booleans = INTEGER (0/1). All amounts use Decimal with ROUND_HALF_UP. GL entries and stock ledger entries are immutable.
Naming Series
Manufacturing: BOM-, WO-, JC-, PP-, SCO-. Advanced Manufacturing: SFE-, TOOL-, ECO-, RCPE-. Projects: PROJ-, TASK-, TS-. Assets: AST-, ASTC-. Quality: QI-, NCR-, QG-. Support: ISS-, WC-, MS-, MV-.
Script Path
scripts/db_query.py --action <action-name> [--key value ...]
