Inventory Movement Reports

View inventory report from the beginning & ending stock balance, and detailed stock movements in any chosen period

Christian Wijaya avatar
Written by Christian Wijaya
Updated over a week ago

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

Inventory Timeline

Step 2. Click Breakdown to View Detail

Breakdown Timeline Detail Report

Step 3. Inventory Timeline was Displayed Successfully

This is an example from the Stock movement reports in DealPOS :

Inventory Timeline

Step 4. Try to Filter Inventory Data

Filtering Data Inventory Timeline

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)

Inventory Valuation Traffic Report

Step 2. Inventory Movement Report was Displayed Successfully

Outlet Inventory Traffic

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 :


dealpos-trial-indonesia


โ€‹

Did this answer your question?