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
Hi Omkareshwar,
May I know the best approach on mapping the Netsuite dimension fields with OneStream dimensions as we have issues with how to pull YTD value from Netsuite and preparing the report for OneStream mappings as we get on Transactional level basis for each period.
eg: How to match the data with Trail balance in Netsuite with OneStream MTD & YTD data
Thanks
Sreenu
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