Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

« Previous Version 14 Next »

Menu Path: Reports > Manager Reports > Inventory Management


 OR-03 Item Code Stock Movement Report

This is a combination of many reports into one. Different fields are plucked from various reports and combined into. Even though it looks very complicated, this report is actually a complete stock movement of IN and OUT, together with the quantity.


 The balance quantity of item codes will be indeed, accurate.

  • Sales (+)
  • Sales Return (-)
  • Purchase (+)
  • Purchase Return (-)
  • COGS
  • GP
  • Transfer (+/-)
  • Stock Adjustment (+/-)


Related Wiki Pages:

 IM-03 Stock Balance and Sell Through Quantity by Location Report
  1. The navigation to the IM-03 Report:


2. The main interface of IM-03 Report that user will be navigating through:


3. The first enhancement:

  • The highlighted columns are those new columns has been added next to each respective "Sold" column. The added columns are as follows:
    1. Sold in last one month
    2. Sold in last 3 months
    3. Sold in last 6 months
  • This enhancement allows user to make comparison on the quantity sold within the stipulated period.


4. The latest enhancement:

  • The latest enhancement added the new filter as in Tick Option to filter result by Sold Last for 1 Month, 3 Month and 6 Months
  • This indicates no any table of the report having the width looked disproportion due to previous enhancement made


  • If the checkbox is not ticked, the Last Sold quantity will not be displayed separated as in 1 month, 3 months and 6 months, instead the quantity will be displayed in Total amount of previously sold quantities as per shown in the following image.

  • The image above illustrates the result filtered by the ticked option
  • As shown in the image above, the Sold Last is not ticked, which allows to generate the report without having to show the Sold Last in a single printable page


Related Wiki Pages:
 IM-04 Stock Transaction Ahead Report

This report linked from Stock Availability Reports. Could view the Outstanding Purchase Order and Sales Order information


Related Wiki Pages:

  • No labels