Multicurrency for vendor items

My understanding of the way that MAS 500 handles vendor item costs for multicurrency is that the Replacement Cost field is in home currency.  That doestn't make a lot of sense. 

 

How can I store a foreign currency cost and have new POs created with that cost?

 

The way that I undersand this is that if I put 10.00 in the replacement cost field and the exchange rate is 1.2, then the PO will be issued with a cost of 8.33.  Tomorrow, if I issue the PO when the exchange rate is 1.3, then the cost will be 7.69.  I have a negotiated price with my vendor that is $10 (it does not matter what the exchange rate is).  How can I accomplish this?

 

Any suggestions are most welcome.

  • Since there was no solution from Sage, we ended up created a UDF to store the foreign cost and then each day, a script would run that would recalculate the Replacement Cost field based on the exchange rate and the value in the Foreign Cost UDF.