Please enter value(s) for: Amount, Department when trying to CSV import and update some custom fields in Expense Report

AI generated answer (using internal Slack threads):

When trying to CSV import and update some custom fields in Expense Report, you need to ensure that the 'Amount' and 'Department' fields are correctly mapped in your CSV file. For the 'Amount' field, ensure that the values are in the correct format, i.e., they should be numerical and should not contain any special characters or alphabets. For the 'Department' field, you need to ensure that the department names or IDs in your CSV file match exactly with the department names or IDs in NetSuite. If there is any discrepancy, the import will fail. In addition, you need to ensure that the 'Overwrite Sublist' option is checked in the CSV Import Assistant. This option allows you to overwrite the existing sublist values with the new values from your CSV file. If you want to update a custom field and set it to NULL, you need to ensure that the 'Overwrite Missing Fields' option is checked in the CSV Import Assistant. This option allows you to overwrite the existing field values with blank values from your CSV file. Here is a sample of how your CSV file should look like:

"Transaction ID","Line ID","Amount","Department"
"123","1","1000","Sales"
"124","2","2000","Marketing"

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******