-
Sublist Saved Search Filters
I am creating a sublist to display backlog data and need to apply three filters in the saved search. The goal is to include projects where the customer is either a bidder, engineer, or end user. However, the sublist is only considering the first filter and not picking up records that meet any of the other conditions. How…
-
search.create() with array
I created a NetSuite scheduled script to get items from an external endpoint. Everything works fine; I receive the data. However, when I search for projects (from the external API) that are related to jobs in NetSuite, I use search.create(), and in the filters, I send an array of IDs. Share my method: This method generated…
-
Customize Manufacturing Traveler Printed Template
We use Manufacturing Travelers from the SCM bundle, not the specific travelers bundle/suiteapp because it's only for OneWorld accounts. When I go to Transactions > Manufacturing > Print Manufacturing Traveler, I am able to select the work orders and click print. I am then taken to the Form Printing Status page and can…
-
Error When Copying Budget: TypeError 'Cannot Read Properties of Undefined (reading toString)
Hello, I’m having an issue trying to copy a custom budget in NetSuite. Previously, this process worked smoothly without any issues. However, now every time I try to copy the budget, I encounter the following error message: 'customscript_bm_sc_custombudget (validateLine)' JS_EXCEPTION TypeError: Cannot read properties of…
-
NSC | Show Customer Record URL
Customer sometimes needs to create a field on Customer records that put the URL of that record into a URL field. This is because they are sourcing that field into SalesForce using a data integration platform so that my users can click that url inside SalesForce directly to the Netsuite record. Basically a field on the…
-
NetSuite workbook to ODBC table
Hi, I have created a workbook (datasets) for my requirement. I need to pull this workbook as ODBC table on Suite Analytics connect. How this can be achieved. Any help is appreciated Thanks, Subathra
-
NSC | Print Only the Lot Number for Inventory Detail Using Advanced PDF/HTML
Printing the Lot Number on Transaction is important for other Users. Adding the column Inventory Detail on Advanced PDF/HTML Template of Transaction records will also print other values. The expected output for our sample scenario is to just print the Lot Number only. To do this, we need to apply the code below: <td…
-
Turn off Customer Dashboard and 360 links?
Does anyone know if it's possible to turn off the links to View Dashboard and View Customer 360 on a customer form? I haven't located any options on the form or role permissions that would disable these.
-
Why some IR´s have the Bill button but other IR´s don´t
Why some IR´s have the 'Bill' button available and other IR´s don´t, even if the IR´s are related to the same PO and contain the same item id?
-
Accessing Saved Search from SuiteTalk not found
I have setup a new SS in NS. I have others that work ok. This one I get the error "A saved search with the internal ID 3201 does not exist." I can successfully access a different one. I have the Audience set in the Integration role and it is public, there are no Summary or functions in the SS. It is accessing Customer…
-
Update Sublist using workflow
I have a requirement to update the preferred Vendor from the header of the item screen to the sublist below. I am trying to update it using workflow. But I couldnt find the sublist fields. I am missing something here. Could some one help. Attached below my item screen .
-
Print inventory detail (expiration date) on an Item Fulfillment pdf form - script
Hello, I'm trying to run a script for some reason is not working. I'm following the instructions from SuiteAnswer: ID 49137 - but so far, I'm not getting anything on the form, but also, I'm not getting any errors. This is the script I have: http:///** *@NApiVersion 2.x *@NScriptType UserEventScript */ define(['N/record',…
-
Custom Segment Role Permission
This discussion was created from comments split from: Custom Segment Permission .
-
Deferred cost of sales account on item fulfilment
We are selling serialized inventory to customers and follow the process of Sales Order > Item Fulfillment > Invoice. My client requires that a control account be used during item fulfillment instead of the Cost of Sales account (Dr Deferred Cost of Sales, Cr Stock). When the invoice is created, the following entries should…
-
Form Signing Access Permission & Signing Onboarding Documents
I recently came across the custom permission "Form Signing Access." However, I cannot figure out what this is/what it does. We just got SuitePeople HR and I see an orange fill logo on some screens (screenshot below) but I don't know what this does. While setting up SuitePeople HR, specifically onboarding templates/plans, I…
-
Convert Base64 String to PDF in Netsuite
Hi, We have a restlet that receives some information from an external system including some data in base64 encoded format. I am trying to get this data and convert it to pdf to save in file cabinet, but I am unable to decode the base64 string. The method I am using is 'atob', but it is giving me below error.…
-
NSC| SuiteQL Union
The SuiteQL Union operator stands out as a powerful tool for combining data from multiple sources. In this article, we delve into the intricacies of SuiteQL Union and explore its applications select * from (select id,email from contact union select id,email from customer); In this example, we're selecting the "id" and…
-
Class Column in Custom Transaction Type
Hi, Guys. I created a custom transaction type with transaction style "journal". In "Custom Transaction Form", Tab Screen Fields -> Lines, I found the class column with the show column checked but it still does not appear on the transaction form. Is there a specific setting? Please help. Thank you so much. Herman
-
Saved Search in KPI Dashboard
Hello, how are you?I have a search for clients with a total of 1210, I need to place it in the "Key Performance Indicators" portlet to evaluate new clients in one year and old clients from another year in that indicator. How could I group it in the search, since it only shows me the total amount and does not separate the…
-
Why does setting the department, class or location on a customer deposit or payment not work?
Hi I have a workflow which sources the a department, class and location value from a customer record (these are custom fields) and uses this to the set the value on any transactions created for the customer. This works correctly on a sales order or invoice transaction. However, if I deploy this workflow to a customer…
-
Use SuiteScript to Cancel a Vendor Bill
I have a user event script that copies data from a vendor bill into a new transaction, and at the end, we want to Cancel the Vendor Bill. Void does not work because of the accounting preferences, and because the Bill is in Pending Approval status and is never approved. Does anyone know if there is a method to do this?…
-
Treat Warnings as Errors vs. address validation
I believe I read somewhere that Web Services users are encouraged to set the option "Treat Warnings as Errors" to true. If I do so, I run into what seems to be draconian validation of addresses. If there's no zip code, there's now an error: "Without a Zip/Postal code it will not be possible to use this address with 3rd…
-
Workflow deployment with SDF problem
Hi everyon, I have the problem when try to deploy my workflow via SDF like this. My workflow is very simple Can anyone tell me why I have the error :(
-
NSC | SuiteScript: Send Saved Search Results in a tabular form via email using HTML
Scenario The user wants to send the results of a saved search via email body using a simple HTML table. Solution (Spoiler) ----- Found this helpful? Others might too! Let us know what you think by leaving a comment or a reaction below.
-
Scheduled Scripts Stuck in Pending
We noticed 12/22/24, 6:32pm MST some scheduled scripts stopped running are are stuck in pending status. Anyone else seeing this? We canceled one script and waited for it to kick off again, but it stays stuck in pending status. I wonder if we kill all the pending scripts, that will clear the queue? ANy help is greatly…
-
Turn on Redwood Experience by default
Are there any role permissions or company setup options that would allow us to turn on Redwood Experience by default? Ideally we'd like to assign this to specific roles so every user doesn't need to go turn it on manually.
-
Customer Global Search returning string matching with email
Hello, Our understanding is typing CU:Test in global search should show results of customers having string Test in the customer name. The issue we have is when we type CU:Test in global search, the results not only show customers with the string Test in the name, it also shows customers having test.com as the email address…
-
Saved Search to Table using ODBC
Hi, I see the old post where we cannot access saved searches using ODBC tables. Was there any changes made recently possible to work this out. We see that instead of Transaction table with the help of saved search it would be easy to access the details since it runs dynamically. If ODBC is not the option what are the other…
-
TIP: Get Record Name Using SuiteScript - SuiteAnswers 88939
This is not a question, it is a How-To. SuiteAnswers 88939 says, in part, "Currently there is an Enhancement 203898 for SuiteScript API's to include a method that returns Record Name." then gives a solution using native Javascript and DOM (which of course they also say you should never do). Here is a better solution: let…
-
Vendor Bill (Please choose an item to add)
Trying to customize a bill and have some odd behavior. I am adding 1 expense line and saving (no items). When there is no client script it works. I add a script that does nothing and does not even get invoked I get the message preventing from saving the record. "Please choose an item to add" If I go to the item list and…