Note: Users must prepare a CSV file with the following details: Internal ID of the Contact records to be updated Internal ID of the Customer records associated to the Contacts intended Role for the contacts 1. Navigate to Lists > Import/Export > Import CSV Records.2. Import Type = Relationships.3. Record Type = Customers and Contacts Together.4. Select the CSV file.5. Click Next.6. Set Data Handling = Update.7. Click Next.8. In the field mapping page,… Continue reading Update Contact Role through CSV Import
Category: NetSuite ERP
NetSuite ERP
Company Name is printing twice in the Remittance slip
The information being pulled into the remittance slip is coming from the Name in the Primary Information section of the Customer record as well as the Addressee field found in the Address tab. Normally, the entries made on the Name and Addressee fields are the same. To correct this, remove the entry on the Addressee field or at least, put in… Continue reading Company Name is printing twice in the Remittance slip
Unable to Delete Group due to Dependent Records
Users attempts to delete Group (List > Relationships > Groups > Edit Group > Actions > Delete) returns: This record cannot be deleted because it has dependent records. Any Group which has been used to Bulk Merge operation or Marketing Campaign cannot be removed anymore. Only one option is to inactivate the respective Group by marking Inactive checkbox on the Group record itself. Note: Bulk Merge history is stored in Documents > Mail Merge > Merge History. Appropriate Group is displayed in Group column. Marketing Campaigns are saved under Lists > Marketing > Marketing Campaigns.
Avalara: Error of This Document has used AvaTax Services. An Address is incomplete or invalid” is encountered when posting invoice
This error means that thereis a location on the line item that does not have valid zip code. According to Avalara theshipping address and the location on the item level is necessary to calculatesales tax. The address on location isuse to identify where the item is coming from while the shipping address is towhere the… Continue reading Avalara: Error of This Document has used AvaTax Services. An Address is incomplete or invalid” is encountered when posting invoice
Remove the “Remove” button from the custom record list view.
In the custom record setup, the record will be inline editable from the parent record if the ‘Show Remove Link’ and ‘Allow Child Record Editing’ boxes are checked. In that case, there will be a “remove” link in the custom record sublist view. To avoid this link from the list, make the parent field mandatory… Continue reading Remove the “Remove” button from the custom record list view.
When calling the Suitelet API, I’m encountering the ‘SSS_INVALID_HEADER’ error.
Suitelet Response HTTP Header Restrictions In addition to the headers outlined in the General Blocked HTTP Headers section, certain headers cannot be manually set when interacting with the http.ServerResponse objects sent by Suitelets. Attempting to set values for any of these headers will result in an SSS_INVALID_HEADER error. The restricted headers are listed below: Allow… Continue reading When calling the Suitelet API, I’m encountering the ‘SSS_INVALID_HEADER’ error.
How to get sublist value in suitelet’s submit button action.
let lineCount = request.getLineCount({ group: “custpage_transaction_list” });where group is the id of your sublist. To use getSublistValue() where group is the id of your sublist, name is the id of the field in the sublist and line is the line number
Suitelets and UI Object Best Practices
The following are best practices for Suitelet development using UI objects and custom UI. General Suitelets are ideal for generating NetSuite pages (forms, lists), returning data (XML, text), and redirecting requests.Limit the number of UI objects on a page (< 100 rows for sublists, < 100 options for on demand select fields, < 200 rows… Continue reading Suitelets and UI Object Best Practices
Scheduled Script Best Practices
The following are best practices for scheduled scripts. Genaral guidelines: You should set your scheduled scripts to run during the hours of 2 AM to 6 AM PST. Scripts set to run during the hours of 6 AM to 6 PM PST may not run as quickly due to high database activity. The number of Not… Continue reading Scheduled Script Best Practices
Optimizing SuiteScript Performance
There are certain changes you can make to your scripts to ensure the execute with performance in mind. This may be particularly true for custom scripts. You can see if there are custom scripts in your account at Customization > Scripting > Scripts. The following guidelines are suggested to optimize script performance, General Scripting Guidelines Save… Continue reading Optimizing SuiteScript Performance