FX Rates by Subsidiary

Hello ONECommunity,

We use NetSuite as our ERP system, and we have different FX rates by subsidiaries that apply to the transactions that occur within those subsidiaries.

This means that for AverageRate we can have two EUR->USD FX rates within NetSuite. One FX rate for each of the two subsidiaries. When we pull those transactions for our income statement accounts into OneStream to load our YTD Actual scenario, we are seeing some FX variances because OneStream can only apply one EUR->USD FX rate that is stored within the cube's applied FX rate type.

How have others solved this issue? Is there a way to apply multiple EUR->USD FX rates within OneStream we are not seeing or is this whole process uncommon and we need some changes to our ERP?

Thanks!