I run sales reports to calculate profit but the report I download only captures the cost price at the time of the download and not at the time of the purchase. Our prices fluctuate weekly depending on our suppliers, this prevents me from getting an accurate profit margin on each line.

Thanks