4,904 questions
0
votes
1
answer
84
views
Netsuite Suitetalk API request "current role does not have permission" error
I am trying to get all customer records using the Netsuite Suitetalk API endpoint /services/rest/record/v1/customer (reference docs https://system.netsuite.com/help/helpcenter/en_US/APIs/...
0
votes
1
answer
56
views
How to add last24hour filter in a Netsuite script saved search?
I am trying to filter vendors activated/inactivated in last 24 hours. But I tried lot but not getting any results, whereas there are few vndors activated in last 24 hours in Netsuite account. Please ...
0
votes
0
answers
67
views
Using NetSuite "saved searches" via the N/search API and search "available filters"
I'm building a restlet that will allow a Saved Search id to be passed in. The restlet will load and run the saved search and build a result from the rows. It's simple code and it basically works (...
0
votes
0
answers
54
views
alttagcaption value assign in suitescript
The image file has attribute alttagcaption which is responsible for setting an alt attribute on the website. I can't find a way to set its value from suitescript directly on the file (or whatever this ...
0
votes
0
answers
37
views
How to get Record IDs from OnRequest
This is executed on the Item Fulfillment record.
How would I be able to get current Item Fulfillment record ID and Sales Record ID?
define(['N/render', 'N/record', 'N/xml', 'N/format', 'N/file'],
...
0
votes
1
answer
60
views
How to access data from addRecord inside Adv PDF Template?
This is an Item Fulfillment record, but needing Sales Order data.
I've added the records. How would I access them in the Adv PDF Template?:
renderer.addRecord('record', record.load({
...
0
votes
0
answers
40
views
Netsuite Suite Analytics JDBC NullPointerException with Netsuite Timestamp data type
I've connected to Netsuite via Suite Analytics JDBC connection in Databricks cluster. I'm seeing a NullPointerException because of the lastmodifieddate column in my netsuite classification table, I ...
0
votes
0
answers
89
views
HTTP Error 500 Response Header Too Long Error In Netsuite suitescript 2.1
I hope you are doing well! I have created custom suitelet page to show saved search results in a suitelet sublist with checkboxes to select items and customers. Also developed client script to pass ...
0
votes
1
answer
63
views
Netsuite JDBC pyspark error - SQLSyntaxErrorException: Syntax Error in the SQL statement
I'm trying to test the jdbc connection by querying our Customer netsuite table with spark jdbc in Databricks. I've added the .jar file to the cluster and trying to run the below. I tried with the ...
0
votes
1
answer
46
views
How to skip duplicate rows Netsuite map reduce script rescheduling?
I hope you are doing well!
I have developed map reduce script to generate and email csv file for dataset results. I am processing data in batch and rescheduling the script. The problem is, there are ...
0
votes
0
answers
38
views
How does one properly import a "header" to a "source" file in SuiteScript?
My background is C development hence the header and source terminology. Most examples I see online tell me to use this format:
Header:
/**
* @file Sample Server Utilities module.
*
* @NApiVersion 2....
2
votes
1
answer
50
views
NetSuite Advanced PDF group items by cust transaction column
In Netsuite, on the invoice PDF, I'm trying to group Items by values in a custom transaction column field which is a Customer pick list where that Invoice Line can be left blank (associating it to the ...
0
votes
1
answer
41
views
Long array to search cause SSS_REQUEST_TIME_EXCEEDED on Suitelet 2.x
I have IDs grouped by brands and array was long
// Set brand ID array for selected business
var brandOptions = {
BHS: [1, 2, 3, 4, 21, 22, 23, 24, 25, 26, 41, 48, 39, 40, ...
0
votes
0
answers
83
views
NetSuite SPA Development on VS Code with TypeScript
Currently I am trying to develop a NetSuite Single Page Application using VS Code and TypeScript. But there's some error on the UIF module import.
Cannot find module '@uif-js/core' or its ...
0
votes
0
answers
38
views
How to filter sales orders in a saved search based on the "Sales Orders by Sales Rep" report in NetSuite?
I hope you are doing well!
I am trying to retrieve sales orders based on the "Sales Orders by Sales Rep" report for a specific date range. After retrieving the sales orders, I plan to ...
1
vote
1
answer
60
views
NetSuite User Event Script with Query: ReferenceError Query is not defined
I am trying to determine when to run a beforeSubmit user event script on an invoice in NetSuite when an invoice is created in the transaction table. I am able to get the basic script to run and ...
0
votes
0
answers
65
views
How to delay suitelet page rendering using suitescript 2.1 in Netsuite?
I have developed a suitelet which contains 5 iframes which contains 5 child suitelets. My concern is, when my main suitelet completes loading in the browser, iframe suitelets starts to render its ...
0
votes
1
answer
84
views
How to enable editing Netsuite sublist field?
I hope you are doing well! I am trying to enable editing to the disabled sublist field. My code works for tax rate field but not working for rate field on item sublist. Rate field has label as ...
1
vote
1
answer
71
views
How to write formula for multiple OR conditions in Netsuite mass update search criteria?
I hope you are doing well. I am setting up a NetSuite mass update to update email addresses for quotes with particular quote numbers. The "Quote Number" field is a text field. I've ...
0
votes
2
answers
67
views
Adding currency as default value on record initialization on vendor payment record using suitescript to get the correct apply sublist data
I am trying to create a vendorpayment record using script. This is my script.
var transactionId = '11111';
var vendorId = '222';
var subsidiaryId = '2';
var apAccountId = '333'
var inputAmount = 1000;
...
1
vote
2
answers
84
views
How to pass multiple parameters from client script to suitelet?
I am trying to pass values entered in a textarea field on suitelet (new line/space/comma/pipe separated) from client script to suitelet. There is limitation of suiteleturl length. I am trying to pass ...
0
votes
0
answers
32
views
Netsuite - I need to process 750K records, and create CSV for the same
I need inventory details as csv, there are total of 750k records and I need it in csv, Saved search is not loading in UI and getInputData() is stucked from past 15hrs. How can I do this? multiple csv ...
1
vote
1
answer
57
views
How to show pagination dropdown on the suitelet sublist?
I have developed suitelet script to select a values from multiselect type field and show results in a sublsit. Currently my script shows all results on same page. How to show pagination dropdown ...
0
votes
1
answer
48
views
Hide Items from item sublist drop down on Purchase Order - Netsuite
I want to hide some items from item sublist dropdown on purhcase order, the conditions are
if user has subsidiary "1", then only it can see items which have "special items" ...
0
votes
0
answers
60
views
Netsuite SuiteQL query to get access token created before 2800 days ago
I am trying to get access tokens with below condisions,
inactive is false,
token creation date is before 2800 days using suiteQL.
I tried writiing this query but it doesn't work. Please advice thank ...