FrontAccounting forum — Inventory valuation report. 301 unit decimal -1 issue.

Re: Inventory valuation report. 301 unit decimal -1 issue.

null@example.com (kvvaradha) — Fri, 23 Dec 2022 10:31:46 +0000

Perfect. I thought to say the user qty dec. But used price dec there by mistake.

Re: Inventory valuation report. 301 unit decimal -1 issue.

null@example.com (joe) — Fri, 23 Dec 2022 08:42:51 +0000

Yes, now I see it. In this specific case the line was not there. Thanks for observing this.

To retrieve the user unit dec, the function user_qty_dec() is uset, not user_price_dec() .

This has now been committed to stable repo. A fixed file can be downloaded here and replaced on your server.

Joe

Re: Inventory valuation report. 301 unit decimal -1 issue.

null@example.com (kvvaradha) — Fri, 23 Dec 2022 04:49:21 +0000

The situation you need to reproduce.

You should have one item with only one digit stock balance and which is also only one entry.

And try the valuation report again. That specific item won't be in the list.

And ofcourse logically we said -1 means user decimal quantity. Is that not right to put that in the query to get properly decimal valued stock. ?

Re: Inventory valuation report. 301 unit decimal -1 issue.

null@example.com (joe) — Thu, 22 Dec 2022 15:25:59 +0000

Strange, I cannot reproduce this. Have tried with 'User Quantity Decimals (-1) and stock with single digit. And tried in PHP 7.1.33 and 8.1. No problems. It works perfectly here. Others having problems?

/Joe

Inventory valuation report. 301 unit decimal -1 issue.

null@example.com (kvvaradha) — Thu, 22 Dec 2022 08:35:25 +0000

Yes, while making the inventory valuation report and if the stock is in single digit and the decimal for that item unit set -1. then the item won't appear in the report.

Line no 120

HAVING ROUND(SUM(move.qty), units.decimals) != 0";

has to be like this.

$dec= user_price_dec();
...
...
..
HAVING ROUND(SUM(move.qty), IF(units.decimals=-1, ".$dec.", units.decimals) != 0";

Joe check this