The short answer

Hold every item in one base unit, the smallest unit anyone sells, counts or issues, and store each item’s own conversion to its packs and cartons as a whole number, such as 24 pieces to 1 carton. Give each unit its own price and barcode. Then count full cartons and loose pieces separately and let the system convert, so nobody multiplies in their head.

Key takeaways

  • Show the unit next to every quantity, because a right number in the wrong unit is wrong by the whole carton size.
  • Leave the base unit alone once stock has moved, since changing it rewrites every balance, cost and history line.
  • When a supplier changes the carton size, add a new unit and retire the old one once its stock sells through.
  • Set a price for each unit you sell instead of letting a system multiply, so a carton discount is a decision.
  • Record the piece and carton barcodes against their own units, so scanning a carton adds a carton, not a piece.

Where unit mistakes come from

Most distributors trade the same item in two or three units. The supplier sells cartons, the shop buys packs and the van sells single pieces. Every one of those lines carries a number and a unit, and a correct number in the wrong unit is wrong by the whole carton size.

The mistakes look small on screen and large in the stock. A rep who types 10 meaning cartons and records 10 pieces under-bills the customer and leaves the van count wrong for days.

TipShow the unit next to every quantity on screens and printouts, so nobody has to assume it.

Pick one base unit per item and keep it

The base unit is the unit stock is held and valued in. Choose the smallest unit you ever sell, count or issue, usually the piece, so every other unit is a whole number of it. If you sell single bottles from a van, the bottle is the base unit even if the warehouse never opens a carton.

Once stock has moved, leave the base unit alone. Changing it rewrites every balance, cost and history line, and the figures before and after no longer compare.

  • Piece or bottle for goods sold singly
  • Kilo or litre for goods sold by weight or volume
  • Pack only if a pack is never split
  • Never the carton if anyone sells less than a carton

Record each item’s own carton size

A carton is not a fixed size. One item’s carton holds 24, another holds 12, and the same supplier may ship 6 or 30. Store the conversion on the item, not as a company-wide rule, and write it as a whole number of base units, such as 24 pieces to 1 carton.

When a supplier changes the carton size, do not edit the old conversion while stock in the old cartons remains. Add a new unit for the new carton and retire the old one once it has sold through, so receipts and counts of the old cartons still convert correctly.

TipCheck the carton size printed on the first delivery against the conversion on file before posting the receipt.

Name units so nobody guesses

A unit’s name says what kind of pack it is, and the item’s conversion says how many it holds. Show both on order lines and pick lists, so a picker reads carton of 24 rather than just carton. A name like box tells nobody how many pieces are inside.

  • One list of units for the whole company
  • One spelling per unit, in both languages
  • No two names for the same kind of pack
  • Weight and volume units named by their measure
  • The pack size printed beside the unit on pick lists

Price each unit on purpose

A carton price is rarely just the piece price times the carton size. Distributors usually give a little back for buying whole cartons, and charge a little more for breaking them. Set a price for each unit you sell, rather than letting a system multiply, so the difference is a decision and not an accident.

TipReview piece and carton prices together, so a change to one does not make the other look cheap by mistake.

Give each unit its own barcode

Most manufacturers print one barcode on the piece and another on the carton. Record both, each against its own unit, so scanning a carton at the dock adds a carton and not a single piece. A barcode recorded against the wrong unit is a unit mistake that repeats on every scan.

Check too that each barcode belongs to one item only. A code reused for a new flavour or size sends every scan to the old item.

Count in the unit on the shelf

Counters see full cartons and loose pieces, not totals. Let them enter each separately and let the system convert, rather than asking them to multiply in their heads. The same goes for receipts: receive in the unit on the delivery note.

TipKeep each item’s opened cartons in one place, so loose pieces are counted once and never missed.

Checklist: Units checklist

  • Choose a base unit for every item
  • Make it the smallest unit anyone sells or counts
  • Record each item’s carton and pack sizes
  • Add a new unit when a supplier changes the carton
  • Keep one list of unit names
  • Set a price for each unit you sell
  • Record a barcode against each unit
  • Count full cartons and loose pieces separately

In Axon Suite

How Axon Suite handles it

In Axon Suite each item holds its stock in one base unit and has its own conversion to every other unit it is traded in, stored as a whole-number ratio such as 24 to 1. Orders, receipts, transfers and counts take any unit the item converts, a line in a unit with no conversion is refused, and the base unit cannot change once stock has moved. A price list holds a price per item and unit, and each barcode is tied to one of the item’s units.

Feature

Buy by the carton, sell by the piece

Each item keeps its stock in one base unit and has its own conversions to every other unit it is traded in. A line in cartons lands in stock as pieces, and the numbers always agree.

Open: Buy by the carton, sell by the piece
Feature

Several barcodes per item

An item can carry several barcodes, each tied to one of its units, with one marked as its main barcode. Reps scan that barcode with the phone camera to find the item in the catalogue or in the van’s stock, even offline.

Open: Several barcodes per item
Feature

Price lists by customer and quantity

Build sales and purchase price lists in their own currency, with or without VAT in the price, valid between two dates. Give a customer or vendor a list of their own or let them trade on your default, and price each item by unit with lower prices from a quantity up.

Open: Price lists by customer and quantity
Feature

Cycle counts that post the difference

Open a count for a warehouse or a single bin and fill the sheet from what the books hold. Counters enter what they find, a reviewer approves, and the difference posts as one adjustment at cost.

Open: Cycle counts that post the difference

Before you go

Questions owners ask

What if a supplier changes the carton size?

Add a new unit for the new carton and keep the old one until its stock has gone. In Axon Suite conversions belong to the item, so each item holds a conversion for every unit it is traded in.

Should we count in cartons or in pieces?

In whatever is on the shelf, each entered separately, then converted to the base unit. Asking counters to multiply in their heads is where count errors start.

Can two items have different carton sizes?

They should be able to. In Axon Suite conversions belong to the item, so one carton can hold 12 and another 24.

Glossary

Terms in this guide

Open the glossary

See your own van sale reach the ledger in 30 minutes.

Chat on WhatsApp