# Item Movement Report

Purchase and sale movement per item for a period — purchased, returned, sold and net quantities alongside the current stock. Use it to see how each item moved in and out and what is left.

On this page

Overview Use Cases Filters Columns Actions FAQ

Overview

Go to Inventory → Inventory Reports → Item Movement Report.

What it shows. One row per item for the selected period, showing the item, code, unit, brand and group, then the purchase quantity, purchase return, net purchase, sold quantity, sale return, net sold, and the current stock. A total row sums each column. Click the item code to open its item enquiry.

When to use it. Use it for a combined purchase-and-sale view of item movement — to see what was bought and sold (net of returns) over a period and what remains in stock.

Use Cases

Purchase manager — How much of each item did we buy net of returns? Read the Net Purchase Qty column.
Sales manager — How much sold net of returns? Read the Net Sold Qty column.
Inventory controller — Does movement reconcile with current stock? Compare net purchase and net sold against Current Stock.
Category manager — How did a brand or group move? Use the Brand, Item Group, Branch or Center advanced filters.

Filters

Date (date range). Advanced Filter: Item, Item Group, Brand, Branch, Center.

Columns

| **Column** | **Description** | |------------|-----------------| | Item | Item name. | | Item Code | Item code. Click to open the item enquiry. | | Unit | Inventory keeping unit. | | Brand | Item brand. | | Item Group | Item group the item belongs to. | | Purchase Qty | Quantity purchased during the period. | | Pur. Return Qty | Quantity returned to suppliers during the period. | | Net Purchase Qty | Purchase quantity less purchase returns. | | Sold Qty | Quantity sold during the period. | | Sale Return Qty | Quantity returned by customers during the period. | | Net Sold Qty | Sold quantity less sale returns. | | Current Stock | Quantity currently in stock. |

Actions

Generate — run the report for the selected filters
Export — export to Excel
Print — print the report
Advanced Filter — open additional filter fields
clear — reset active advanced filters

FAQ

How is Net Purchase Qty calculated?
Purchase quantity minus purchase return quantity for the period.

How is Net Sold Qty calculated?
Sold quantity minus sale return quantity for the period.

Does Current Stock change with the date range?
The movement columns are for the selected period, while Current Stock reflects the quantity in stock now.

How is this different from Month Wise Item Movement?
This report lists many items with purchase/sale movement for one period. Month Wise Item Movement breaks one item down month by month with a chart.

Why is my report empty?
No items had purchase or sale movement in the period, or filters exclude all rows.

Are transfers included in movement columns?
Purchase and sale columns reflect invoiced purchase and sale activity; use Item Transactions for full movement types.

Does current stock respect center filter?
Yes. Current stock reflects the filtered center scope when a center is selected.