Path: Inventory > Report > Stock Movement
Stock Movement shows the movement (In and Out) of the stocks due to sale to customer, transfer, sales return or stocking in inventories. The report will display opening and closing balance. For each transaction, two columns of 'IN' and 'OUT' will show stock being added or deducted from opening balance. Closing balance (final quantity) will appear at the bottom.
This image below shows the main interface of the Stock Movement function / page to generate the report. User will have to key in values for fields such as Locations, Item Codes, Item Category, Item Status, Type, the dates and many other fields.
- 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
- 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
- → 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.
- 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:
Error Message Tips
ERROR: Please enter Item Code Fuzzy Search!
When you filter by Item Category, please remember to "tick" All Item Code (in Item code Fuzzy Search)
Related WIKI Pages:
Found 5 search result(s) for stock movement.