Hi all, Im sure that the answer here is simple, but does anyone know why, in consolidated exchange rates, there is a different measure for different subsidiary combinations? Looking at the below, why would we have different EUR > GBP rates?

have you checked if the rates were edited either manually or via script/workflow?

No, they have not been edited - no WF or script

from what I've read, netsuite is taking the weighted average of the transaction amounts of that subsidiary to get either the average or historical rates. see suiteanswers id: 7711 for a more thorough explanation.

Thanks Robert - I will check this out with the team

@Sam L - are these different months? going into the future or is this the past?

This is a single point in time

As Robert mentioned, the average is the weighted average of transactions in that sub to it makes sense to have a difference. Current, on the other hand is typically the month end rate and is therefore consistent across the subs