>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)?
If it's not broken, fix it until it is.
My Blog