How do I sell by the metre, by area or by volume?
Some items aren’t sold as individual units: a board is sold by the metre, a carpet by the square metre, a block by the cubic metre. For those items the line quantity isn’t typed: it comes from the units and the measurements. This page explains how it is turned on and how it is typed.
What does the program calculate?
The line quantity is units × length × width × height, with the measurements the item uses:
| Item mode | You type | The quantity is |
|---|---|---|
| Linear | units and length | units × length |
| Area | units, length and width | units × length × width |
| Volume | units, length, width and height | units × length × width × height |
Whatever is left empty counts as 1. Three boards of 2,5 metres are 7,5 metres; two pieces of 1,5 × 2 are 6 square metres. The line price is always per metre, square metre or cubic metre: the calculated quantity multiplies that price.
How is it turned on?
There are two places, and one is enough:
- On the item record, in the Quantity calculation field (financial details tab):
Linear,AreaorVolume. It is the normal way when only some items are sold by measurements. In the same place are Length multiple, Width multiple and Minimum quantity, which are explained further down. - In Settings → Invoicing → Sale by measurements, if the whole company sells this way (a joinery, a board warehouse). That mode applies to items whose record doesn’t say anything; an item with its own mode uses it even if the company is on ‘By units’.
As soon as measurements are active —for the company or for some item— the document grid shows the Units, Length and, depending on the mode, Width and High columns, before the quantity. With no measurements active the measurements don’t appear and everything stays as always.
Without measurements, the Units column exists but starts hidden: you show it from Columns. It is the ‘Units’ column of the desktop ERP, and the migration brings what it had. It accepts decimals and doesn’t change the quantity: it is just another figure on the line.
How do I type a line?
With measurements active, the Enter route on a new line is units → length → width → height → code. The quantity fills in on its own when you confirm each measurement, and it is recalculated when the code is resolved, because each item has its own rounding.
You can type in whatever order you like: first the code and then the measurements, or the other way round. And the quantity can still be edited: if you type the quantity directly on a line that already has measurements, the program redoes the units (quantity ÷ measurement, rounded to a whole number) and respects the quantity you have entered.
If a linear item gets a width, or an area item gets a height, the cell doesn’t accept it and says so: ‘This item is sold by linear: it has no width.’. Leaving the cell empty and carrying on with Enter gives no warning.
What are the multiples and the minimum quantity on the record?
They are three item settings that act on each measurement before multiplying:
- Length multiple and Width multiple: the length and the width are rounded up to that multiple. With a multiple of 0,5, a length of 2,3 becomes 2,5 (the cut is charged in full). At zero, the measurement is taken as it is.
- Minimum quantity: the measurement of one unit doesn’t go below it. With a minimum of 1 and a piece of 0,5 × 0,5 (0,25 m²), each piece is charged as 1 m².
- Measurement rounding (in Settings → Invoicing): the multiple for the height and for the length and the width of items that don’t have their own. At zero, no rounding.
Measurements are saved already rounded, so what you see on the line is what has been charged.
What happens with stock and with older documents?
Stock moves by the calculated quantity, in the item’s unit (metres, square metres…), exactly the same as on a normal line. The units and the measurements stay saved on the line, carry over when the document is converted and can be seen when it is reopened.
Documents imported from the Desktop ERP keep their units and their measurements just as they were; their quantity isn’t recalculated.
What doesn’t it do?
- Selling by weight (kilos) and invoicing by pieces are something else and aren’t covered here.
- An item’s mode doesn’t limit the company’s: if the company is on volume and the item says linear, the line only accepts the length. It is the item that takes priority.
More about Invoicing
- How do I delete a document?
- How do I make the consignment note for a shipment?
- How do I charge shipping or expenses without VAT?
- Setting up numbering series
- How do I convert several documents at once?
- Why is my invoice one cent out and how do I fix it?
- How do I turn a quote into a sales order, a delivery note or an invoice?
- Can I leave a document half-done and go to another screen?
- How do I issue an invoice?
- How do I deliver a sales order in several deliveries?
- How do I invoice a fee that repeats every month?
- How do I invoice several delivery notes at once?