Is there a way to fetch customer balance in their primary currency? To give some more background, we are trying to retrieve customer details using suiteQL(select * from customer). The customer has GBP as primary currency. All the balance fields (consolbalancesearch,overduebalancesearch etc.) are giving the balance value in USD. We tried getting fxbalance using N/Search, it works in sandbox but fails in live account. The “balance” field lookup in N/Search module also returns value in USD. Please help.