-
getSegmentValueId(segmentId) throws unexpected error
While checking NetSuite Release Note 2024.2, I saw NS now allows SuiteScript 2.x for Custom GL impact script which allows to fetch and set segment data using getSegmentValueId(segmentId) and setSegmentValueId(segmentId). But when I am trying to use it in my script, it throws unexpected error. Anyone who has successfully…
-
Match bank data - access to matched data and reconciled data
Hey, i want to get access to the match bank data page, especially to the area that both sides are matched but hadn't transfer to the reconcile page: i've noticed suitescript does not have access and not suiteanlyitics connect. i wonder how can i get and not through the UI and manually. any suggestions? scraping? creative…
-
Celebrating a Major Milestone: Successful Migration to NS2 DB
Hi NetSuite Community, We are thrilled to announce that we have successfully completed a significant milestone in our migration journey from the NetSuite DB to NS2 DB! 🎉 This achievement marks a major step forward in modernizing our data infrastructure and optimizing our ERP and reporting capabilities. While there are…
-
How to create a Revenue Arrangement in SuiteScript 2.1
Our goal is to create Revenue Arrangements from Sales Orders in a SuiteScript 2.1 User Event or Scheduled Script. The script errors on the save operation for the Revenue Arrangement. var revArrangementId = revArrangement.save(); results in a permissions error. var revArrangementId = revArrangement.save({ enableSourcing:…
-
NS to NS2 DB Migration – Field Mapping & Gap Analysis
Hi everyone, Following up on my previous tips regarding the migration between NetSuite's current database (NS DB) and the new NS2 DB, I wanted to dive deeper into the field mapping and table changes that are impacting so many of us. I've posted about these impacts before, but today, I'm sharing a more concrete resource.…
-
Is possible to create Budget dataset and workbook where I can determine the budget amount in USD?
I'm looking to create a dataset or workbook in a table view format for budget records. This would involve calculating budget amounts using their respective exchange rates for each period. For example, for the current month, April 2023, I'd like to determine the budget amount in USD (our base currency) by multiplying the…
-
How to connect two Datasets in a Workbook
With version 2021.2 SuiteAnalytics brought an option of using fields from two dataset in one Workbook table, pivot table or a chart. Because the connection (linking, joining..) needs to be defined via SuiteScript to appear in Workbook UI, I thought an example can be handy for your experiments. Before you start coding, make…
-
Notification for Oracle Cloud Services Beta Trial License Agreement
This notice is intended for customers who are currently participating in the Oracle NetSuite Umbrella Beta Program and have enabled one or more beta features on the Enable Features page in the NetSuite application. Upon review, we have determined that inaccurate information was provided for your company’s participation in…