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