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);
I would propose a condition to check negative values as shown below:
Function: getTransactions($category, $location, $date)...
HAVING ROUND(SUM(move.qty), IF(units.decimals>0,units.decimals,0)) != 0