Docs
Stock Ledger report
The stock ledger with wider filters. The investigation tool when a number looks wrong.
What is the Stock Ledger report?
A record of every stock movement, with wider filters than the ordinary screen. The investigation tool when a stock number looks wrong.
Where to find it
Reports → Inventory Reports → Stock Ledger, or /dashboard/reports/stock-ledger.
Permission: reports:stock_ledger.
The columns
| Column | What it means |
|---|---|
| Warehouse | Where the movement happened |
| Item Name | The affected item — in Arabic and English |
| Unit Price | The price at the time |
| Transaction Date | When |
| Transaction Type | Sale · Sales Return · Purchase · Purchase Return · Adjustment |
| Reference ID | The document that caused it |
| In Qty | What came in |
| Out Qty | What went out |
| Balance Qty | The warehouse balance after this movement |
| Created At | When it was recorded |
How to investigate a problem
- Filter on the item.
- Filter on the warehouse.
- Sort by transaction date.
- Follow the Balance column from top to bottom.
- At the first unexpected jump, take the Reference ID.
- Open that document and check its detail.
Most often you will find: a quantity typed wrong, an invoice submitted against the wrong warehouse, or an adjustment made without review.
Click Apply Filters
Like every report, you have to click Apply Filters for the result to update.
Tips
- Always sort by date — the Balance column is meaningless out of chronological order.
- A transfer writes two rows — out of one warehouse and into another, sharing a reference.
- Export to Excel when reviewing a long period.
Frequently Asked Questions
How does this differ from the Stock Ledgers screen?
The screen is for quick day-to-day browsing. The report gives you wider filters and better export — use it when investigating a problem or analysing a period.
What does the Balance column say?
The item's balance in that warehouse immediately after that movement. Sort by date and follow the column top to bottom to find the jump that does not make sense.
A movement is missing
The invoice is most likely still a draft — drafts write no movements. Or the item is configured as not maintaining stock.
Related Links
Use Pashkateb with Your Real Workflow
Start the free trial or move to the most relevant landing page for your workflow, then apply what you read using your own invoices, stock, and reports.