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:

  1. Go to Setup > Import/Export > Import CSV Records.

  2. Specify an import type of Transaction and a record type of Sales Order.

  3. Specify data handling of Update.

  4. On the Advanced Options menu, check Overwrite Sublists.

    Warning:

    Use this option with extreme caution.

  5. 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:

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:

  1. Go to Lists > Search > Saved Searches > New > Transaction.

  2. On the Criteria > Standard subtab, add a filter Type of Sales Order.

  3. On the Results > Columns subtab, add the Line ID field.

  4. 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:

Important:

This behavior applies only to CSV updates for transactions.

Related Topics

General Notices