Case study 10 · Industrial Repair · Service register

A handwritten spec at nine in the evening, a live service register by half past ten.

Techsol Automation repairs variable-frequency drives and PLCs. Every job is the same shape: a drive comes in from a party with a delivery note, gets diagnosed, gets quoted, gets repaired, and goes back out with a challan and an invoice. The record of all that lived in a paper register and a challan pad.

The owner wrote what he wanted on a few pages by hand. That PDF was the whole specification. The Service Register was built from it and live at techsol.dotsai.cloud the same evening, and he has run the shop on it since.

Client

Techsol Automation

Industry

VFD & PLC Repair Services

Location

Gujarat, India

Workflow

O · Inward → quotation → outward

32 min

From the spec arriving at 21:53 to version one shipped at 22:25 on 29 August 2026.

Gapless

Every inward job gets the next serial automatically — no skipped or duplicate numbers, ever.

A4 challan

Version 1.1 prints the delivery challan on Techsol's own letterhead, numbered from the last page of the old pad.

What we shipped · 7 pieces

Inward: party and location, material, the party's delivery note number and date, the fault — with suggestion chips from past faults on the same material — and photos or a PDF from the phone.

An internal serial that is generated by the database, so it cannot skip or repeat.

Quotation: number, date, amount and a PDF, recorded against the job.

Outward: delivery challan and invoice as PDFs, with status derived from what has been filed rather than set by hand.

An attachment store for bills and an append-only remark log per job.

Version 1.1: printable A4 delivery challan on the Techsol letterhead, the shop's own TA-/R- numbering, free-of-charge return service, party GSTIN and print-time GST.

Phone-photo uploads that actually arrive — the server's default upload limit was raised before handover, because a repair shop's evidence is pictures.

01 — The challenge

A register, a challan pad, and a memory for repeat faults.

Inward entries went into a book. Challans came off a numbered pad — the photo of the next blank sheet, number 2293, is what set the app's first challan number. Whether this drive had come in before with the same fault depended on who was in the shop that day. Bills and photos sat wherever they landed.

The owner did not want an ERP. He wanted the register, with the numbering he already used, that never loses a page.

02 — What we built

Build exactly the pages he drew, then let the database keep the numbers.

The handwritten spec arrived at 21:53 on 29 August 2026. By 22:25 version one was live: inward, quotation and outward as three steps on one job, the serial minted by the database, status derived from which documents exist, attachments and remarks on every row.

On 18 September the owner sent a photo of the paper delivery challan he still liked, and five rounds that afternoon and evening produced version 1.1: a printable A4 challan on the Techsol letterhead, his own TA- and R- numbering carried into the app, a fault box on the print, no future dates, and a free-of-charge flag for return service. No inline editing in lists — a row is opened, changed in a dialog, and saved.

03 — The results

The shop runs on the register, daily.

Techsol has been filing real jobs on the register daily since 18 September 2026. Each job carries its own serial, its documents and its history, and a repeat fault on the same material is suggested the moment the material is typed.

The lesson for any small service business: the spec you write by hand is enough, if the person building reads it as the whole truth and ships the same day.

Before · After

Techsol Automation's job record: before vs after the Service Register
Metric	Before	After
Inward record	Paper register	One job with inward, quotation and outward
Serial numbers	Written, occasionally skipped	Generated by the database, gapless
Repeat faults	Remembered by whoever was in	Suggested from history when the material is typed
Challan	Numbered pad	A4 print on the letterhead, same numbering

Running a repair shop on a register and a pad?

Photograph the pages. We build the same pages as software, usually the same day.

Book a meeting →