how do I source the consolidated exchange rate ont...
# ask-stanley-ai
a
how do I source the consolidated exchange rate onto a form?
c
AI generated answer (using internal Slack threads):
To source the consolidated exchange rate onto a form, you can use a Saved Search. However, it's important to note that the consolidated exchange rate that gets applied will depend on the GL account associated with the transaction line. For assets and liabilities, the current rate will always get applied, regardless of the transaction dates. If you're dealing with consolidations between multiple subsidiaries, there's a separate consolidated exchange rate that governs those currency conversions distinct from the spot/transaction rate within the subsidiary. In the single subsidiary instance, you can use the 'Foreign Currency Amount' (or maybe 'Amount (Foreign Currency)') and 'Exchange Rate' fields. If you're trying to import Consolidated Exchange Rates, you can update the existing ones by using the internal ID for the Consolidated Exchange Rate itself. You can find this by doing a Saved Search for Consolidated Exchange Rates and including internal ID, or have Show Internal IDs checked in your preferences. However, you can't change the subsidiary relationship on the record, which is why you can't map those fields to your update. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.823274434
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.822182894
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.818221211
Please provide your feedback on this answer.
a
How can I pull the exchange rate to the parent company onto a form?