Batch Inventory

Batch Inventory helps you control stock at a granular, real-world level—by lot, expiry, warehouse, and category—so every inward/outward move stays auditable, accurate, and fast.

What it does
• Tracks each product as batches (lots) with unique details like batch code, price, expiry, and date of manufacturing.
• Maintains live on-hand quantities using a robust method: “last snapshot + tail of confirmed transactions” to the current day. This gives you real-time stock without losing historical accuracy.
• Supports a “default batch” (batch_id = 0) for items where you don’t want to split lots, while still keeping the same accuracy model.
• Locks past periods automatically: once a daily snapshot exists, inserts/edits/deletes at or before that date are blocked—preserving the integrity of reports.
• Works across companies and warehouses with clear scoping by business code, company, and warehouse.

Give staff only what they need (Multi-Category Locking)
• By default, staff can access All Categories.
• If you map one or more categories to a staff account, access instantly narrows to those categories only (and “All Categories” is auto-unchecked in the UI).
• Admins always see everything and can assign or remove locks from Accounts → Category Locking. This lets you protect sensitive product lines while keeping daily work smooth.

Smarter operations
• Inward & Outward: Pick the batch (or default) and move stock with confidence; the system computes current balances per batch and prevents negative surprises.
• Expiry-aware: See batch expiry dates, sort by earliest, and act in time.
• Search & Sort: Find products by name/code; sort by current stock, total in/out, or last updated to surface what matters.
• Dynamic product data: Add structured titles/descriptions per product (specs, care notes, marketing points). Include these in Excel exports when needed.

Actionable reports
• Products Report: Name, code, unit, total in/out, current stock, batches, image—and optionally all dynamic data fields appended in the same row.
• Batches Report: Real batches plus the synthetic default batch, with current stock, pricing, and expiry signals (Expired / Expiring Today / Expiring Soon).
• Transactions Reports: Company/warehouse scoped, filtered by date range, staff, or party for clean audits.
• Product-Warehouse Matrix: A fast snapshot of where stock sits across all warehouses, including totals.

Designed for speed & scale
• Uses indexed tables and a prebuilt view for current stock to keep lists fast even with large ledgers.
• Snapshot logic keeps history consistent while allowing real-time visibility today.
• Role-based access and feature toggles ensure each user sees just what they need.

Why teams love it
• Accuracy you can trust (no silent edits into the past).
• Focused access for staff, complete visibility for admins.
• Less chaos near expiry with clear, sortable batch data.
• Export-ready: one click to Excel for analysis or sharing.

In short, Batch Inventory gives you the precision of batch-level control with the simplicity of everyday use—so stock stays organized, teams stay focused, and decisions stay data-driven.