Track all movements, transfers, and quantity changes for a specific item within a specific store.Documentation Index
Fetch the complete documentation index at: https://help.kwentra.com/llms.txt
Use this file to discover all available pages before exploring further.
Business Value
- Gives a full audit trail of how an item quantity changed over time.
- Supports storekeepers and cost controllers in monitoring daily store operations.
- Useful for reconciling physical counts vs. system quantities.
How to Run the Item Activity Report
Reports → BO → Inventory → Item Activity At the top of the screen, you must choose:- From date → Starting point of the report
- To date → End point of the report
- Store → Single select (you can only choose one store)
- Item → Single select (you can only choose one item)
Opening & Submitted Quantities (Summary Block)
- Opening Qty: Quantity available in store at the start of the selected period.
- Submitted Qty: Total of all quantities submitted during the period (sum of all movements).
- Store Unit: The unit in which the item is tracked (e.g., Kg, Ltr, Pc).
- Store Price: The cost of the item per unit inside the selected store.
Detailed Activity Table
Each row represents an activity affecting the item:- ID → Transaction reference
- Qty → Positive or negative quantity moved
- Store Unit → Unit of measurement
- Store Price
- Activity Type
- transfer
- usage
- receiving
- Submitted (Yes/No)
- Date of creation
Closing Quantities (End of Report)
- Closing Qty: Final available quantity after all activities within the selected period.
- Submitted Qty: Total submitted quantity is summed again for closure validation.
- Store Unit: The unit in which the item is tracked (e.g., Kg, Ltr, Pc).
- Store Price: The cost of the item per unit inside the selected store.
Update: December 2025
Value Column & Transaction Hyperlink
Easily view the total value of item movements and access each transaction directly from the report.What’s New?
This update adds Value Columns across the report and introduces clickable transaction IDs that redirect to the original document.How It Works
- Run the report normally from: Reports → BO → Inventory → Item Activity
- The report now displays:
- Opening Qty + Opening Value
- All Movements with Qty, Price, Value
- Closing Qty + Closing Value
- Click any Transaction ID to open the full document.
- Review, validate, or correct transactions without leaving the report.