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.

Inventory at Date

Step 1. Go to Inventory Menu, click the Inventory Timeline

Inventory Timeline
Filter Date Search

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 to Inventory Menu, click on Inventory Timeline, and click Breakdown

Breakdown
Inventory Timeline Breakdown

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

* Inventory on this report is based on the Created date, not the Invoice Date

You might also like to read these articles below:


dealpos-trial-indonesia

Did this answer your question?