This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

_RE: Consolidated Exchange Rates Import._ I have a circumstance where a client has a current instance of NetSuite, but is setting up a new instance. I have already imported Trial Balances and Currency Exchange Rates, and now I want to import Consolidated Exchange Rates. However, I realized that with the import, you cannot map _Period_, _From Subsidiary_, or _To Subsidiary_. But I do see that it is possible to _manually_ change the Consolidated Exchange Rates in the Consolidated Exchange Rates page. Should I just update the rates manually, or is it possible to indicate to the system which rates go to which Subsidiary relationship in which Period?

Can you not download the list of consolidated exchange rates and then *update* the existing ones?

Shouldn't really be possible to create new ones anyways - should be system created at the time you create the subsidiary or at the time you create the period.

That's what I am trying to do. (You can only update, there's no option to add.)

But you can't be specific in the import about the Period you want to update, or which subsidiary relationship. I think I'll just do it manually.

you can't change the subsidiary relationship on the record

which is why you can't map those fields to your update

by updating the record via internal ID you correctly update the rates for that subsidiary relationship

I happen to have a similar problem. Which record's internal ID does that refer to?

He's talking about the internal ID for the Consolidated Exchange Rate itself. Do a Saved Search for Consolidated Exchange Rates and include internal ID, or have Show Internal IDs checked in your preferences.