Warehouses, bins and the stock ledger

Why stock is a ledger of movements, not a number you overwrite.

Baca dalam Bahasa Indonesia

On this page
  1. Warehouses
  2. Bins
  3. The movement types
  4. Why you cannot edit a movement
  5. Negative stock is refused
  6. Reading stock
  7. In Voltrus
  8. Checklist

In a spreadsheet, stock is a number in a cell. When something arrives, someone adds to it; when something leaves, someone subtracts; and when the count does not match the shelf, someone types the shelf number over it. After a few months nobody can explain how the number got there.

An ERP treats stock the way a bank treats your account: as a ledger of movements. Each receipt, issue, shipment, transfer and adjustment is a dated row with a quantity, a location and a reason. The quantity on hand is not stored anywhere to be overwritten; it is the sum of the rows. If you want to know why there are 260 units, you read the movements that add up to 260.

Warehouses

A warehouse in an ERP is a stock location the books track separately. It may be a building, a room or a virtual location. In Voltrus each warehouse has a kind:

KindUseCounts as available?
internalNormal storageYes
wipMaterial at the production lineYes
quarantineGoods on hold for inspectionNo
transitGoods on the road between sitesNo
subcontractorYour material held at a subcontractorNo

The MAIN warehouse always exists. Quarantine, transit and subcontractor stock is still valued (it is still your inventory on the balance sheet), but it is left out of available stock and MRP, so nobody promises a customer goods that are on hold or on a truck.

Bins

A bin is a location inside a warehouse: a rack, a shelf, a floor zone. Bins are optional. Movements, receipts, transfers, counts and picks can name a bin; outbound stock is checked against a bin's own balance only when a bin is named. Bins never affect the general ledger, because they do not change what you own, only where it sits.

When goods arrive on a purchase order, the Receive goods dialog asks per line for the quantity actually unloaded (a partial receipt keeps the rest open), the warehouse and bin it goes to, and the lot or serial numbers if the item is tracked. That is the moment to put stock in the right place, because every later movement starts from it.

Use bins when the warehouse is big enough that people waste time searching, or when you count by area. A small store room does not need them.

The movement types

Every row in the stock ledger has a type that says why stock moved:

MovementCreated byDirection
receiptGoods receipt on a PO, opening stockIn
issueMaterial issued to a work orderOut
produceWork order outputIn
shipShipping a sales orderOut
returnCustomer return (with its RET document), material returned from a work orderIn
transferStock transfer (one row out, one row in)Both
adjustManual correction, count varianceEither
scrapWrite-off of damaged or rejected goodsOut

Most movements are created by documents. Only adjustments and scrap are posted by hand, and both post an inventory journal at the same time, so the stock value in the ledger always equals the stock account in the general ledger.

Why you cannot edit a movement

Voltrus's stock ledger is append-only: a movement row is never updated or deleted. If a receipt was posted to the wrong warehouse, the fix is a transfer; if a quantity was wrong, the fix is an adjustment or a return. Each correction is its own row with its own reason, user and time.

That is the same principle as never editing a posted journal. It is what lets the system answer "what did we hold on 30 June?" correctly a year later, and what auditors test when they sample inventory.

Negative stock is refused

Some systems let stock go below zero "temporarily" so that a shipment can be posted before the receipt is entered. Voltrus does not, anywhere: shipping, consuming, returning to a supplier and transferring all check the quantity on hand, and fail if it is not there.

That feels strict on day one. It is good practice because negative stock has no cost: the system has to guess what the goods were worth when they shipped, and the guess is corrected later with a variance nobody can explain. The rule forces the real sequence: receive first, then ship. When a shipment is refused, the fix is almost always a receipt that should have been posted already.

Reading stock

On hand is the sum of movements per item, warehouse and (if used) bin, lot or serial. Available is on hand in nettable warehouses minus quantities already reserved for work orders. MRP and sales promises use available, not on hand.

In Voltrus

Checklist

  • Map each physical site and each stock status (quarantine, in transit, at subcontractor) to a warehouse.
  • Use bins only where people search for goods or count by area.
  • Post receipts at the moment goods are unloaded.
  • Fix wrong movements with a transfer, return or adjustment, never by asking IT to "change the number".
  • Give every manual adjustment a reason (see Transfers, stock counts and cycle counting).

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