I have a problem with this kind of calculation.
The problem is that the same item numbers can be calculated several times, depending on the script.
Can i use DISTINCT for the item numbers together with calculation of stock value (stock quantity x average price)?