Neriyam
Open App

Stock Ledger

The transactional history of every stock movement, with running balances and filters.

Stock Ledger#

The Stock Ledger is the definitive record of every stock movement for a specific item — inwards, outwards, transfers, adjustments, scrap, everything. Every posting from every module lands here. When you need to explain a balance, reconcile a discrepancy, or audit a movement, this is where you look.

Getting there#

Inventory › Stock Ledger in the sidebar.

The page opens with the item picker front-and-centre. You must pick an item to see any data.

Filters#

FilterNotes
ItemRequired. Pick from the item picker.
WarehouseAll warehouses (default) or a specific one
OwnershipAll, Own Stock, or Customer Stock
CustomerVisible when Ownership = Customer Stock; filter further to a specific customer
Date PresetAll Time, This Fiscal Year, This Quarter, This Month, Last Month, Custom
Date From / Date ToExplicit range; overrides preset when set

Use Ownership = Customer Stock + a specific customer to produce a customer stock statement — "what of your material do we currently hold?"

Columns#

Each row is one ledger entry.

ColumnWhat it shows
Recorded DateWhen the entry was posted (with time)
Posting DateThe effective date for this ledger entry (may differ from recorded date)
DocumentCode of the source stock entry (OPN, PPR, SPD, TRF, etc.); clickable — jumps to the document
WarehouseWarehouse this line affected
Owner"Own Stock" or a customer name
Qty ChangeSigned quantity. Green for inward (positive), red for outward (negative). Rate shown below.
Balance QtyRunning balance after this entry
Balance ValueRunning value; shows average cost below

At the bottom, a summary shows Total Inward, Total Outward, and Net for the current filter window — signed and colour-coded.

Filtering by ownership — viewing customer-owned stock#

Neriyam distinguishes own stock from customer-supplied stock with a per-line ownership tag (see Stock ownership). The ledger is the cleanest place to view one customer's stock balance.

"What customer stock do we currently hold for Customer X?"#

  1. Pick the Item you want to check
  2. Set Ownership to Customer Stock
  3. Set Customer to Customer X
  4. (Optional) Filter to a specific Warehouse or a date window

The Balance Qty on the last row tells you how much of Customer X's material of this item is currently on hand.

"Show me all movements involving customer-owned material"#

  1. Pick the item
  2. Set Ownership to Customer Stock
  3. Leave customer blank to see all customers' movements, or pick one

"Only my own stock, ignoring customer consignment"#

  1. Pick the item
  2. Set Ownership to Own Stock

The Balance Qty and Balance Value now reflect your own inventory only.

Drill-down to source#

The Document column is a link. Clicking it jumps to the source stock entry (GRN, SDN, Transfer, etc.) where you can see the full details of that movement — header, all lines, and workflow history.

Export#

Click Export to download the current view as a CSV. The export matches what is on screen (respecting filters and the current page).

The export is the visible page only — if you have 500 rows across 10 pages, you get one page per export. For a bigger pull, widen the filter (e.g., increase page size) before exporting.

Reversal indicators#

When an entry is cancelled, Neriyam posts a reversal entry. Both the original and the reversal remain on the ledger:

  • The original entry's document link takes you to the now-Cancelled source
  • The reversal is a separate row, typically with opposite-sign quantity and the same rate

Look at the Document column — the reversal will reference the same source document code that was cancelled, making the pair obvious when you sort by date.

Paired entries from transfers#

A stock transfer posts two ledger entries — an outward at the source and an inward at the destination. When you filter by warehouse, you will see only one side of the pair. To see both, leave the warehouse filter on All Warehouses.

Typical uses#

Explain an unexpected balance#

"Why does the system show 47 when I expect 50?" Pick the item, set ownership filter, pick the warehouse, and review every movement. The discrepancy will appear somewhere in the chain — an adjustment, a scrap you forgot about, a cancelled GRN.

Month-end reconciliation#

Filter by warehouse + date window of the month + all ownership. Totals at the bottom give you movement in and out for the period.

Audit customer stock#

See "Filtering by ownership" above.

Trace a specific batch#

If you use batch numbers, pick the item and filter by the document codes you know touched that batch (use the date range to narrow it down). Each entry's detail page shows the batch number.

Permissions#

Viewing the stock ledger requires INVENTORY.VIEW_STOCK_ENTRIES or INVENTORY.VIEW_ITEMS.

Last updated