Aantar

Aantar Books

Units of measure and larger units

Count an item in one unit (each, kg) and also buy and sell it in larger units such as a case, sized for the whole company or for each item, with the price and the stock converted for you.

Where: Lists ▸ Unit of Measure List (also Menu ▸ Admin ▸ Units)

Every item is counted in its own unit: each, piece, kg, metre. Stock on hand, costs and every report are kept in that unit.

Many items are also bought or sold in a larger unit: a case, a box, a pallet. The units themselves belong to the company: you make Case once. How many pieces make one case can be set in one of two places:

  • For the whole company, on the unit: Case is made of Each, 10 to a case. Every item counted in Each can then be sold by the case of 10.
  • For each item, on the item: one Case for the company, which is 12 Each on one item and 6 Each on another. Use this when the same word means a different size for different items.

After that every sales and purchase form lets you pick the unit on each line, in the U/M column, and Aantar Books does the conversion.

An example

You buy cumin in cases of 12 and chilli powder in cases of 6. You sell both by the case, but sometimes a customer wants 6 pieces out of a case.

  1. In Lists ▸ Unit of Measure List, you have Each (ea). Add Case (cs) and leave Made of on Its own unit: the size is set on each item.
  2. Open cumin's item form. Under Units for this item click Add a unit, choose Case, and type 12 in 1 Case =. Set Sales lines start in and Purchase lines start in to cs (12 ea), then save. Do the same for chilli powder with 6.
  3. On the supplier's bill, a new cumin line opens in cs. You enter 5 at the supplier's price per case, $60.00. The shelf goes up by 60 ea, and each one costs $5.00.
  4. On an invoice, a new cumin line opens as 1 cs at the case price: twelve times the each price. Stock goes down by 12 ea.
  5. For 6 pieces, pick ea in U/M on that line and enter 6. Stock goes down by 6 ea; the case you opened is now 6 pieces on the shelf.

What is on the shelf is shown in each, with the cases and pieces beside it: 42 (3 cs 6 ea).

Setting up units

Choose Lists ▸ Unit of Measure List (the same list as Menu ▸ Admin ▸ Units), then Add Unit.

Field What to enter
Unit name The full name, for example Case. A name already in the list, in any capitals or spacing, is refused.
Short name What the U/M column and printed forms show, for example cs.
Allow decimal quantities On when you sell part of this unit, for example 0.5 kg.
Made of (for a larger unit) For a size that is the same on every item: the unit this one is a multiple of, for example Each. Leave it on Its own unit for a unit items are counted in, and for a unit whose size is set on each item.
How many … make one With Made of chosen: how many of that unit make one of this, 10 for a case of 10. Must be more than 0 and not 1.

The list shows a company-sized unit as, for example, 1 cs = 10 ea.

A company-sized unit is made of a unit items are counted in, never of another larger unit. To have a box of 12 and a carton of 48 of the same item, make both of them out of Each.

The item's own sizes

On the item form (Edit Product, and the New product window), Units for this item lists each unit the item converts itself.

What you see What it does
Add a unit Pick any unit of the company. A unit already made of the item's own unit starts at its company size; any other starts empty for you to type.
1 Case = [ ] ea How many of the item's own unit make one of this unit, for this item only. More than 0, and not 1.
Price per cs The selling price of one case. Typing it sets the item's Selling price to that over the number of pieces: a case at $120.00 of 12 makes the each price $10.00. Change the each price and the case price follows.
Cost … a cs The item's cost times the case size, to compare with the supplier's case price.
× Takes the unit off this item.
Sales lines start in The unit a new line of this item opens in on invoices, sales receipts, credit memos and Batch Invoices. The item's own unit unless you choose another.
Purchase lines start in The same, for bills, purchase orders and vendor credits.

An item's own size wins over the company size of the same unit.

Important: Once a sale or a purchase of an item has been entered in a unit, how many make one of that unit is fixed for that item: those documents are stored in the item's own unit and read back through it. Saving a different number, or taking the unit off, is refused with Add a new unit for the new size instead. Another item that never used the unit can still change. The same rule fixes a company-sized unit once any document used it.

Which units an item offers

An item offers its own unit, every unit it converts itself, and the company-sized units made of its own unit. To narrow the company-sized ones, tick under Also sold and bought in on the item form the ones this item comes in. With none ticked, all of them are offered. Units the item converts itself are always offered.

The U/M column on a line

On Create Invoices, estimates, sales orders, Enter Sales Receipts, Create Credit Memos/Refunds, Enter Bills, purchase orders and Enter Vendor Credits, the U/M column shows the line's unit. When the item has larger units, the unit has a small arrow: click it and pick the unit.

  • A new line opens in the item's Sales lines start in or Purchase lines start in unit, at that unit's price. Adding the same item to a line already there keeps that line's unit.
  • The quantity stays as you typed it, now counted in the new unit.
  • The price follows the unit: an each at $10.00 becomes a case of 12 at $120.00, a case cost of $60.00 becomes an each cost of $5.00. Change the price afterwards if a case sells for less than twelve singles.
  • A fixed discount on the line follows the unit too; a percentage stays as it is.
  • When the document is saved, stock moves in the item's own unit: 1 case takes 12 each off the shelf, 5 cases on a bill put 60 each on it.
  • Reopening the document shows the line in the unit it was entered in, at that unit's price. A printed invoice prints it the same way.

Adjust Quantity/Value on Hand and Transfer Inventory have a U/M column too. Pick cs and type 3: the quantity (or the counted New qty) and the cost are in cases, and Aantar Books records 36 each at the each cost, because stock is kept in the item's own unit.

Stock in cases and pieces

Stock is always kept in the item's own unit, and is shown with the whole cases and the pieces left over beside it, never as a fraction of a case:

  • On the Item List, the Stock column reads, for example, 42 (3 cs 6 ea).
  • In Product 360, under the stock at this location and at all locations.
  • On the Inventory Valuation Summary, Stock Status by Item, Stock by Location and the Physical Inventory Worksheet, in an In larger units column. See Inventory reports.

It is told in the item's Sales lines start in unit when that is a larger one, otherwise in its largest unit. Stock below zero reads, for example, -(3 cs 6 ea).

Related articles

Something unclear or out of date? Write to support@aantar.com and name this page.