Exchange Rate and Exchange Rate Line - Sage Intacct Data Target Requirements
DataBlend supports the API calls to Create an Exchange Rate and Add an Exchange Rate Line within Sage Intacct leveraging the Sage Intacct SDK. In addition, Custom Fields can be added for data that is unique to your business practices.
Required query fields to create an Exchange Rate:
|
DataBlend Query Object (SDK) |
Sage Intacct Object (API) |
Notes |
|
YYYY-MM-DD |
entry_effectivestartdate |
|
|
1 |
entry_exchangerateid |
Run a collector with the Exchange Rate object type and include the “exchangeRateType.id” and “exchangeRateType.key” fields. |
|
1 |
entry_exchangeratekey |
Same as entry_exchangerateid. |
|
3 |
entry_rate |
|
|
1.5 |
entry_reciprocalrate |
|
|
2 |
exchangeratetypeid |
Run a collector with the Exchange Rate Type object type and include the “exchangeRateType.id” and “exchangeRateType.key” fields. |
|
2 |
exchangeratetypekey |
Same as exchangerateid. |
|
USD |
fromcurrency |
In Intacct, navigate to Company > Exchange Rates. Click Add and dropdown the “from currency” field to see options. |
|
GDP |
tocurrency |
Required query fields to add an Exchange Rate Line to an Exchange Rate:
|
DataBlend Query Object (SDK) |
Sage Intacct Object (API) |
Notes |
|
YYYY-MM-DD |
effectivestartdate |
Cannot be the same date as any existing line in the Exchange Rate. |
|
5 |
exchangerateid |
Run a collector with the Exchange Rate object type and include at least the “id” and “key” fields. |
|
5 |
exchangeratekey |
Same as exchangerateid. |
|
3 |
rate |
|
|
2 |
reciprocalrate |
|