Currency Problem

[cherrielwy]

Hi,

I'm using my database to store the quotation that i quote. Some of my quotation were quote using RM but some of that will be using others currency. So any idea for me to solve this problem. I need to standardize the value of the quotation for the purpose of counting grand total in the end of the month. Thank you.

 

[Norris68]

You will need to create extra fields. I would suggest something like: QuotePrice (how much the quote is for), QuoteCurrency (which currency the quote is in), ExchangeRate (the exchange rate at the time of the quote), ConvertedPrice (the price in the currency you use for accounting).