In this guide 6 sections
Split each quotation into three steps. Draft, review and release. The model fills only the fields that come from your catalogue and price list, reading the enquiry and matching each line to an item. Discounts, dates and special terms stay blank. A named approver signs off. No quote leaves without that name.
Decide what the model may fill and what it must not
List every field on the quotation form, then sort each into one of two piles: facts held in your item master, and promises that only a person can make.
Catalogue facts are safe to fill. Part number, drawing revision, unit of measure, standard rate and tax code all come from the item master that your accounts and stores teams already maintain. Promises are not safe.
Discount, delivery date, payment terms, minimum order quantity and any claim about fitness for a particular use stay blank until a human completes them. A lead time copied from last year looks harmless, yet it becomes a dispute once the customer holds the PDF and your stores cannot ship the casting. Blank is better than wrong.
- Fill: item code, drawing revision, unit, list rate, tax code
- Fill: ship-to address and credit terms from the account record
- Leave blank: discount or special rate against a rate card
- Leave blank: delivery promise, incoterm and validity period
- Leave blank: warranty, tolerance or performance statements
Draft from the enquiry, matched to the catalogue
Drafting begins with the customer’s request for quotation, which may arrive as a scanned PDF, a spreadsheet with a bill of materials or three lines typed into a mail. The software extracts items and quantities.
Each requested line is matched to the catalogue by description and part number, with the drawing revision checked where the enquiry quotes one. A weak match gets no guess. The line is marked unmatched, and the two closest candidates are offered, so the reviewer picks one in a click instead of searching the whole catalogue by hand.
Rates come from a price list lookup. Nothing is calculated or invented. An item with no rate stays empty, so the gap shows on the screen instead of hiding inside the grand total of a quotation that looks complete.
Review is where the named approver comes in
Name one approver per quote band. Small routine quotes may go to a sales coordinator, while large or custom ones go to the sales head or the owner. Write the bands down.
The approver sees the draft beside the original enquiry, with unmatched lines and blank promise fields highlighted so that nothing needing a human decision can be skimmed past. They fill the discount and the delivery date, check the freight terms and incoterm, then confirm or reject the draft with a note that the sales coordinator can read.
Never release from the drafting screen. Release needs an approval record with a name and a time, so a disputed quote traces back to the person who signed it. Give each band a deadline too, because a quote parked two days with the sales head loses to a competitor who answered the same enquiry that same morning.
- Enquiry and draft side by side
- Unmatched lines in a separate list
- Discount field with the permitted band shown
- Approve, return with note or reject buttons
Release with a record, then learn from edits
Once approved, the system builds the PDF on your letterhead and sends it from the sales mailbox to the buyer who raised the enquiry. A filed copy carries the approver’s name.
Log every edit the approver makes. When the same description keeps changing or the same unit keeps getting fixed, the catalogue entry needs attention, not the software. That is a master data problem. Version the price list and tag each released quote with the list it used, so any old quotation can be reproduced exactly as it left the building.
Start with one product family
Resist switching on the whole catalogue. Pick one product family with clean master data and a steady flow of enquiries, such as fasteners, cable glands or hydraulic fittings, and begin there.
For a fortnight, let your team keep quoting by hand while the model drafts the same enquiries in parallel, so nothing the model drafts reaches a customer. Compare each draft with the manual quotation and count the corrections by field and by customer, which shows which catalogue entries and which buyers cause the most rework.
This week, write down every quote field and mark each as fill or leave blank, using a pencil and the last ten quotations you sent. That sheet becomes your specification.
Quotation field rules sheet
One sheet, ruled with a line for each quotation field, and columns for field name, source, who may fill it and whether the model may touch it. A second block lists approver bands by quote size, with the name, backup name, response deadline and discount limit for each. Print it. Pin it.
Open a blank worksheet to printQuestions owners ask
Can the model suggest a discount?
It can show earlier discounts given to the same customer as a hint, for example the last three quotes with their final rates and the order values behind them. The approver still types the number. A hint must never become a promise.
What if the customer asks for an item we do not stock?
The draft marks the line unmatched. The approver can substitute a similar item, ask the foundry or supplier for a rate, or drop the line and tell the buyer why it is missing. Never invent a part number.
Does this work if our price list is in a spreadsheet?
Yes, provided each item has a unique code and each rate has a valid from date that your accounts team keeps current. Clean the sheet first. Duplicate rows and blank units produce wrong lines, because the software copies every row faithfully, including the careless ones that nobody has noticed.
Who approves when the named person is away?
Name a backup for every band. A quote should wait for a named person rather than slip through because the usual approver was on a plant visit.
