Inventory Reports

Run a report

1. Open Reports and choose the required report.
2. Enter the correct date or date range.
3. Select Generate.
4. Confirm the report title, period, warehouse, and filters before using it.
5. Print or copy only through approved channels.

Use the date displayed on the document being checked and confirm the report period before sharing or reconciling it.

Choose the right report

• Inventory Overview: opening, quantities in and out, damage, adjustments, final quantity, and values by product.
• Purchase Report: suppliers, warehouses, quantities, taxes, paid amounts, and balances.
• Purchased Items: item-level purchasing detail.
• Consumption Analysis: purchasing compared with use over the selected period.
• Supplier Performance: purchasing and delivery performance by supplier.
• Sales Report: inventory-sale values, payments, balances, and users.
• Movement Report: opening, every movement category, total in/out, net movement, and closing balance.
• Stock Valuation: quantity on hand, average cost, stock value, last movement, aging, and days of supply by warehouse.
• Damaged Items: quantity, incidents, estimated cost, and damage dates.
• Transfer reports: overview, item detail, warehouse activity, and product frequency.
• Returns: returned quantity, incidents, estimated value, and dates.
• Procurement reports: requisitions, purchase orders, goods received notes, and their item-level detail.

Start with the question

Question	Start with	Then verify
Why did the quantity change?	Movement Report	Source document reference
What is on hand and what is it worth?	Stock Valuation	Movement closing quantity
What was bought and still owed?	Purchase Report	Purchase and payment records
What arrived from a supplier?	GRN and Received Items reports	PO and posted Purchase reference
Where did stock move?	Transfer Detail	Paired source and destination movements
What was lost or damaged?	Damaged Items or Losses reports	Damage or Stock Out document
What was returned?	Returns	Originating sale or cancellation

Reconcile stock

Use the same period and warehouse throughout:

Opening balance + Total In − Total Out = Closing balance

Trace differences in this order:

1. Movement Report
2. Source document number in the movement note
3. Purchases, transfers, damage, or adjustment list
4. Stock Valuation for the closing quantity and value

When alternate units are used, compare both the displayed unit and its base-unit equivalent. Do not add crates, packets, and pieces as though they were the same quantity.

Do not correct a reporting difference by creating a stock adjustment until the physical count and source documents have been checked and approved.

Daily review

Before New Day, run Movements for the closing system date and the GRN report for the receipt dates in scope. Confirm all Received GRNs intended for stock are Posted to Stock, then compare closing quantities with Stock Valuation.