Our company has many foreign customers & suppliers which are recorded in compiere in their own countries' currencies for AR & AP reporting purpose. We have already inputted the conversion rate for every foreign currency but however, the spot exchange rates are quite fluctuated. In order to reflect the current value of the foreign currency a/c at every month-end, we would like to know if there is any function that can automatically update the balance of those accounts in foreign currency to the spot exchange rate. Please tell where can i input the spot exchange rate aside from the fixed exchange rate and how to operate.
Thanks for your assistance in advance.
Log in to post a comment.