The Inventory Movement Report in Qoyod lists every document that changed a product’s stock in the location and period you choose, and shows the on-hand quantity and inventory value after each movement. You find it under Reports.
Path in Qoyod
Reports › Inventory Movement Report
Steps
- From the side menu, open Reports, then Inventory Movement Report.
- Set the date range.
- Choose a category or the product you want to follow.
- Choose the location: a warehouse or branch.
- Click Filter to show the movements. Reset clears the filters.
Fields
- Date range: the start and end of the period to cover.
- Category: narrows the report to the products in one category.
- Product: shows the movements of a single product.
- Location: the warehouse or branch whose stock you are reviewing.
- Movement Date: the date the transaction affected stock.
- Commercial Doc.: the source of the movement, such as a sales invoice, bill, debit note, credit note, transfer, stock take or reclassification.
- SKU and Product Name: the product that moved.
- Location To and Location From: the other location involved, for transfers only.
- Quantity: positive for stock in, negative for stock out.
- Average Cost: the product’s average cost at the time of the movement.
- On Hand Quantity: the running stock balance after the movement.
- Inventory Valuation: on-hand quantity multiplied by average cost after the movement.
Special cases
How do I read the lines?
Read from top to bottom. Each line tells you what happened, on what date, from which document, how much came in or went out, and what the balance and its value became afterwards. If the on-hand quantity is 40 and a bill for 10 units is recorded, its line shows a quantity of 10 and an on-hand quantity of 50. If a sales invoice for 3 units follows, its line shows a negative quantity and an on-hand quantity of 47.
No movements appear
If no movements appear, check that the selected location and period include transactions on the product.
Notes
- The report covers stocked products, which are available on the Pro and Advanced plans.
- The Export button below the table exports the report.
- The movements list on the product page and the inventory movements section on the location page work as before.
- To follow a product’s movements from the location page itself, see How to Track and Export Product Activities by Site and Date.
- To view a product’s movements from the product page, see How to View and Track Product Movements.
- To move stock between two locations, see Creating Inventory Transfers in Qoyod.
- To see average cost and profit margin per product, see Product Cost and Profit Margin Report in Qoyod.