Page Comparison

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. 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. Get Last Cost From:

Image Added

• Item Last Cost- Get from last_unit_cost column in inv_item table. Amount come from the latest price in Purchase Return, Stock Adjustment, Supplier Consignment or GRN.
• Last Purchase Cost- Get from unit_price column in inv_stock_delta table. Amount come from the unit price of latest GRN.
• Last Average Cost - Get from net_price column in supp_grn_item table. Amount come from the net price of latest GRN.

5. 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: