Profit Invoice Report

Hi,

I run the profit invoice report each month which we find very helpful however I notice that the report picks up 'Cost based on the average cost price'

Our raw materials are subject to seasonal fluctuations so it is important for us to know the true profit - is there a way this report can be amended to return the actual cost of the product that was sold?

The system knows which batch of a certain product was allocated to a specific Sales Order so it has the information required, i just need to know how to extract it

Thanks in advance for your help,