Sales Order Import Errors
This section describes errors that you might see on a sales order import. See the following:
You must enter at least one line item for this transaction
Your CSV should have a value for the Item field, and you should map it to Items : Item (Req). You don’t need to map the Line ID.
Even if you set a default value for fields in a sublist, no sublist data gets imported unless you map at least one field for that sublist.
The record has been deleted since you retrieved it
Ensure that the CSV import has been set up as follows:
-
Go to Setup > Import/Export > Import CSV Records.
-
Specify an import type of Transaction and a record type of Sales Order.
-
Specify data handling of Update.
-
On the Advanced Options menu, check Overwrite Sublists.
Warning:Use this option with extreme caution.
-
On Field Mapping page, ensure that Line ID is not mapped to anything.
TypeError: Cannot find function getFullYear in object NaN. (NLRecordScripting.scriptInit$sys#3881).
This error happens when the date format in the Date field is wrong. For example, instead of 3/29/2014, someone entered 3/29/20014.
The getFullYear() function gives you a four-digit year, so you’ll get an error if the year has more than four digits.
Please specify either a terms parameter or a paymentmethod parameter in the request but not both
When you import a sales order, you can’t map both the Terms and Payment Method fields at the same time, choose only one to map on the Field Mapping page.
If you enter Terms on a sales order, it’ll create an invoice when billed. If you enter a Payment Method, it’ll create a cash sale when billed.
Invalid item reference key xx
Please verify your import using the following best practices:
-
The Item Name column in your CSV should match the format used in NetSuite. Make sure it matches what you see in the Item dropdown under Transactions > Sales > Enter Sales Orders> Items > Items.
-
You can also use the Internal ID instead of the Item Name. On the Field Mapping page, click the edit icon next to the Item field, select Choose Reference Type, and choose Internal ID.
-
Ensure that the item is active. Go to Lists > Accounting > Items. Check the Show Inactives box. If the item record is inactive, clear the Inactive box to make it active.
Please choose an item to add
The error might occur when incorrect item line IDs are entered in the CSV file. Create a saved search to extract the correct item line IDs.
To create the saved search:
-
Go to Lists > Search > Saved Searches > New > Transaction.
-
On the Criteria > Standard subtab, add a filter Type of Sales Order.
-
On the Results > Columns subtab, add the Line ID field.
-
Modify the CSV file and enter the correct line ID of the items.
Please enter value(s) for: <Field XYZ>
In NetSuite, transactions like sales orders are stored with the forms when they are created.
When you import updates to sales orders, NetSuite doesn’t check required fields on the form you pick in Advanced Options—it checks them on the form the record was originally saved with.
If a sales order was saved with a custom form, and you later make a field required on that form, you’ll get an error about missing field values.
You can’t update the sales order with a CSV import unless you do one of the following:
-
Set a value for the required field specified in the error, or
-
Clear the Validate Mandatory Custom Fields box on the Advanced Options menu.
This behavior applies only to CSV updates for transactions.