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
The CSV file should include the value for the Item field, which should be mapped to the Items : Item (Req) field. There is no need to map the Line ID.
Even if you set a default value for one or more fields in a sublist, no sublist data is 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).
The error occurs when the date format entered in the Date field is incorrect. For example instead of entering a date of 3/29/2014 the date was incorrectly entered as 3/29/20014.
The getFullYear() function returns a four-digit year, and an error occurs if the year contains 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, the Terms and Payment Method fields cannot be mapped simultaneously. You can only map one of those fields on the Field Mapping page.
If you enter Terms on a sales order, an invoice is automatically generated when it is billed. If you enter a Payment Method, a cash sale is automatically generated when it is billed.
Invalid item reference key xx
Please verify your import using the following best practices:
-
The Item Name column in the CSV file should use the format that is used in NetSuite. Verify that the format in the file matches the format of the Item dropdown list in Transactions > Sales > Enter Sales Orders> Items > Items.
-
Internal ID can also be used instead of Item Name. On the Field Mapping page, click the edit icon beside the Item field, click Choose Reference Type, and select 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 performing an import to update sales orders, the validation for mandatory fields is not performed on the form selected on the Advanced Options menu of the import. Instead, mandatory fields are validated on the form where the record being updated is saved.
If a sales order was saved using a custom form, and later that form is customized to set a certain field to mandatory, you will get an error about missing field values.
The sales order cannot be updated via CSV import unless you perform one of the following:
-
Set a value for the mandatory 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.