Camco Industries Ltd — Cambridge, NZ
Engineering dashboard β the sign-off queue (jobs referred or flagged from Sales Check), line-level flags, the BOM-not-ready backlog, and live BOM change activity from AMS.
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.
Engineering change requests β replaces the IR11 paper form and the ECR register. Every request is captured and categorised; ones that need no action get an outcome and a reason instead of being binned.
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.