Error: "Please Enter a Value for *Amount*" Received During CSV Import
Published 09/02/2014 11:53 PM | Updated 09/21/2020 12:41 AM | Answer Id: 39673
Applies To
Product: NetSuite 2020.2
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