Product Inflow and Outflow
Movement summary per product over a period: opening balance, total in, total out, closing balance - each with its value. The report for "where did stock come from and go to this month".
Questions Answered
- What were the opening, in, out, and closing quantities of product X this month?
- How much inventory value was added and removed during the period?
- Which products moved most in a given warehouse?
Filters
| Filter | What it does |
|---|---|
| From Date, Until Date | Fill in both (date and time). Movements before From Date form the opening balance; between the two, in/out; up to Until Date, the closing 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 | One product only - handy for tracing the history of a single item. |
| Product Group | Restricts to products in one group. |
| Only Products with Movement | Off by default. When on, products with no stock in or out during the period are left out even if they still hold a balance. |
How to Read the Result
One row per product; the footer totals every column.
| Column | Meaning |
|---|---|
| Product Code, Product Name, Unit | The product and its base unit - all quantities are in the base unit. |
| Beginning Quantity, Beginning Value | Balance before From Date; value = quantity x the product's latest COGS in that division up to From Date. |
| Incoming Quantity, Incoming Value | Total stock in during the period; value = quantity x the latest COGS up to Until Date. |
| Outgoing Quantity, Outgoing Value | Total stock out during the period, valued with the same COGS (up to Until Date). |
| Ending Quantity, Ending Value | Balance up to Until Date = beginning + in - out; valued with the COGS up to Until Date. |
| Description | The same closing balance rewritten in larger units (e.g. 2 boxes 5 pcs). |
Products whose four quantities are all zero do not appear. Products that hold a balance but did not move still appear (beginning = ending, in = out = 0), unless Only Products with Movement is on.
Why Figures Can Differ
- Beginning Value uses the COGS up to the start date while Ending Value uses the COGS up to the end date - if COGS changed within the period, Ending Value is not Beginning + In - Out.
- Incoming and Outgoing Values are valued with one COGS (end of period), not the purchase price of each document; for per-document prices use COGS History or the purchase reports.
- Transfers between departments appear as out in one department and in in another; without a department filter they cancel out in the totals.
- The Product Group filter reads the group on the product master at run time, not at transaction time.
- With Only Products with Movement on, the Ending Quantity and Ending Value totals cover only products that moved, so they can be lower than the Inventory Report for the same date.
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 / Product Inflow and Outflow
/report/inventorydetail