openingamount + nvl(purchaseamount,0) - nvl(soldamount,0) as [ClosingAmount] ;

Nomi, thanks for helping but I want to draw you attention to above line of codes

the closing qty will multiply by purchase rate

The last purchase rate of 1401 is 14.775
so closing amount of 1401=?

closing amount=closing qty*last purchase rate
14.775*6=88.65

so closing amount of 1401=88.65

But your query displays 59.70