>Dear Naomi,
>
>It is no matter whether there is one sql statement or more?
>There should be latest purchase rates for closing amount
>
>Thanks

And if the item never was purchased - latest from the stock? What if you update your stock from other source (e.g. item in stock has later date when purchased item)?