Inventory Adjustment
Posted stock-take results: per product, what the system recorded, what was physically found, and the difference in quantity and value. The stock-variance accountability report.
Questions It Answers
- What is this month's stock-take variance value, plus and minus?
- Which products vary most often in a given warehouse?
- What is in adjustment document X?
Filters
| Filter | What it does |
|---|---|
| Transaction Date | Up to a date (<=) or a range (between) of adjustment documents. |
| Product Code | One product only - handy for tracing the history of a single item. |
| Invoice | Inventory Adjustment document number - exact or partial. |
| Division | Pre-filled from the user role's default division. A role locked to one division cannot change it. |
| Department | One department. |
How To Read It
One row per product (and serial number/expiry/unit) per division and department, summed over every document in the filter.
| Column | Meaning |
|---|---|
| Average COGS | Average COGS the documents used to value the variance. |
| Recorded Qty, Physical Qty | Quantity per the system at stock-take time, and the physically counted quantity. |
| Plus (Quantity, Value) | Physical > recorded: stock added, and its value. |
| Minus (Quantity, Value) | Physical < recorded: stock removed, and its value. |
Why The Numbers May Differ
- Only posted documents; draft adjustments are absent and have not changed stock yet.
- Rows merge per product across documents when the Invoice filter is empty - fill Invoice to see a single document.
- Value uses COGS at adjustment time; inventory valuation reports use the latest COGS, so the two can differ for products whose COGS changed later.
Purchase Price Permission
Columns derived from COGS or purchase prices - COGS, inventory value, purchase prices and totals, and profit - appear only for roles that have the Show Purchase Price History permission in User Roles. For other roles those columns are absent from the screen, prints, and exports, and the server does not send the figures at all - they are not merely hidden by the layout.
- A missing column does not mean the data is empty. If the user should see it, turn the permission on for their role and ask them to log in again so the report layout follows.
- Custom-built reports are not protected automatically; a copy made with Duplicate in Report Designer keeps the settings of the original.
Menu Location
- Products & Inventory / Inventory Reports / Inventory Adjustment
/report/inventoryadjust