FrontAccounting forum — inventory valuation report

Re: inventory valuation report

null@example.com (apmuthu) — Thu, 26 Apr 2018 09:01:28 +0000

Wiki-ed it.

Re: inventory valuation report

null@example.com (boxygen) — Thu, 26 Apr 2018 04:18:24 +0000

Oh yes, you are right

Re: inventory valuation report

null@example.com (joe) — Wed, 25 Apr 2018 06:47:09 +0000

If the $use_costed_values is set to 1, then the date range is used on the stock_moves material costs for each transaction.
This is not the same as the material_cost set on the stock_master table.
If the end date is today then the values should be the same if the stock_moves are updated correctly.

Joe

Re: inventory valuation report

null@example.com (boxygen) — Wed, 25 Apr 2018 03:33:50 +0000

Oh, Yes I missed that. But I think either this Variable is set to 0 or 1, the result shall be same because the function getAverageCost also returns UnitCost with the same algorithm, the weighted average, which is used to calculate the material_cost stored in stock_master.

This was discussed in detail in the topic mentioned in Post # 2

Re: inventory valuation report

null@example.com (joe) — Tue, 24 Apr 2018 20:48:44 +0000

@boxygen
As I can see we do use the global variable, $use_costed_values, in rep301.php.

It is on line 209:

        if (isset($SysPrefs->use_costed_values) && $SysPrefs->use_costed_values==1)
        {
            $UnitCost = getAverageCost($trans['stock_id'], $location, $date);
            $ItemTotal = $trans['QtyOnHand'] * $UnitCost;
        }    
        else
        {
            $UnitCost = $trans['UnitCost'];
            $ItemTotal = $trans['ItemTotal'];
        }

Joe

Re: inventory valuation report

null@example.com (boxygen) — Tue, 24 Apr 2018 18:56:38 +0000

$use_costed_values is not used anywhere in reports in latest FA Versions

It was well discussed in this topic.

inventory valuation report

null@example.com (farhath) — Wed, 10 Jan 2018 05:49:30 +0000

I am using the latest version of FA version 2.4.3
When using
/* Show average costed values instead of fixed standard cost in report, Inventory Valuation Report */
$use_costed_values = 0;

The cost is different from the standard cost showing in the item is completely different from the one showing in the report, knowing that I the standard was not set manually but it was automatically calculated.

How can we explain that.

Your help is appreciated.