Path: Inventory > Report > Stock Movement
...
- Select Location
- Key in specific Item Code or click Item Code Fuzzy Search for search function → tick for all item code or search for description need to be more than 2 characters
- Key in Item Code Range → if want to filter by range
- Select Item Categories → if want to filter by category
- Select Item Status → All, active, inactive and deleted
- Select Item Type → deselect will generate all
- Select Date Range
- Select Transaction Type → deselect will generate all
- Select Order by → creation or transaction date
- Tick to show more details on Batch and Serial Number → if needed
...
- Click Generate Report Now
- Click on Printable Page → to print current columns or tables
- Click Export Excel or CSV → to export current columns or table
NOTES:
- Tick Options to 'Show Previous Balance of Total Value' might slow down the server performance → system will give alert message
...
- Click on Document Number for pop up function
- The calculation of Inventory Value Columns are depends on each transactions, refer below:
- GRN → GRN Qty * Unit Price
- Purchase Return → PR Qty * Unit Price
- Customer Invoice → INV Qty * MA
- Sales Return → SR Qty * MA
- Trade In → TI Qty * Unit Price
- Adjustment → ADJ Qty * Unit Price
- Customer Consignment → CCO, CCI, CCC Qty * MA
- Supplier Consignment → SCI, SCO, SCC Qty * Unit Price
**The inventory value is displayed at 2 decimal place, you may move your mouse to see other value.
- Total Value is the cumulative amount of Inventory Value
Below image shows the error message that will be prompt or display to the user when user:
...