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
Share
Report
All responses (
Answers (
