Hi,
I am doing a Sales Transaction Report, and I am trying to pull in the old purchase prices as well as the new ones,. For example, Item 1 - purchase price is £10 and then we had 2 sales, then we reduce the buying price to £5 and we have 2 sales.
Is there a way, after grouping the names I can see the 4 sales, 2 Sold with the old price and 2 with the new price? Right now, All I am seeing the current Purchase Price.
The Sales price shows correctly.
Any ideas?