Business Systems

§ 04Inventory

Inventory management software development

Stock is only accurate if every movement is recorded where and when it happens. We build custom inventory management software as a ledger of movements (receipts, putaways, transfers, picks, adjustments), so on-hand figures are always the sum of what actually happened.

Brief an inventory system See the stock ledger
Stock ledger · SKU 40-118Steel bracket, 120 mm
TimeMovementQtyBalance
07:40ReceiptPO-3381 → DOCK-1+4001,240
08:15PutawayDOCK-1 → A-04-24001,240
11:02PickA-04-2 → SO-7714−1201,120
13:30TransferA-04-2 → WH-2−200920
16:05Count adj.A-04-2 → -−3917
WH-1 · A-04-2
697
WH-1 · reserved
−80
WH-2 · in transit
200
available to promise
617
Illustrative interface · example data

What this page covers

  • 01Stock movements
  • 02Locations
  • 03Lots and serials
  • 04Counts
  • 05Reorder rules
  • 06Scanning
  • 07Integrations

§ 01Ledger

Movements, not counts

Most stock problems come from editing a quantity instead of recording what happened. In inventory management software development we treat stock like an accounting ledger: six movement types, each created by a scan or an approved document, and a balance that is always their sum.

Movement types in an inventory ledger
MovementFrom → toCreated byEffect on stock
ReceiptSupplier → dockGoods-in scan against a POOn hand +
PutawayDock → binScan of bin labelLocation changes
TransferWarehouse → warehouseTransfer order, shipped then receivedIn transit, then on hand
PickBin → orderPick list confirmationReserved → shipped
AdjustmentBin → write-offApproved count variance or damageOn hand −, valued
ReturnCustomer → inspectionReturn receiptQuarantine until inspected

§ 02Structure

Locations and item structure

The location model and the item model are decided first, because every screen, label and report depends on them.

  • locations

    Warehouses, zones and bins

    A location hierarchy that matches the building: sites, zones, aisles and bins, each with its own label and rules (pick face, bulk, quarantine).

    • site
    • zone
    • bin
    • quarantine
  • tracking

    Lots, batches and serials

    Traceability where it matters: lot and expiry for perishables, serial numbers for equipment, first-expiry-first-out picking where required.

    • lot
    • expiry
    • serial
    • FEFO
  • units

    Units and packaging

    Buy in cases, store in pallets, sell in units, with conversions handled by the system, not by the picker.

    • case
    • pallet
    • each
  • kits

    Kits and bundles

    Items sold as a set but stocked as components, with availability calculated from the scarcest component.

    • kit
    • component

§ 03Counts

Counts and adjustments with an owner

Cycle counting replaces the annual stocktake with small, frequent counts. The system schedules them, hides the expected quantity from the counter, and sends any variance above a value threshold to a person for approval before stock is adjusted.

  1. Count scheduledABC class sets frequency
  2. CountedPickerblind count on scanner
  3. Variance found−3 units · $41.70
  4. Variance approvalWarehouse leadif value > $25
  5. Adjustedmovement + valuation
Example lifecycle · cycle count variance

§ 04Replenishment

Reorder rules people can trust

Reorder points, safety stock and supplier lead times are stored per item and location. The system proposes purchase quantities; purchasing reviews the proposal instead of rebuilding it in a spreadsheet every Monday.

Example replenishment view · WH-1
ItemOn handReservedReorder pointSuggested orderState
40-11869780750600Below ROP
40-1221,410220600-Covered
51-007123040120Short
51-0193050150-Slow mover

Illustrative view · example data

§ 05Access

Roles on the warehouse floor

Pickers move stock; leads approve variances; finance sees value. Separating those rights is what makes an adjustment trustworthy.

Example role matrix · warehouse operations
RoleReceiveMove stockCountApprove varianceCreate POSee stock value
PickerYesYesYes
Warehouse leadYesYesYes≤ $500Yes
PurchasingYesYes
Finance> $500Yes

§ 06Integrations

Integrations and scanning

Inventory sits in the middle of sales channels, accounting, carriers and the devices on the floor. Each of these connections is specified with its timing, because stock that is right in the warehouse but late on the store is still wrong.

Example integration map · inventory system
Connected systemDirectionWhat movesWhen
Online storeInventory system ↔ Online storeorders · availabilityreal time
Accounting / ERPInventory system → Accounting / ERPstock valuationdaily
Carrier APIInventory system ↔ Carrier APIlabels · trackingon pack
Handheld scannersInventory system ↔ Handheld scannersscans · tasksper scan
SuppliersSuppliers → Inventory systemASN · confirmationsEDI / email
MarketplacesInventory system → Marketplacesstock levelsevery 15 min

§ 07Scope

Inventory system or ERP?

Our inventory management software development services cover both shapes. A standalone inventory system is the right scope when stock operations are the problem and finance can stay where it is. When purchasing, production and finance must share the same stock records, inventory becomes one module of a custom ERP.

  1. 01phase

    Walk the warehouse

    We follow goods from dock to dispatch and record every place stock is touched, labelled or counted, plus every spreadsheet that adjusts it.

    Handed over
    Movement map and location model
  2. 02phase

    Ledger and locations

    Items, locations and movement types built first, with an opening stock count loaded and reconciled.

    Handed over
    Opening stock reconciliation
  3. 03phase

    Scanning and tasks

    Receiving, putaway, picking and counting on handheld devices, tested in the building with the people who use them.

    Handed over
    Scanner workflows and label templates
  4. 04phase

    Integrations and replenishment

    Store, ERP and carrier connections, then reorder rules tuned with purchasing.

    Handed over
    Integration logs and reorder rule set

Ideal when

  • On-hand figures differ from the shelf and nobody can say which movement caused it
  • Stock is managed in spreadsheets alongside a store or accounting system
  • Several warehouses, channels or lot-tracked items have outgrown a simple stock module

You receive

  • Movement ledger, location model and item structure
  • Scanner workflows for receiving, putaway, picking and counting
  • Reorder rules and replenishment views
  • Integrations, source code and runbooks

Not in scope

  • Warehouse automation hardware (conveyors, robots, sorters)
  • Supplying scanners or label printers (we integrate with them)
  • Finance and purchasing modules beyond stock (see custom ERP)

§ 08Questions

Questions about inventory software

Why build custom inventory software instead of buying an inventory app?

Off-the-shelf inventory apps work well for standard retail and ecommerce stock, and you should not hire an inventory management software development company to rebuild one. Custom inventory management software pays off when your locations, units, lots, kitting rules or channels do not fit the app’s model, or when inventory must integrate tightly with production, service or a custom order process.

How do you keep stock figures accurate?

By never editing a stock number directly. Every change is a movement record with a type, a location, a quantity, a person and a time, usually created by a scan. On-hand is calculated from movements, and variances found in counts are approved and recorded as adjustments with a reason.

Can it work with barcode scanners we already have?

Usually, yes. Most rugged handhelds run Android and a browser or a lightweight app, and label printers accept standard formats. We confirm the devices during the warehouse walk-through and test the workflows on them.

When should inventory be part of an ERP instead?

When purchasing, production and finance need to work from the same stock records in real time (for example, costing work orders or three-way matching supplier invoices against receipts). In that case inventory becomes one module of a custom ERP rather than a separate system.

How is opening stock migrated?

Items and locations are loaded first; then a counted opening balance is loaded at a cut-off and reconciled against the old figures by item and by value. Differences are reviewed with the warehouse and finance before go-live.

Next step

Tell us where the stock numbers go wrong.

Describe your locations, channels and the moments when stock is touched. We will map the movements and propose the first release.

Brief an inventory system All business systems

brief.txt · what helps us most

  1. 01Sites, warehouses and how locations are labelled
  2. 02Items, units, lots or serials you track
  3. 03Sales channels and systems that need stock levels
  4. 04Where today’s figures disagree with the shelf