Product History
The stock card of one product: opening balance, every movement in/out with its transaction type and document number, running balance. The report for answering "why is the stock what it is".
Questions It Answers
- Why is this product negative - which transaction took it out?
- When was this product last bought, and last sold?
- Who made the stock adjustment on this product?
Filters
| Filter | What it does |
|---|---|
| Transaction Date | A range, or one-sided (<=, >=, =). Movements before the start date are summarised as Opening balance. |
| Division | Pre-filled from the user role's default division. A role locked to one division cannot change it. |
| Department | Limits to one department (warehouse/outlet) inside the division; pre-filled from the role default when set. |
| Product Code | Required. One product. |
| Serial Number | Only movements of that serial number (exact or partial). |
| Created By, Edited By | User who created or edited the source document. |
How To Read It
| Column | Meaning |
|---|---|
| Opening balance | Stock before the filter start date, in the chosen division/department. |
| Division, Department, Invoice, Date | Where the stock sits and the document that moved it. |
| Transaction type | Purchase, Purchase Return, Sales, Sales Return, transfer, purchase/sales rewards, rental return, manufacturing (start/release/finished goods), vehicle trip or maintenance, or Others (adjustments, manual in/out). |
| In, Out, Balance | Quantity in the base unit and the running balance. |
| Serial Number, Expiration Date | Shown only when the company uses serial numbers. |
| Memo, Created By, Edited By | Document memo and its users. |
Why The Numbers May Differ
- Quantities are always in the base unit; an invoice selling 1 box shows as 12 pcs (or whatever the box holds in the master).
- Without a Division/Department filter the running balance merges every warehouse - transfers between warehouses show as an out and an in that cancel.
- Stock transfers change the balance per department without changing the company total.
Menu Location
- Products & Inventory / Inventory Reports / Product History
/report/producthistories