Item identity
Record code, description, unit and variant
ERP Guides
Inventory record keeping
How to Manage Item Records and Inventory Movements
Reliable inventory quantities depend on accurate item records and recording each receipt, issue or transfer. The item record defines what the product is; movement records show where the quantity came from, where it went and which document supports the transaction.
Physical location
Warehouse, bin and lot/serial if tracked
Transaction trail
Quantity, date, movement type and source document
Master data
What should an item record define?
Creating the same item under different names complicates search and reporting. Record codes and tracking attributes should also match the physical goods. Keep the fields needed by the process consistent instead of filling fields without a clear use.
Illustrative item record
Leather — Black / 1.2 mm
Base unitsquare metre
Variantcolour / thickness
Trackingbatch / lot
Barcode869…0428
This example shows how item fields might be grouped in a manufacturing business; actual fields depend on the tracking method in use.
Unique code and description
Set them so the same item is recognised in search, documents and reports.
Unit of measure and conversion
If purchasing, inventory and consumption units differ, define the conversion rule explicitly.
Variant and traceability
Use colour, size, dimension, lot or serial tracking where the item requires it.
Barcode and group
Match barcodes to item identity; organise groups for reporting and access needs.
Warehouse transactions
Record every movement with its direction and source
Movement type explains which transaction changed the quantity. Unreferenced or late entries can make the displayed balance diverge from the physical stock.
Goods receipt
Supplier delivery is linked to an order or dispatch line; accepted quantity and warehouse are recorded.
Dispatch / issue
Customer dispatch or production issue is linked to its supporting order or work order.
Warehouse transfer
Issue from the source and receipt at the destination are tracked under one transfer record.
Returns and adjustments
Retain the reason for a return, cancellation or approved adjustment and link it to the original transaction.
Movement history
The balance is the net effect of transactions
Example: with an opening balance of 120 units, a purchase receipt of 40 and a production issue of 25, the recorded balance is 135 units. Each line should show date, warehouse, quantity, movement type and source document so the balance can be traced. This example does not calculate inventory value or a count variance.
Illustrative movement trail
HAM-00428Opening balance
Warehouse A · 01 Jun
Purchase receipt
Warehouse A · 04 Jun · Dispatch 1832
Production issue
Warehouse A · 06 Jun · Work order 572
Recorded balance135 units
Record discipline
Controls that keep balances reliable
Record transactions when they happen
Align document dates with actual receipts and issues; make delays visible when entries are posted later.
Verify item and warehouse
Check barcode, code, variant, lot and destination warehouse before posting.
Reverse through a traceable entry
Instead of deleting a posted movement, use an authorised cancellation or reversal that retains the source link.
Separate permissions and approval
Define who enters and who approves adjustments, opening balances and exceptional issues.
Frequently asked questions about item records and movements
What should an item record contain?
Alongside a unique code and description, define the base unit, item group, tracking method and, where needed, variant, barcode and lot/serial details. Set required fields according to business use.
Why should an inventory movement link to a source document?
The source document shows which order, delivery, production job or approved adjustment caused the movement. This provides context when investigating a quantity difference or incorrect entry.
Can an item use more than one unit of measure?
When business processes require it, purchasing, inventory and consumption units can use a defined conversion. The conversion rule must be clear for the item and transaction, and the unit used must be visible on the record.
Does creating an item record create physical stock?
No. The record defines the item’s master data. Quantity is established through an opening balance or a valid receipt and changes through subsequent transactions.