Items, item types and units of measure

Setting up items once, properly: types, units, conversions and planning fields.

Baca dalam Bahasa Indonesia

On this page
  1. What makes a good item code
  2. Item types
  3. Units of measure and conversions
  4. Cost
  5. Planning fields
  6. Tracking
  7. In Voltrus
  8. Checklist

The item master is the most-read table in any ERP. Every purchase order line, sales order line, bill of materials, stock movement and journal for inventory points at an item. If the item is set up badly (two codes for the same bolt, the wrong unit, no cost), every document built on it inherits the mistake.

In a spreadsheet, an item is usually just a name in a column, spelled slightly differently on each sheet: "Baut M8x20", "BAUT M8 X 20", "bolt m8-20". An ERP needs one code per thing you stock, buy or sell, and it needs to know a few facts about that thing before anyone can transact with it.

What makes a good item code

The SKU (stock keeping unit) is the item's permanent key. A few rules that consultants apply everywhere:

  • One code per physically different thing. If two products are interchangeable on the shelf, they are one item. If a customer or an inspector would care about the difference (size, grade, colour), they are two.
  • Do not encode too much meaning. A code like RM-STL-PLT-3MM is readable, but long "intelligent" codes break when the classification changes. Keep the code short and stable; put the details in the name and fields.
  • Never reuse a code. When an item is discontinued, mark it inactive. Its history (receipts, sales, costs) must still point to the same code.
  • Name it the way people search. Noun first, then attributes: "Bolt hex M8 x 20 zinc", not "Zinc-plated hex bolt for frame".

Item types

Item type tells the system how an item is used. Voltrus has three:

TypeUsed forTypical flow
rawRaw materials and bought-in componentsBought on a PO, consumed by work orders
finishedProducts you make (or buy) and sellProduced by work orders or bought, shipped on sales orders
consumableSupplies used up in operationsBought and issued, not built into products

Other ERPs also have service, phantom (a sub-assembly that is never stocked) and kit types. Voltrus does not. Services you sell or buy are best invoiced as standalone invoice lines rather than as stocked items, and a sub-assembly is modelled as a finished item with its own bill of materials.

Units of measure and conversions

Every item has one base unit (uom): the unit stock is counted and valued in. Choose the smallest unit you ever count, because stock can only be as precise as its base unit.

Suppliers and customers often trade in other units. Cable is stocked in metres but bought by the 100 m roll; screws are stocked as pieces but sold by the box of 200. In Voltrus each extra unit is an item unit conversion: one row says 1 of this unit = factor × base unit.

ItemBase unitAlternate unitFactor
CABLE-NYM-3x2.5mROLL100
SCREW-M4x10pcsBOX200
PAINT-WHITElPAIL20

Purchase order, sales order and BOM lines can then be written in the alternate unit. A PO for 5 ROLL of cable receives 500 m into stock, because stock always moves in the base unit. Prices on the line follow the line's unit.

Cost

The item's unit_cost is the value the system uses for inventory under moving average and standard costing, and the starting point for cost roll-ups. On import it is your best current cost; afterwards it is maintained by the system (moving average re-prices it on each receipt) or by a released standard cost estimate. How each method works is explained in Inventory valuation.

Planning fields

These fields decide how the system suggests replenishment. They can be filled later, but an item with none of them will never trigger a purchase suggestion.

FieldMeaning
planning_methodmrp (default): plan from demand. reorder_point: min/max. none: never suggest.
reorder_pointThe "min" for reorder-point items.
max_qtyThe order-up-to level for reorder-point items.
safety_stockA buffer MRP tries to keep on hand.
lead_time_daysDays from ordering to receiving (if no supplier lead time).
min_order_qty, order_multipleSuggested quantities are rounded up to the minimum, then to the multiple.

Per-warehouse overrides live in item warehouses, and the supplier's own lead time and part number in item suppliers. Reorder points, safety stock and lead times explains how to set the numbers.

Tracking

The tracking field is none, lot or serial. Lot tracking records a batch number (and optionally an expiry date) on every movement; serial tracking records each unit individually. Decide this at setup: it changes what the warehouse must record on every receipt and shipment. See Lots, serials and quality inspection.

In Voltrus

Checklist

  • Clean duplicates out of your item list before importing.
  • Pick a short, stable code scheme and write it down.
  • Choose each item's base unit as the smallest unit you count.
  • Add unit conversions for every unit a supplier or customer uses.
  • Decide lot or serial tracking per item before the first receipt.
  • Fill planning fields for at least your top 20% of items by value.

Run it in Voltrus ERP

Everything in these guides is built in: documents that post to the ledger as they happen, Indonesian tax, MRP and costing, with AI agents that propose and people who approve.

See Voltrus ERP