I agree with @michael_nabil . Technically speaking Manager has the data to be able to calculate these figures.
But there are too many edge-cases for cost of goods sales to be calculated per transaction for general ledger purposes. It also makes inventory management more complicated due to negative inventory and limited (e.g. production order cannot create more than 1 output item type).
My solution is to abandon per-transaction cost of goods sold calculations and instead to revaluate inventory using periodic entries using Inventory Revaluation Worksheet.
I’m not quite sure where does this report that shows inventory costs per sales invoice fit in. @michael_nabil can you be more specific what exactly do you expect to do with those figures?