Checked the issue raised by Ms. Shiela regarding the consolidated inventory report by SKU of Charriol, however, I noticed there were multiples of the same SKU for some. As per checking the cause of this is the SKU does have a different avg_cost that was reflected in the report with this one SKU with multiple different avg_cost was reflected in the Pentaho Report. I have already informed the Pentaho team regarding this and also to add the avg_cost column in the consolidated inventory report.