Scenario Even if we include the sales rep contribution in the file used for the CSV import, the sale rep column in the sales team subtab in the lead record still generates the error “Total Contribution for Sales Reps Cannot Exceed 100%”. Solution Go to Setup > Import/Export > Import CSV Records Import Type: Select Relationship Record Type: Select desired Type( here it is… Continue reading Total Contribution for Sales Reps Cannot Exceed 100%” in CSV Import
Tag: csv import
Could not find any records by this name
The error occurs when updating child matrix items. In the CSV file, enter a separate column for the parent matrix item and another for the child matrix item. The CSV file will look like the following: Item Name/Number Subitem of Department Child item Parent item — In the Item Name/Number column, the Parent : Child… Continue reading Could not find any records by this name
Proposal For Order Import Feature
Proposal Summary This proposal covers the implementation of Order import feature in the Balaji Cricket Website Requirement The Cricket website needs to have an order import feature. The CSV file for import needs to have the below 4 columns: Door Code (Address Line 3) SKU (External ID) QTY PO It should be able to bulk… Continue reading Proposal For Order Import Feature
Common NetSuite CSV import errors and how to solve them
Common NetSuite CSV import errors and how to solve them
Basic Suitelet script structure for uploading a CSV file
We can use the following Suitelet for uploading a file and passing the contents. We can use the contents in the CSV file as per our requirements. We can upload though the UI from the script: Script:
Update records without duplicates
In NetSuite, updating the records through CSV import may lead to duplicate data in the system. This document explains how to avoid such scenarios, especially when updating the entity address records. The entity (customer, vendor, lead, etc) address records are maintained as separate records in NetSuite. These are called the sub records. As it is… Continue reading Update records without duplicates
Add Display and Thumbnail Images to Items Using CSV Import
Add Display and Thumbnail Images to Items Using CSV Import
How to Remove the “Sub-item of” on Inventory Records through CSV Import?
How to Remove the “Sub-item of” on Inventory Records through CSV Import?
In the CSV context script can’t get Custom sublist
If a user event script is deployed for a record, it can’t fetch the custom sublist if the context is CSV import. But it will work in other contexts. If it is aftersubmit, the solution that we can use is to load the record, instead of using newRecord from the script context. Also, we can… Continue reading In the CSV context script can’t get Custom sublist
PROPOSAL FOR UPDATING THE BILLING ADDRESS OF THE PARENT ACCOUNT AND THE SUB-CUSTOMER ACCOUNTS
Requirement: Client wants to update the billing address of the parent accounts and all their sub-customers accounts. The following are the changes to be made : The Billing street Address 1 to: new value The Billing street Address 2 to: make the field empty The Billing Postal Code/Zip to: new postal code. The billing information… Continue reading PROPOSAL FOR UPDATING THE BILLING ADDRESS OF THE PARENT ACCOUNT AND THE SUB-CUSTOMER ACCOUNTS