FrontAccounting forum — inventory valuation report

Re: inventory valuation report

2018-04-26T09:01:28Z

Wiki-ed it.

Re: inventory valuation report

2018-04-26T04:18:24Z

Oh yes, you are right

Re: inventory valuation report

2018-04-25T06:47:09Z

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

2018-04-25T03:33:50Z

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

2018-04-24T20:48:44Z

@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

2018-04-24T18:56:38Z

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

It was well discussed in this topic.

inventory valuation report

2018-01-10T05:49:30Z

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.