Product Stock Transaction
The Product Stock Transaction report provides detailed visibility into product inventory movement during the selected reporting period. It helps monitor stock availability, track inventory changes, review product movement, and support inventory planning and purchasing decisions.
Date Range Filter
Allows users to display stock transaction records for a selected date range.
Features
- Filter inventory transactions by period.
- Review historical stock activity.
- Analyse inventory movement trends.
- Improve reporting accuracy.
Purpose
Used to monitor stock transactions during a selected timeframe.
Product Filter
Allows users to display transaction records for a selected product.
Features
- Search and select products.
- Display product-specific inventory movement.
- Improve inventory tracking.
- Simplify report analysis.
Purpose
Used to analyse transaction history for individual products.
Category Filter
Filters report data by product category.
Features
- Group products by category.
- Improve inventory visibility.
- Support category-level analysis.
Purpose
Used to review stock movement across categories.
Send Email
Sends the generated stock transaction report.
Features
- Share inventory reports.
- Improve operational communication.
- Enable remote review.
Purpose
Used to distribute report results.
Export
Downloads the currently displayed report.
Features
- Export filtered inventory data.
- Support offline analysis.
- Maintain inventory records.
Purpose
Creates a downloadable inventory report.
Product Groups
Products are displayed in grouped sections according to their assigned inventory category.
Examples:
- Dermalogica General
- Professional
- Dermalogica Ultracalming
- Dermalogica Dynamic Skin
- Dermalogica Age Smart
- Dermalogica Daily Skin Health
- Beauty
Features
- Organised inventory structure.
- Easier stock comparison.
- Improved transaction visibility.
Purpose
Used to review stock movement by inventory grouping.
Product Details
Product
Displays the inventory product name.
In Hand QTY
Displays the currently available stock quantity.
Size
Displays product size or packaging measurement.
Examples:
- 100 Ml
- 150 Ml
- 295 Ml
- 1 Pack
- 36 Pack
- 100 Pack
- 15 Packs
Product Sold
Displays stock movement values.
In
Shows quantity added into inventory.
Out
Shows quantity removed from inventory.
Sale
Displays quantity sold during the selected period.
Inhouse Use
Displays quantity consumed internally.
Features
- Monitor inventory movement.
- Review stock availability.
- Analyse stock consumption.
- Track sales impact on inventory.
- Improve purchasing decisions.
Best Practices
- Review inventory movement regularly.
- Monitor high stock consumption products.
- Compare stock in and stock out activity.
- Export reports for inventory planning.
- Use transaction insights to optimise purchasing decisions.