Batch-Wise Balance History

Batch-Wise Balance History shows, for each batch of an item in a warehouse, the opening quantity at the From Date, the quantity received, the quantity issued and the closing balance at the To Date, built from Stock Ledger Entries filtered by batch. It is the Stock Balance report at batch level, and the one to use when a supplier recall, a customer complaint or an IRD inspector asks what happened to lot B-2083-01: how much came in, how much went out, and how much is left. Expired batches and batches with zero balance can be hidden. The report posts nothing and is valid for any past date range.

Batch closing qty = opening qty + in qty - out qty over the period, per item, warehouse and batch

1. 01Go to Stock > Batch-Wise Balance History.
2. 02Set Company, From Date and To Date; filter by Item, Warehouse or Batch No.
3. 03Read Opening Qty, In Qty, Out Qty and Balance Qty per batch.
4. 04Click through to Stock Ledger with the batch filter to see each voucher.
5. 05Reconcile the balance against the physical lot and post differences by Stock Reconciliation.

Open to trace what happened to a particular batch.

Batch B-2083-01: opening 50, out 20, balance 30.