Inventory Movements
The Inventory Movements report provides a detailed audit trail of every transaction affecting a specific item's stock level. This view allows you to track exactly how, when, and why stock levels changed, showing a chronological flow of "Quantity In" and "Quantity Out." It is an essential tool for reconciling physical stock with system records and investigating discrepancies. To access this list, navigate to Inventory > Click the "Inventory Movements" Tab.
Filters Section
Use these filters to generate a movement history for a specific item and timeframe.
- Item: Select the specific product you wish to track from the dropdown list (e.g., M12 x 50 Bolt).
- Location: View movements for "All Locations" or filter by a specific warehouse or branch.
- Date: Define the date range (From - To) to view transactions within a specific period.
- Audit Trail Order: A toggle switch to sort the movements by the exact sequence they were entered into the system.
- Search Button: Click the green Search button to generate the movement report based on your selected criteria.
Opening and Closing Balances
The report automatically calculates the stock status at the start and end of your selected period:
- Quantity on hand before [Date]: Displays the stock level as it existed before the first day of your selected range.
- Quantity on hand after [Date]: Displays the final stock level after all transactions in the selected range have been processed.
Movements Table
Each row in this table represents a transaction that changed the stock level.
- Type: The nature of the transaction (e.g., Inventory Disposal, Purchase Order, Sales Invoice, or Adjustment).
- Reference: The unique transaction ID. Clicking the blue reference number opens the source document.
- Standard Cost: The unit cost of the item at the time of the movement.
- Date: The specific date the transaction occurred.
- Detail: Additional notes or descriptions related to the movement.
- Quantity In: The amount added to stock (e.g., from a purchase or return).
- Quantity Out: The amount removed from stock (e.g., from a sale or disposal).
- Quantity On Hand: The running total of stock after that specific transaction.
Audit Insights
The report helps identify negative stock situations or high-cost disposals. For example, a "Quantity Out" without sufficient "Quantity In" will result in a negative Quantity On Hand, which is highlighted to prompt further investigation.