Inventory & Operations

Know what you have. Where it is. What it is worth.

See stock quantities by item and warehouse, the movements that changed them, and the value recorded for them, in one connected inventory record.

Distribution centre loading bays at blue hour

Inventory movements

Inventory movements

Follow stock from receipt to use or dispatch.

Each movement shows what changes in the warehouse and whether it creates an accounting entry. Reservations and transfers between your own warehouses do not.

Stock movements · illustrative
  1. Receive

    Goods receipt adds quantity at a warehouse

    Accounting entry at the time

    Stock value recorded at the receipt value

  2. Transfer

    Quantity moves between warehouses of the same company, via in transit

    No accounting entry

    Value travels with the goods at their average cost

  3. Reserve

    Quantity is set aside for a customer order or other demand

    Changes availability only

    Nothing is posted; ownership and value are unchanged

Then one of two routes:

  1. Issue to production

    Materials move into work in progress for a work order

    Accounting entry at the time

    Value moves from stock into work in progress

  2. Dispatch to a customer

    Goods leave the warehouse against the order

    Accounting entry at the time

    Stock reduced and cost of sale recorded at average cost

Not every item takes every step, and entries are made when each movement happens, not at the end. Returns, damage write-offs and stock counts are recorded as further movements.

Inventory position

Quantity and value on the same record.

Available stock is calculated, not typed in: usable stock on hand, less anything quarantined, damaged or in transit, less what is already reserved or allocated.

  • Work in progress is tracked as its own stock state, not as on-hand stock
  • Expected supplier receipts are shown separately from stock already held
  • Recorded value comes from the same movements as the quantity
Inventory position · illustrative

One company · 4 warehouses · one item family counted in units · at 31 March · GBP, weighted average cost

On hand
18,420
−Quarantined or damaged
240
−Reserved
2,400
−Allocated
750
=Available
15,030
Recorded stock value (on hand)
£1,842,600
Illustrative figures, not customer data. Work in progress and expected supplier receipts are shown separately and are not part of these quantities or this value. Reserved and allocated together total 3,150.

Warehouses

Every warehouse, within one company.

The inventory screen lists positions by item and warehouse, and the movements screen shows each transfer between them. A transfer within a company keeps its value and creates no accounting entry.

Stock by warehouse · illustrative

The same company and date as the position above, in units and GBP

  • Main distribution centre

    On hand
    9,240
    Restricted
    120
    Reserved
    1,360
    Allocated
    420
    Available
    7,340
    Value
    £918,400
  • Northern warehouse

    On hand
    4,610
    Restricted
    60
    Reserved
    560
    Allocated
    180
    Available
    3,810
    Value
    £462,100
  • Southern warehouse

    On hand
    3,120
    Restricted
    40
    Reserved
    400
    Allocated
    130
    Available
    2,550
    Value
    £318,700
  • Production store

    On hand
    1,450
    Restricted
    20
    Reserved
    80
    Allocated
    20
    Available
    1,330
    Value
    £143,400
  • Company total

    On hand
    18,420
    Restricted
    240
    Reserved
    2,400
    Allocated
    750
    Available
    15,030
    Value
    £1,842,600
Illustrative figures, not customer data. Available = on hand − restricted − reserved − allocated.

Cost and value

Stock is valued at weighted average cost.

Each receipt updates the item's average cost. Issues, dispatches, transfers and write-offs use that average, and production output carries the cost of the materials, labour and overhead recorded against its work order. Receipts, issues to production, dispatches, returns and adjustments post entries when they happen; the stock ledger is reconciled to the ledger control accounts. Recorded value is a cost measure, not a sale value or a cash balance.

Production floor with materials staged for the next run

Availability & fulfilment

What you hold, what is spoken for, and what is on its way.

Availability shows the current position. Expected receipts are listed with their next expected date, but are not added to what can be reserved today.

What is on hand?
Quantity and recorded value by item and warehouse.
What is reserved?
Quantity set aside or allocated against demand.
What is available?
Usable stock less reservations. A reservation that would exceed it is refused.
Where is it held?
Each warehouse, plus stock in transit between them.
What is expected?
Open supplier order quantities and the next expected date, shown separately from stock held.
What is restricted or short?
Quarantined and damaged stock, and items below their reorder point.

Business outcomes

What changes for the business.

Stock visibility

Quantity and value by item and warehouse, including stock in transit and restricted stock.

Reservations

Stock set aside for demand is held against what is usable, and over-reservation is refused.

Movement history

Every receipt, transfer, issue, return and adjustment kept in order, with a link to any entry it made.

Recorded value

Stock valued at weighted average cost and reconciled to the ledger control accounts.

See inventory and operations in action.

A guided walkthrough of receipts, reservations, transfers, dispatch and the recorded stock value.