Qoyod
Pricing
Qoyod
Pricing

 Knowledge Base

How to Use the Inventory Movement Report

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

  1. From the side menu, open Reports, then Inventory Movement Report.
  2. Set the date range.
  3. Choose a category or the product you want to follow.
  4. Choose the location: a warehouse or branch.
  5. 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

Help Center

Can't find what you're looking for?

Don’t worry — we have more ways to help.

Live webinars hosted by the Qoyod team to help you master the software with ease.

Discover Qoyod’s latest releases, continuous improvements, and new features.

Our team is ready to help you with instant support for any issue you face.