Inventory is the raw materials used to produce goods as well as the goods that are available for sale.
In order to manage the Inventory, we need to know the amount of stock of products on a certain date, especially the amount of stock in the period that has passed, for example, last week, last month, etc. We provide an Inventory Timeline report feature which is useful for seeing the stock of goods on a certain date so that we can see the movement of stock from a period which we can adjust using filters.
Step 1. Go to Inventory Menu, then Click Timeline Tab
Step 2. Filter Inventory as Needed (Optional)
Table Index :
Column Name | Description |
NAME | Name of product |
CODE | SKU code of the product |
Date (1-Nov-20) | Period start date set from Filter |
IN | Total stock entered in 1 period |
OUT | Total stock out in 1 period |
QTY NOW | Current stock |
Step 3. Go Back to Inventory Timeline, then Click Breakdown to View Detail
Table Index :
Column Name | Description |
NAME | Name of product |
CODE | SKU code of the product |
Date (1MAY) | Period start date set from Filter |
SOLD | Total quantity Out from the sold product |
BOUGHT | Total quantity In from the bought product |
D-IN | Total quantity In from the delivered product from another outlet |
D-OUT | Total quantity Out from the delivered product to another outlet |
ADJUST | Total Adjustment from the product |
2nd Date (23MAY) | Period end date set from Filter |
NOW | Total quantity now from the product |
Notes :
Inventory on this report is based on the Created date, not the Invoice Date.
You might also like to read these articles below :
If you are looking for Stock Card, you can access this article How to check Inventory Log/Stock Card.
If you want to know how to see Inventory movement you can go through this article How to See Inventory Movement Reports
In case if you want to see product stock from the most, you can see the article Checking Inventory with Highest Quantity