Calculate value for FIFO inventory

[klwu]

I need to create a query to calculate the value for a stock in FIFO inventory method......when the user creates an issue......the system will query and calculate the value of the stock based on FIFO....at the moment, the query did calculate the qty excellently, but just the value of the stock is incorrect.....for a better understanding of my problem, I made a simple diagram explaining what I am trying to do.......can someone help me please? Thank you....

 

[anchorp]

What happened?

Did you ever get this figured out? I am dealing with pretty much the same problem. Or if anyone else has please say so as well.

Thanks.