-
NSC | Using Workflow to run and display Calculations on Non-Stored Fields
Setting a Formula or a Summary Search during Custom Field setup are not the only ways to display calculations in Non-Store Value fields. The Set Field Value Workflow action can be used as well. See the screenshots below for a sample setup: Custom Field: Set Field Value Workflow Action: By doing this, you will be able to…
-
Creating a calendar event but it wont send email
I am creating a calendar event via suitescript 2.0 and i'm adding an attendee, which works fine, but I cannot work out how via script to trigger sending the email. I know I can use the email module, but I want the code to mimic the UI.
-
Workflow Going Back to Initial State
Hello, Community! 😄 I created this EST & SO Approval Workflow: Note that there's no transition from Pending Sales Head to Creation state. However, when we click the Approve button when it's in Pending Sales Head Approval, the workflow is going back to Creation state. Here are the only actions on Pending Sales Head…
-
link into email to approve or reject expense report
how we can customize NS so approver can simply approve (expense) by clicking on a link in the email or by replying back to email. Is this doable through workflow. Is this possible to send the approve or reject link within email so supervisor can just click on the link within email and approve the expense report without…
-
Intercompany sales orders / Access Shipping Preferences via SuiteScript
Hi all, is it possible to access the shipping preferences via SuiteScript? We are trying to use intercompany sales order functionality which requires turning charge for shipping off. Issue is we are then unable to edit any existing sales transactions that contained a ship cost as the shipping details get transferred to a…
-
NSC | How can I display the Invoice # of a Return Authorization on my Credit Memos?
In NetSuite, some companies requires the Invoice # to be shown within their Credit Memos. In this article, we will guide you on how to do this by utilizing Custom Fields. Create the Custom Field: Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New On the Transaction Body Field page, set the…
-
NSC | How to source a custom field from Item Fulfillment to Invoice?
In NetSuite, some companies requires to source values from an Item Fulfillment to their Invoices. However, this is a current limitation to source values from the Item Fulfillment to the Invoice record as they have no link between them. On a brighter note, we've come up with a workaround that utilizes a Saved Search and a…
-
NSC | How to add the Preferred Vendor on the header of your Item Records?
In NetSuite, some businesses requires the Preferred Vendor to be on the header of their Item Records. In this article, we'll guide you on how to do so by utilizing Custom Fields and Saved Searches: Create the Saved Search: 1. Navigate to Reports > Saved Searches > All Saved Searches > New and click on Item 2. On the Saved…
-
Creating a check - Error "This record already exists"
I am receiving an error of "This record already exists" on a few of my line items when trying to upload a batch of checks through the Saved CSV import. I have done multiple checks for a single customer for over a year in a half with the same template. Has something changed? Or does anyone know if there is a setting to…
-
Custom Transaction Form on Sales Order set field order type protected
Custom Transaction Form on Sales Order set field "order type" protected and we don't want that. Where can I control this behavior? Customize transaction form gives me Normal display type, what's responsible for the protect? I can't find a workflow on SO
-
How can we pull data from Item Fulfillment into Invoice?
Our users would like information pulled from the Item Fulfillment (vs from the Sales Order) into the Invoice. That way, if changes have been made to freight or shipping address they will carry over into the Invoice. They would also like the Customer Notes to pull from the IF to the Invoice. The field ID for Customer Notes…
-
Create scheduled deployments via script
I am trying to create new map reduce deployments using record.create but I cant seem to set the schedule fields after saving. As a workaround, I created a deployment with the schedule that I want so I can record.copy it hoping that it would retain the schedule. After saving , the schedule resets to single occurence and the…
-
Script Error: define is not defined
I have a script that extracts Expiration Date from Inventory Detail that is running successfully on a SandBox/Production account. I copied this script to another Sandbox account (Netsuite OneWorld) with the same settings. However, the execution logs show this error: ReferenceError: "define" is not defined.…
-
Removing currency symbol against line amount in Advanced PDF template
Hi, We need to make some changes to the advanced pdf template where we are adding a new column for the currency and need to remove the currency symbol from the line items amount. Please provide your inputs.
-
Increased SSS_CONNECTION_TIME_OUT errors
Hi there A variety of different scripts, connecting to different third-party servers, are receiving excessive SSS_CONNECTION_TIME_OUT errors. The errors are not caused by the third-party servers being down as it is happening across all the different services we connect to. Unfortunately I do not have a precise date as to…
-
Permision to View images
Hi. A user can't view an image attached into the RMA, what are the role permissions for the user to view attached images? This is the message he receives.
-
NSC | Other Sublist Fields Center Link Missing
There is an existing Defect/Issue that has been field for the missing Other Sublist Field, which is is a standard Netsuite Center Link. Without this center link, the customer is unable to create and edit Other Sublist Fields. An Alternative Solution has been created for this. The Other Sublist Fields can be accessed by…
-
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.…
-
Customize Customer Statement
Hi there, How do I amend the email layout and text when sending a customer statement? I want the statement to be attached as a PDF. It must be really obvious but I'm having trouble locating it. Many thanks Ben
-
Create a task with a workflow
I want to create a task from a workflow. My dilemma is that I want to create this based on the hire date from the employee record. This would not be an event-based workflow as there are no actions going on. For example, if the hire date is between 60-90 days, I would want to create a task and assign it to the employee's…
-
How can a line be added to print on the Quote PDF between transactions?
Currently the Sales Orders PDF has a line between each transaction but the Quote does not. How do we print a line between the Quote transactions. SALES ORDER: QUOTE:
-
Can we turn off emails to the customer when we create a case?
When we record a case Netsuite automatically sends an email to the customer. Can we turn off this functionality?
-
Implementing customizeGlImpact in SuiteScript 2.0
Hi all Has anyone successfully implemented a Custom GL-Impact under Suitescript 2.0 on their account ? I've been trying most of the day to get this to work our SB, with varying errors, but no success. Suite Answer 1016997 has a simple example, which I've: Uploaded as a JS file to the SuiteScripts folder. Created a new…
-
Add Class to Expense Category
Hello, I'd like to assign a Class to each Employee Expenses Category so this is prepopulated in the Expense Report but the Class field is not available in the Expense Categories form. How can I add the Class? Thanks
-
Custom invoices per customer
Hello! I have two questions that kind of relate to each other. First question I am wondering is if Netsuite is capable at assigning which custom invoice form is used per customer. We have 5 custom invoice forms. We use them as certain customers require their own information on their PDF invoices. I was wondering if there…
-
Migrating NetSuite’s Database from Legacy to NS2: Challenges and Key Insights
Transitioning NetSuite’s database from the old version to NS2 is far from straightforward. As I discussed in my previous post, numerous variables come into play, including changes in field and table names and structural differences. Additionally, differing values within fields and table linkages necessary to retrieve data…
-
Override box randomly defaulting to True on ship to
When creating a PO all of a sudden the override box on the ship to select is defaulting to true causing issues with ship to adresses imporing on the PO. See pics below: This address incomplete I open this up for somereason this is checked I uncheck it and the address is complete This has been happening on almost all new…
-
NSC | Send Email to Multiple Recipient Using Workflows
Send Email Actions in Workflows uses a field in the record as a reference, or a static value configured in the Workflow Action when sending emails. In this scenario, a user needs to send an email to multiple recipient using the Send Email Action Workflow. To do this, we need to create a Custom Email Field. Navigate to…
-
Analytics Audit Trail Search
Hi, What does it mean when the Record Title are blank from running the Analytics Audit Trail Search?
-
Rest API for Partial Vendor Return Authorization from Purchase Order
hi, when transforming PO to Vendor Return authorization, entire line quantity is considered. I need to create with partial line item quantity. Can i get a sample of rest api to use. Am using the following, created return authorization contains 10 the full quantity, instead of supplied value: 2 { "entity": { "id": 2222},…