Skip to content
Orrsap
DWG-04P-003.1Inventory Ledger

Stock you can trust, down to the bin.

One ledger for raw material, work in progress and finished goods across every store, batch and bin. Each movement is linked to the document that caused it.

  1. 1

    Stores, bins and locations

    Main store, RM store, WIP on the floor, FG bays and vendor locations, each with its own balance.

  2. 2

    Batch and serial tracking

    Trace a batch from supplier GRN through production to the customer invoice, or trace back from a complaint.

  3. 3

    Reorder levels

    Minimum, reorder and maximum levels per item and store. Items below reorder raise indents automatically.

Detail
D

Inventory / Ledger / All stores

Stock ledger - Plant 1

Raw material

Rs 38.4 L

Work in progress

Rs 11.9 L

Finished goods

Rs 22.6 L

ItemStoreBatchBinQtyReorder
BO-015 Mechanical seal 16 mmMain storeB-0925R2-0440150
PT-044 Motor body castingMain storeH-1031Y-01180120
RM-130 Copper wire 22 SWGRM storeC-7720R1-11212180
PT-072 Shaft EN8 16 mmWIP - Lathe 2WO-5522Floor90100
FG-1001 Pump 1HPFG storeFG-2610Bay 36440
  1. 4

    Valuation

    FIFO or weighted average, with stock value by category and ageing for slow and non-moving items.

  2. 5

    Stock audit

    Cycle counts by bin on a phone. Differences go for approval before the ledger is adjusted.

  3. 6

    Barcode and QR labels

    Print labels at GRN and production receipt. Scan to issue, move and dispatch.

Section A-A

Every movement has a document

  1. 01

    GRN

    Material received and inspected.

  2. 02

    Put away

    Placed in store and bin with batch.

  3. 03

    Issue

    Issued to a work order or job-work.

  4. 04

    Receipt

    Finished goods received from production.

  5. 05

    Dispatch

    Picked by batch against the invoice.

Specification

What is in Inventory Ledger

Stock typesRaw material, consumables, WIP, semi-finished, finished goods, scrap, vendor stock
TrackingBatch, serial, expiry and heat number where needed
ValuationFIFO, weighted average, standard cost
TransfersStore to store and plant to plant with in-transit stock
ControlsNegative stock blocked, back-dated entries locked after period close
ReportsStock ledger, ageing, ABC analysis, reorder status, batch trace

Notes

Common questions

  1. 01

    Can we track stock lying with job-work vendors?

    Yes. Each vendor is a location, so material sent out on a challan stays in your stock until it comes back.

  2. 02

    How do we start with opening stock?

    Import opening balances by item, store and batch from Excel, or count and enter by bin using the audit screen.

  3. 03

    Is food or chemical expiry supported?

    Yes. Batches can carry manufacturing and expiry dates, and picking follows first-expiry-first-out.

Engineering change note - ECN-2026 - Your plant

Approved for production.

Change requested: move the plant from spreadsheets and separate books to one connected ERP. Here is the revision plan a single-plant rollout usually follows.

RevDescriptionWhen
AMasters, opening stock and ledgers imported from Tally and ExcelWeek 1-2
BSales orders, GST invoices and purchase running liveWeek 2-4
CBOMs released, work orders and job cards on the floorWeek 4-6
DShortage predictor switched on with real lead timesWeek 6-8

Requested by

Plant owner

Reviewed by

Orrsap team

Approved

For production

Book a demo with our team.

We run it on your products, your BOMs and your parts list.