Customer profit report using average cost price

SOLVED

Hello all,

I am wanting to find a report to work out customer profit for the year using either average cost price or the actual cost price when stock put in to stock and then invoiced out.  Is there such a report ? or do all customer reports use the last cost price?  as this is not giving me a true profit figure.

Any help or suggestions would be appreciated.  - thank you