1,528 questions
0
votes
1
answer
25
views
N/https in NetSuite SuiteScript - Header Persistence Issues
Has anyone found a reliable way to stop N/https from forwarding the original Authorization header during a 302 redirect?
The Problem: > I’m calling a third-party endpoint that redirects to a signed ...
Advice
0
votes
0
replies
25
views
Can we access custom record values in the payment file template during XML generation?
I am working on Netsuite Electronic Bank Payments(EBP). I have created my own custom record "payment profiles". Can we access custom record values like cbank, ebank, PFA in payment file ...
0
votes
2
answers
92
views
Netsuite UE script failing to trigger on LOAD/SAVE of workflow action script
Hope you can assist.
Let me offer some context. I have an opportunity record which auto-processes lines as followed:
User populates "Item cost FX" field
User clicks "recalculate" ...
0
votes
0
answers
64
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
46
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
76
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
1
answer
55
views
How to unselect value from multi-select type field in Netsuite map reduce script?
I hope you are doing well! I am trying to unselect specific customer from sepcific item multiselect field in map reduce script. I am setting new customers in a field using setvalue. But my approach is ...
0
votes
1
answer
51
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
43
views
How to reschedule netsuite map reduce script?
I am facing challenge in rescheduling map reduce script and generating the csv file. I would appreciate an advice!
challenge: If I reschedule script,
I will create empty CSV file in first iteration
...
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....
1
vote
1
answer
138
views
Map reduce script usage limit exceeds in the reduce stage in Netsuite
I hope you are doing well!
I have developed map reduce script to send dataset results as a csv file using map reduce script. If there is huge data, script exceeds usgae limit in the reduce stage. I ...
0
votes
1
answer
48
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
120
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
48
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
65
views
How to update a Purchase Order in a Workflow Action Script without triggering other Workflows?
In NetSuite, I have a Workflow Action Script that updates a Purchase Order, but I want to avoid triggering another workflow on the same record. That workflow handles approvals, and I don't want to ...
0
votes
0
answers
73
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
187
views
How to show netsuite suitelet design in a pdf using Netsuite advanced pdf template?
I am trying to render suitelet page as a PDF. Can we call suitelet URL in advanced pdf template and show suitelet design as a pdf. How it can be possible?
I am currently trying in sales order advanced ...
0
votes
1
answer
125
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
133
views
Message.create is not displaying on view mode in NetSuite
I'm working with a custom record in NetSuite and I want to display a green message.create() confirmation message when the record is viewed, but only if the URL contains the parameter isProcessed=true.
...
1
vote
1
answer
96
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
0
answers
36
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 ...
0
votes
1
answer
64
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" ...
1
vote
1
answer
171
views
How to Export SuiteQL Output as XLS/XLSX?
I am creating a custom report using SuiteQL in a Suitelet script. Previously I have successfully created the report using CSV, but as we know CSV does not support multiple sheets. I want the result to ...
0
votes
0
answers
70
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 ...
0
votes
3
answers
221
views
UNABLE_TO_DETERMINE_RECORD_TYPE_FOR_SAVED_SEARCH_ID_1 error
There is a Nestuite saved search on access tokens. When I run the search in suitelet script, I am getting error as 'UNABLE_TO_DETERMINE_RECORD_TYPE_FOR_SAVED_SEARCH_ID_1'
Also when I try to export ...
0
votes
1
answer
176
views
How to Change NetSuite 2025.1 PDF Renderer Back to Previous Instead of BFO?
I have several custom PDF download methods on a SuiteScript User Event button that calls a Client script that calls a Suitelet script using the N/render module function renderPdfToResponse(). Before ...
1
vote
1
answer
254
views
Can I use subquery in SuiteQL?
I want to create a custom report using SuiteQL. I want to show the total amount from the transaction based on its account. I need to sum up the rows that I gathered from the transaction table. So I am ...
0
votes
1
answer
37
views
NetSuite: Repopulate unfulfilled item on recorded Item Receipt Form
I would like to implement a feature to repopulate unfulfilled items from a purchase order onto an existing item receipt. situation is a little confusion so let me use a scenario: lets say a purchase ...
0
votes
1
answer
109
views
How to see fields and sublists needed to create a transaction in NetSuite via RESTlet?
I am trying to create an Inventory Adjustment via RESTlet so another application could create the adjustment.
I don't have any idea what the field should be. It always returns some error I don't know ...
0
votes
1
answer
79
views
How to email dataset results in a CSV format using scheduled script?
I am using a NetSuite dataset (N/dataset API in SuiteScript 2.1) to retrieve existing dataset results. The dataset returns results in JSON format, including columns like PO Status, Billing Status, Sub ...
0
votes
1
answer
52
views
NetSuite SuiteScript 1.0 'The record is not a valid object'
I have a SuiteScript 1.0 script where I'm trying to update a field on all records returned by a saved search. Unfortunately, I keep getting 'The record is not a valid object' error. I'm trying to ...
1
vote
1
answer
117
views
Timezone safe way to filter trandate in Suitescript
To the best of my research, trandate on a transaction like a Sales Order is just a date. In the XML it shows <trandate>29-Jan-2025</trandate>. I'm in Australia, and when using N/search in ...
1
vote
1
answer
206
views
render html content through custom field to the pdf direct in Netsuite
I created a custom field on Item Fulfillment with the field type Rich Text. I entered the following HTML content into the field:
<p><strong>Special Offer:</strong> Get 20% off this ...
-1
votes
1
answer
76
views
How to host a flutter app from a Netsuite Suitelet
I'm impressed with the ability in netsuite to render custom html directly in the NS environment, and i would like to embed a Flutter web app now.
I am having difficulty getting everything to load, ...
1
vote
1
answer
144
views
Trouble setting multiple recipients, cc, or bcc on Message Records using record.create() in Suitescript
I am trying to create a message record for a bunch of contacts that are all receiving an email together.
I am using email.send() for the actual email but there is a limitation of only attaching one ...
0
votes
2
answers
356
views
How to avoid NetSuite record has been changed error?
I have developed scheduled script to create journal entry records for each invoice item. Now, I have created 2 functions.
First function, creates journal entries for all items on invoice records.
...
0
votes
1
answer
101
views
WorkFlows - Multiple IF-Else condition
I am trying to set a field based on multiple if-else conditions in a workflow.
eg:
Set Field1 = 1, if Condition x is Yes ,
ELSE
Set Field1 = 2, if Condition y is Yes & Condition Z=yes,
ELSE
Set ...
1
vote
1
answer
70
views
How to pass last processed record id to reschedule a scheduled script in NetSuite?
I am having trouble in rescheduling a scheduled script. I have created script parameter 'last_processed_record_id'. I am not aware of how to pass that lastprocessed id in script parameter and run ...
0
votes
2
answers
260
views
How to retrieve Vendor Bill ID by Purchase Order ID using NetSuite REST API?
I am working with the NetSuite REST API and need to retrieve the Vendor Bill ID associated with a specific Purchase Order ID. I have the Purchase Order ID, and I would like to query the API to obtain ...
0
votes
2
answers
162
views
Date should be in DD/MM/YYYY format error?
I am trying to get trandate from invoice and set it on advanced intercompany journal entry record. trandate is 02/12/2024. when I do new Date(trandate), it returns null value for invoice, and for some ...
-1
votes
1
answer
158
views
Fulfilling a Transfer Order
I've been trying to create a Suitescript to fulfill a Transfer Order but have had no luck. I'm not sure if I need to create both an item fulfillment and an item receipt? I seem to get different ...
0
votes
2
answers
241
views
How to find next open accounting period in netsuite?
I have to find next open accounting period for certain period.
Suppose, on invoice, accounting period is Feb 2022, then first check if accounting period has closed. If closed, I have to find next open ...
0
votes
1
answer
77
views
GL Impact added to workflow email
I have been trying like crazy to hunt down a way to add the GL impact to my workflow that sends an email everytime an assembly is built.Is there a way to get GL impact in the body of the email of my ...
0
votes
0
answers
119
views
I want to add "save & edit" button in Item fulfillment, when click on the button transaction will save and open in edit mode
Add a button "save & edit" in transaction form (item fulfillment) and when click the button then the record will save and open in edit mode. I have tried using event and client script, ...
0
votes
1
answer
279
views
Suitescript: Error using financial institution connectivity script and CAMT053 parser on NetSuite
Hope you are able to assist.
On NetSuite, I am currently building a financial institution connectivity script with the sole goal of passing an XML file to the 'CAMT053 Plugin Implementation' which is ...
0
votes
1
answer
47
views
How to Separate Suitelet Script into Custom Module and XML Template in NetSuite?
I have developed a Suitelet script in NetSuite to generate an XML file, and I would like to restructure it into three parts:
A Custom Module that handles the logic for generating XML.
An XML Template ...
0
votes
1
answer
233
views
How to zip file in a Netsuite suitescript?
I have developed a suitelet script to generate pdf and xml file. Now I want to zip both the files into a single zip file and store it to the Netsuite file cabinet. Please help!
Below is my script ...
0
votes
1
answer
265
views
How can I optimize the execution time of a Map/Reduce script in NetSuite?
I’m working on a NetSuite Map/Reduce script to process large volumes of invoice data for XML generation. However, I’m facing performance issues and delays during execution.
The script takes ...
0
votes
2
answers
217
views
SuiteScipt 2.x User Event Script INVALID_API_USAGE
I'm trying to write a script on the server side that copies values from a line item field to a header field. What's weird is the script works when I'm editing the record but when I create a new record ...
0
votes
1
answer
185
views
Problem adding record to renderer using N/render addRecord
I am working on a Suitelet that shows a check PDF in a new Window. Everything is working as expected except I've now hit a problem with rendering the PDF itself.
const renderPdfTemplate = (...