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. ...
Forum Discussion
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.