The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
OneStream - NetSuite
Looking for others experiencing issues getting a YTD dataset out of NetSuite for loading into OS. Also looking to connect with other users who use NetSuite for the ERP and OneStream for planning. ...
Hi There:
I've created a YTD Trial Balance pull using this code on GITHUB. This should point you in the right direction. I would suggest making the connection via ODBC if possible; we had an API integration prior to implementing this and even with a relatively limited dataset, the upper threshold on the time to query in addition to the number of records became problematic.
Let me know if you have any questions:
https://github.com/nserpsolutions/public/blob/main/generic/nse_sa_trial_balance.sql
James- Thanks for your input. Does this pull from SuiteAnalytics?
Thank you!