View Single Post
  #2 (permalink)  
Old June 26th, 2007, 18:30
bmj_23 bmj_23 is offline
Senior Member and Blogger
 
Join Date: May 2007
Posts: 176
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 4
Thanked 31 Times in 31 Posts
Rep Power: 2
bmj_23 will become famous soon enough
Re: Currency Conversions

Each cost field in the application is stored twice. Once in the locally entered currency (in this case CAD) and once in the base currency of the database (which is defined on table UOM and cannot be edited via the UI).

The conversion between the two currencies is dictated by the exchange rates held in OTM and which are related to the rate offerings you define.

If you are working in a multi currency environment, make sure you set the base currency on table UOM before you start loading cost related data e.g. rates.