Stock Movement Report

Path: Inventory > Report > Stock Movement

• Select Location
• Key in specific Item Code or click Item Code Fuzzy Search for search function → 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

• Tick Options to show more details → show location name, show reset MA, show foreign currency for purchases, show zero movement, show previous total value, show pagination

• 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 → 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:

Related WIKI Pages: