Scenario

When Importing a CSV File, the following error message is received: "Please enter a value for amount."

Solution

The error is derived when NetSuite import does not recognize the format of the data in the CSV file. Also, make sure that there is no zero value under the Amount column as some imports requires amount to be non-zero. To resolve this, format the Amount column in the CSV File using a third party application, like Excel:

1. Highlight the column
2. Right click
3. Select Format Cells
4. Click Number tab
5. Select Number
6. Click OK
7. Save the File