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. ...
GhalbrooksI have a NetSuite Suite Script that will pull everything out YTD for you. The idea is that you need a business rule connector in OneStream to run the NetSuite SuiteScript that you'll have to install in your NetSuite Instance. I am happy to walk through it with you, but, it should give you everything you need without having to install ODBC drivers or anything like that. Also, the data is YTD.
We have it resolved! Thanks to KTX our solution consultants!!
AlexLadd We are also trying to integrate with NetSuite to pull YTD Trial Balance data. Could you share the basic framework of your solution?
Sorry for the delay. The solution uses a NetSuite Suite Script that you import into your NetSuite Environment and then Business Rules on the OneStream side call the Suite Script to pull the data from NetSuite. The Business Rules can build out your dimensional hierarchies that are in NetSuite as well as bring in the data. The only drawback is that the hierarchies in NetSuite for dimensions other than Accounts is rather flat and uninteresting. A lot of customers use custom fields in NetSuite to denote new hierarchies in other dimensions because NetSuite itself doesn't really support hierarchies.
