You’re offline. This is a read only version of the page.
170
Hi,
I want to Import Historical Exchange Rates in Business Central from Dynamics GP.
From GP Server I have grabbed Rates Table but I can see 3 different Rate Identifiers: Historical,Month End , Average Rates.
e.g
| MR-BRL-US-AVG | Z-US$ | 01-01-2009 | 1.9191228 |
| MR-BRL-US-HIST | Z-US$ | 01-01-2009 | 2.1364553 |
| MR-BRL-US-ME | Z-US$ | 01-01-2009 | 1.7511295 |
exactly which one I need to Import in Currency Exchange Rate Table of Business Central?
Hi,
If you check the multicurrency transaction tables this should help you identify which one has been used. The MC020102 is the Multicurrency Receivables Transactions table and the MC020103 is the Multicurrency Payables Transactions table. If you check the EXGTBLID column it will show you the multicurrency rate table has been used.
Although not very common its worth noting that in GP you can have more than one exchange table per currency, therefore you can have more than more rate for a single currency. This is achieved using rate types and exchange tables.
Thanks
Gavin
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
