NetSuite CSV import says an amount is missing
Check which field supplies the amount, whether an expense line needs a rate or quantity, and whether a sales order item is missing its base price.
An expense amount needs a rate or quantity
Message looks like
Please enter value(s) for: Amount
What it means
An expense line is missing the value NetSuite needs to price it. The message says Amount, but the missing field can be Amount, Rate, or Quantity.
Import context: Expense reports.
Check this first
Check each expense line for whichever of Amount, Rate, and Quantity your report layout requires.
Show the steps
Steps for this error
- The message covers three sublist fields together: Amount, Rate, and Quantity. Any of them can determine the line amount.
- Check each expense line for the missing value among those fields.
- Supply the value or its mapping and retry one report.
Documentation checked September 16, 2026.
The amount cannot be determined
Message looks like
Please enter a value for amount
What it means
NetSuite cannot settle on an amount, most often because the import repeats a line or the Amount column is not formatted as a plain number.
Import context: General imports.
Check this first
Check for duplicate lines and format the Amount column as a number without symbols or zero values.
Show the steps
Steps for this error
- Check the import for duplicate lines, such as the same item twice on one transaction.
- Format the Amount column as a number without symbols, and check for zero amounts. Some imports do not accept zero.
- Retry one row.
Documentation checked September 16, 2026.
A sales order amount cannot be read from the item
Message looks like
Please enter value(s) for: Amount
What it means
The sales order line arrived without an amount because the import could not read the item's price, either from the way the item is mapped or because the item has no base price.
Import context: Sales orders.
Check this first
Map the item by internal ID so the amount fills from the item record, then check the imported items for a missing base price.
Show the steps
undefined
- Map the Item by Internal ID on the Field Mapping page. With the internal ID, the amount fills automatically from the price on the item record.
- If the error continues, some imported items have no base price. Open each item and check Base Price on the Sales/Pricing subtab.
- Populate the missing base prices, save the items, and retry the import.
These steps follow SuiteAnswers Answer 82833, Sales Order Import > Please Enter Value for Amount, which requires a NetSuite sign-in to view. The wording and resolution were supplied during translator testing.
Documentation checked September 16, 2026.
Related errors
- NetSuite cannot read the date or posting period
- Event dates or times are missing or invalid
- Numbers or identifiers changed in the CSV
- The vendor bill total disagrees with its lines
Book a free 30-minute look at your import error
Bring the error and your file to a screen share and I will dig into it live. Thirty minutes is usually enough to find what is wrong and tell you what fixing it takes. Sometimes that settles it on the call; when it does not, you leave with a straight answer instead of a mystery. No cost and no obligation.
An import that keeps failing is often the first visible sign of a larger setup problem. Most of my client work starts exactly here: somebody mid-import, a file that will not load, and nobody on their side to email. If a migration or implementation sits behind this error, that is the work I do every week.