Check stock value against the ledger
Read the valuation, reconcile it to the inventory account, and use the aging, expiry, turnover and exception reports to find problems.
Before you begin
Every report here needs only inventory.view and shows only your active company. Cost and value figures are visible to every viewer.
Reconcile stock to the ledger
- Open Inventory > Reporting > Valuation (AVCO). Note the company total. Filter by Warehouse, Category, Brand, Branch or Lot as needed and use Clear filters to reset.
- Open Inventory > Reporting > GL reconciliation. The banner shows Valuation, Ledger, Difference and whether it is Reconciled or Not reconciled. This view always uses today's totals.
- If it is not reconciled, open Inventory > Reporting > Inventory to ledger and set As at to the date you care about, such as month end.
- Read the tables:
- journals on the stock account that no stock posting made (for example a manual journal)
- stock layers with no journal
- valuation by product
- Correct the cause: reverse the manual journal, or post the missing document. Reopen the report and confirm the difference is 0.00.
Example: valuation 125,000.00 and the account 125,000.00 are reconciled. A manual journal debits the inventory account by 500.00. The ledger becomes 125,500.00 and the difference -500.00; the journal appears in the first table.
Worked valuation example
Receive 100 at AED 10.00, then 50 at AED 16.00. Quantity 150, value AED 1,800.00 (1,000 + 800), unit cost AED 12.00. Deliver 60: AED 720.00 leaves and 90 units worth AED 1,080.00 remain. Delivering the last 90 takes exactly 1,080.00.
Other reports
| Report | Use it to |
|---|---|
| Inventory aging | See how long stock has sat: 0-30, 31-60, 61-90, 90+ days since the last inbound movement. |
| Count variances | See every counted line with system quantity, counted quantity and difference. Add From and To dates. |
| Replenishment (quick report) | List rules whose free stock plus open receipts is under the minimum. It ignores safety stock and multiples, so it can differ from the Replenishment screen. |
| Lot / serial trace | Follow every receipt-to-delivery movement of tracked goods. |
| Expiry | List lots expiring within N days (default 60) and those already expired. |
| Warehouse productivity | Tasks, lines, units, minutes per task and scan errors per person. |
| Consignment consumption | See supplier-owned stock moved into your own stock, for settlement. |
| Inventory 360 and Lot / serial 360 | See everything about one product, lot or serial in one place. |
| Stock events | See the outbox read by other systems and each reader's progress. |
| Turnover & fill rate | Turns, days of cover, slow and dead stock, fill rate. |
| Exception centre | See what needs attention today, worst first. |
Turnover and fill rate
Turns = cost of goods issued in the last 365 days divided by average stock value. If issues are AED 120,000 and opening and closing values are 40,000 and 60,000, the average is 50,000, turns are 2.40 and days of cover are 365 / 2.4 = 152. Slow stock has been idle for at least the number of days you set (default 90); dead stock has been idle twice that or never moved. Fill rate covers the last 90 days.
Exception centre
Sorted High, Medium, Low. High: negative stock, expired lot still available, open recall, retest overdue, reconciliation difference. Medium: late transfer, blocked task, recount waiting, proposal not approved. Low: stale estimates and held stock. An empty list says 'Nothing needs attention.'
Good to know
- The valuation report shows rows; the total is not displayed on screen.
- The Inventory to ledger report, not GL reconciliation, lets you choose a date.
- Before hard-closing a month the difference must be 0.00. See Set the stock policy, close periods and manage features.