Inventory Movement Reports are used to see the details of the stock movement of a product. With this report, it will be easier for you to see the movement from the stock of goods which is usually caused by :
Sales
Purchasing
Adjustment
Sales Return
Purchase Return
Delivery
Stock movement reports will display the stock at the beginning of the period, then detail the movement of the report, and the stock at the end of the period. We can also organize this report based on a certain period, for example daily, weekly, or monthly, this report is usually used at the end of the period.
I. Movement Stock Report on Timeline (Detailed)
To see the movement from the product by detail, you can access this report in detail by following the steps below :
Step 1. Go to Inventory, then Choose Timeline Tab
Step 2. Click Breakdown to View Detail
Step 3. Inventory Timeline was Displayed Successfully
This is an example from the Stock movement reports in DealPOS :
Step 4. Try to Filter Inventory Data
The image above is an example from the report for the 1st April to the 20th April period. By default, this feature will display stock movements from the beginning of the month to the current date. If you want to see this movement report with the customized time period, you can use filters to set the time range.
Index Table :
Field Name | Description |
Name | Product name |
Code | Product (variant) code |
01Apr (Customize from Filter) | Product inventory in the beginning of the date (choose date on filter) |
Sold | This is an item inventory stock from Sales |
Bought | This is an item inventory stock from Purchases |
D - In | This is an item inventory stock from Delivery in |
D - Out | This is an item inventory stock from Delivery out |
Adjust | This in an item inventory stock from Adjustment |
20Apr (Customize from Filter) | Product inventory in the end of the date (choose date on filter) |
Now | Current product inventory |
II. Stock Movement Reports by Valuation
To see a recap of the stock of goods per outlet, you can follow the steps below :
Step 1. Go to Inventory (Valuation), then Click More Menu and Choose Outlet (Inventory Traffic)
Step 2. Inventory Movement Report was Displayed Successfully
As you can see in the image above, it is a stock movement report that has been recapitulated by each outlet and can be compared and added up with other outlets.
Index Table :
Field Name | Description |
Code | This is a code of the product |
Start | This is an inventory of items in From by Date |
Sold | This is an item inventory item from the delivery, buy, and adjustment |
Bought | This is an item inventory item from the sell |
T. IN | This is an item inventory stock from the delivery in (from warehouse to outlet) |
T. OUT | This is an item inventory stock from the delivery out (from outlet to the warehouse) |
Adjust | This is an item inventory stock from the adjustment |
P | This is an Output item inventory stock from the manufactured |
M | This is an Input item (Material Raw) inventory stock from the manufactured |
End | This is an inventory of items in To by Date |
Now | Current Stock |
You might also like to read these articles below :
If you want to check Inventory stock per product, you can see the article How to See Inventory Log/Stock Card
In case you want to see product stock from the most, you can see the article Checking Inventory With Highest Quantity
Or if you want to set maximum and minimum Inventory, you can see this article Buffer and Threshold: How to set Min & Max Inventories
โ