Best Method for OneStream Integration with Netsuite
Hello Integration Experts, I would like to know what are the alternatives we have to Integrate Netsuite with OneStream and which is best among RESTAPI and ODBC. Thanks
Forum Discussion
You can pull the periodic values from NetSuite and aggregate them in stage.
For example, if you're in March pull Jan + Feb + March and once you go to validate step it will automatically aggregate all the values with same intersections.
I hope that answers your question.
Yes, we are in the process of preparing the source file before importing the data into OneStream and we are facing the issue how to match the mapping with OneStream & Netsuite dimension to understand the MTD and YTD both values are matching since we have challenges to pull YTD values which should include Opening balance(Last year ending balance for Balance sheet) and Intercompany accounts which are not having counterparty accounts/Entities.
Do you have any idea on this scenario to understand how to prepare the Source data set file.
Thanks
Sreenu