Skip to content

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 modeYou typeThe quantity is
Linearunits and lengthunits × length
Areaunits, length and widthunits × length × width
Volumeunits, length, width and heightunits × 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:

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:

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?

More about Invoicing