Camco Industries Ltd — Cambridge, NZ
Bruce's Camco Hub on PythonAnywhere — task boards, timesheets, CPQ quoting and ECRs. The Engineering dashboard and ECR modules that used to sit here now live in the Hub. Staging is Bruce's pre-release copy for trying changes before they go live.
Block your day out in 15-minute slots in the morning, time it with Clockify as you go, then close it off at the end of the day and see how the plan held up. Yours alone — nobody else sees it.
This month's schedule, read from the Smartsheet production schedule and MB_ERP together — jobs due, vehicles arriving, runs and plans. Where the two disagree about a date it says so rather than picking one.
The afternoon sales KPI report, live: orders received against break-even and target for the month, GP% on orders, drawer and stealth counts, Sales Analysis totals ready to paste into the email, and every order this month with its margin.
Log the plans sales asks for and track what came of them. Conversion is worked out automatically from the quote → job link, so you can see the hours spent on plans that never turned into work.
Price a fitout transfer from one vehicle to the next. Pulls the job's details out of ABM, then prices the refurb item by item with live costs and margin — replaces the fitout transfer spreadsheet and the old flat fee.
Search every quote synced from ABM, and build new ones. The Quote Builder sends a quote straight to ABM as a real sales quote — ABM allocates the SQ number — with a live cost and margin on every line and dead or superseded codes flagged before it goes out.
View and search all sales orders / fitout jobs from AMS. Synced from CCISVR1 into local SQLite.
Browse products synced from AMS, view BOM trees, add ghost products, and edit local data without touching CCISVR1.
Manage vehicle fitment codes — define makes, models, series, cab types and year ranges. Link products to fitment codes in the Products module.
Track incoming vehicles for active jobs — ETA, arrival status, cab config, GVM upgrade, sign writing, and E-Road status. Replaces the Smartsheet arrival tracker.
Browse the full customer list synced from ABM — search by name or code, filter by group or account manager, and view job/quote history per customer.
Browse all suppliers linked to products — search by name or code, see what each supplier provides, preferred status, part numbers, and cost pricing.
Before printing a pick list — check whether the production run still matches the BOM. AMS freezes the BOM onto the run when it starts, so any change made since is invisible on the pick list. Enter a JC number and it lists exactly what moved, per product.
Full audit trail from AMS — BOM creates/deletes, Build ↔ Explode switches, component edits, plus an ABM parts-master tracker (Status / Title / Notes / Remarks edits + new parts, who & when). SQL triggers on CCISVR1, live. Searchable.