Stock
Item, Warehouse, and every movement of quantity and value — Stock Ledger Entry, Bin, batches, serials and reconciliation.
Item movement and valuation: warehouses, batches, serial numbers, stock entries, delivery notes, purchase receipts, and the Stock Ledger Entry that mirrors GL Entry for quantities.
What it does
Stock owns the Item master and the physical truth of inventory. Every movement — receipt, delivery, transfer, repack, manufacture — writes rows into Stock Ledger Entry, and Bin caches the running quantity per Item + Warehouse. With perpetual inventory enabled, each of those movements also posts a matching GL Entry, which is why Stock and Accounts must always reconcile.
Key features
- Item master — variants and attributes, UOM conversions, reorder levels, item defaults per company, and Item Price against a Price List.
- Warehouses — a per-company tree, optionally with Putaway Rules and warehouse-wise accounting.
- Movements — Stock Entry (transfer, repack, material issue/receipt), Delivery Note, Purchase Receipt, Pick List, Packing Slip and Shipment.
- Traceability — Batch, Serial No and the Serial and Batch Bundle that ties them to each transaction line.
- Valuation — FIFO, Moving Average and LIFO; Landed Cost Voucher to absorb freight and duty; Repost Item Valuation to recompute history.
- Corrections and counts — Stock Reconciliation for physical counts and opening balances, Closing Stock Balance for period snapshots.
- Reservation — Stock Reservation Entry holds quantity against a Sales Order or Work Order.
Entity relationships
Each diagram below is one connected cluster of entities. Edges are labelled with the fieldname that carries them — see relationship notation for how to read the crow’s feet.
Warehouse
Warehouse anchors stock location: these clusters show the rules, quantities, reservations, transactions, and item defaults that are maintained per storage location.
Split across 2 diagrams so each stays legible; Warehouse repeats in each.
Delivery Note
Delivery Note is the outbound-stock hub, connecting customer delivery rows with packed items, serial and batch allocations, quality checks, trips, shipments, and follow-on accounting.
Item
Item is the shared product or service master behind pricing, sourcing, manufacturing, quality, serial or batch tracking, and stock transactions.
Direct pairs
Entity pairs whose only intra-module relationship is to each other.
Document composition
Parent documents and the child tables they own.
Entity reference
Transactions
15 entities — submittable business documents that post ledger entries.
Ledgers & derived
3 entities — append-only tables written by transactions, never edited directly.
Masters
21 entities — reference data with an independent lifecycle.
Child tables
28 entities — row sets owned by exactly one parent document.
Related modules
Accounts
The financial core — Chart of Accounts, GL Entry, invoices, payments, taxes, budgets and the receivable/payable ledgers.
Manufacturing
BOM, Production Plan, Work Order and Job Card — planning and executing production against stock.
Buying
Supplier, Request for Quotation, Supplier Quotation and Purchase Order — the procure-to-pay chain.
Selling
Customer, Quotation and Sales Order — the order-to-cash chain up to the point a Delivery Note or Sales Invoice is raised.