• From: Kuwait
  • Registered: 04/30/2015
  • Posts: 7

Topic: inventory valuation report

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.

  • From: Pakistan, Karachi
  • Registered: 03/03/2015
  • Posts: 654

Re: inventory valuation report

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

It was well discussed in this topic.

www.boxygen.pk

boxygen's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: inventory valuation report

@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

  • From: Pakistan, Karachi
  • Registered: 03/03/2015
  • Posts: 654

Re: inventory valuation report

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

www.boxygen.pk

boxygen's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: inventory valuation report

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

  • From: Pakistan, Karachi
  • Registered: 03/03/2015
  • Posts: 654

Re: inventory valuation report

Oh yes, you are right

www.boxygen.pk

boxygen's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: inventory valuation report

Wiki-ed it.

apmuthu's Website