Data doesn't consolidate in all currencies in parent below top members

HI,

Currently having an issue with data not aggregating properly in CAD currency below the top parent. The top parent is in CAD currency and the roll-up that are giving us issues is in USD (Parent 1 and Parent 2). If I look at the balance sheet in USD for Parent 1 and Parent 2 it balances. If I ran a balance sheet in CAD for Parent 1 and Parent 2 it showing out of balance.

I did a SV quarry and when I sum all base in CAD, it doesn’t equal Parent 2 in CAD.

I made another test and create an alternate hierarchy with only Parent 1 and Parent 2 including base members but I set up Parent 1 and 2 in CAD instead.I got no issues and it balances.