Path: Inventory > Report > Stock Movement
...
- Tick Options to show more details → show location name, show reset MA, show foreign currency for purchases, show zero movement, show previous total value
- → this tick function might slow down the server performance
- Select Group by location → 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. 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
- 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:
...