How to create a forecast report which includes item purchase values in foreign currency

Hi,

We are a distributor in Australia and one of our US vendors requires a pipeline report which lists opportunities in the coming quarter which lists items, quantities and our net purchase value for each item in US$. This is to assist them with their revenue projections.We can easily set up a saved report which lists all information, apart from each item's net purchase value in US$. The net purchase value is the vendor's US$ purchase price less our standard discount applied via the pricing schedule set up for that vendor. There does not seem to be any link between forecast