Bug in Inventory valuation Report or standard cost

Opening stock of 15 pieces purchased at a rate of 1,637.16
Purchase of 10pieces at a rate of 1,708.85 in the last tax period
sales of 2 piece at a rate of 1712.38 in the last tax period
after sales purchase of 5 piece at a rate of 1708.85 in the last tax period
Currently, there are 28 pieces left in stock

Solution

alculate the unit cost of the item using the Weighted Average method:

Step 1: Calculate the total cost of the opening stock
Total cost of opening stock = 15 x 1,637.16 = 24,557.40

Step 2: Calculate the total cost of the purchases made in the last tax period
Total cost of purchases = (10 - 2 + 5) x 1,708.85 = 20,351.25

Step 3: Calculate the total cost of goods available for sale
Total cost of goods available for sale = Total cost of opening stock + Total cost of purchases = 24,557.40 + 20,351.25 = 44,908.65

Step 4: Calculate the weighted average cost per unit
Total units available for sale = Opening stock + Purchases - Sales = 15 + 10 - 2 + 5 = 28
Weighted average cost per unit = Total cost of goods available for sale / Total units available for sale = 44,908.65 / 28 = 1,603.16

as per my calculation unit price is 1603.16

but in front accounting 1776.1466666667

@Joe

I feel to show you something on this today. Actually i told you i cant give the issue without right decimals and values in my other post on other standard cost problem with a topic.  But i have a sample data to try this for you now.

$qoh = 0.08000000000000007; 

$qty = -0.08; 
$material_cost = 879.75;
$price_in_home_currency = 879.74550490191;

$material_cost = ($qoh * $material_cost + $qty * $price_in_home_currency) /    ($qoh + $qty);

//5182495254323.2 

if you applied get_qty_dec on $qoh, you will get only, 0.08 as stock, not with decimals.   and also for the price in home currency you dont get more than users preferred decimal. 

I told you to apply get_qty_dec and user_price_dec . run the above code and find the difference in it.

@Joe we can't check some  >= 1 . sometimes quantity can be saleable when its 0.5.  So the limit can be like you told get_unit_dec,

When it comes -1 than go with user_qty_dec and than if the rounded value is less than 0, we shouldnt update the material cost.

Also lets hear from other developer suggestion to make it better fix for this.

That's right. So lets condition it with 

$qoh+$qty >= 1 and make the calculation call on

Seems like i told before. there is chance of having inventory less than unit one full unit is also possible.  But you mentioned that, it will lead mis calculation. So lets get opinion from others and finalize it.

I have checked. It works. You can update it .