Thank you so much for your support, appreciate. Your solution is Bingo!!. i mean the second part. It is all to do with inventory qty and starting value. I did not look into this previously as it was done by the someone. I tried on one product to update the details and then ran the report to check COGS, now I see the value non-zero and update. It works now, but the headache now is how to do it for 500 products.....
