<![CDATA[FrontAccounting forum — BUG in Inventory Valuation Report]]>2021-10-05T07:25:27ZPunBBhttps://frontaccounting.com/punbb/viewtopic.php?id=9444<![CDATA[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???]]>https://frontaccounting.com/punbb/profile.php?id=460162021-10-05T07:25:27Zhttps://frontaccounting.com/punbb/viewtopic.php?pid=40056#p40056<![CDATA[Re: BUG in Inventory Valuation Report]]>@joe: run into this issue?]]>https://frontaccounting.com/punbb/profile.php?id=3642021-08-29T14:03:22Zhttps://frontaccounting.com/punbb/viewtopic.php?pid=39950#p39950<![CDATA[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