Integrate NetSuite Consolidated Balance Sheet
I'm trying to set up an integration to get our consolidated balance sheet ending balances from NetSuite into Anaplan. Initially I was able to load transaction data using a saved search, which works for our income statement, but for the balance sheet it doesn't allow me to get the right values for foreign accounts that have been converted to USD in NetSuite because there are no transactions that show the change in account values due to currency fluctuations. We've also tried pulling it as a Report loaded into the file cabinet with only the closing balances, but NetSuite hasn't been able to automate that export. Has anyone had any luck building a similar integration with a consolidated balance sheet from NetSuite into Anaplan? Thanks in advance.