• From: Kenya, Nairobi
  • Registered: 01/25/2020
  • Posts: 52

Topic: BUG in Inventory Valuation Report

Inventory valuation report wont show Items whose quantity is 1 and the units of measure for that item is set to use "User Quantity Decimals" decimal places option. The "User Quantity Decimals" option has a value of -1 thus below MYSQL condition will result to zero:

SELECT ROUND(1, -1);

Result: 0

I would propose a condition to check negative values as shown below:
File: rep301.php
Function: getTransactions($category, $location, $date)...

HAVING ROUND(SUM(move.qty), IF(units.decimals>0,units.decimals,0)) != 0
  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: BUG in Inventory Valuation Report

@joe: run into this issue?

apmuthu's Website

3 Reply by risingstar (edited by risingstar 10/05/2021 07:33:26 am)

  • From: Indonesia, Jakarta
  • Registered: 04/07/2021
  • Posts: 3

Re: BUG in Inventory Valuation Report

Helo, I have found another BUG in this that is showing ITEM/Inventory that already purged. This item appears in REPORT. how to solve it???