Path: Inventory > Report > Stock Movement
| Panel |
|---|
Stock Movement shows the movement (In and Out) of the stocks due to sale to customer, transfer, sales return or stocking in |
...
- Inventory > Report > Stock Movement
- Enter a date range of From and To. Click on the calendar at the side to select a date.
- Key in the Item Code or click 'Select Item Code'.
- Select a Location / Branch.
- Select all the Transaction Types
Sort by: - Transaction Date - Date of when the transaction took place.
- Creation Date - Date of when the stock movement was created.
...
. The report will display opening and closing balance along with movement of the stock |
- 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:
| Info | ||
|---|---|---|
| ||
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) - Please be informed this can cause your server to crash
|
Related WIKI Pages:
| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|