FrontAccounting forum — BUG in Inventory Valuation Report

Re: BUG in Inventory Valuation Report

null@example.com (risingstar) — Tue, 05 Oct 2021 07:25:27 +0000

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???

Re: BUG in Inventory Valuation Report

null@example.com (apmuthu) — Sun, 29 Aug 2021 14:03:22 +0000

@joe: run into this issue?

BUG in Inventory Valuation Report

null@example.com (detkenn) — Wed, 25 Aug 2021 09:05:35 +0000

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