i have a csv with just 1 column and these are the ...
# ask-stanley-ai
n
i have a csv with just 1 column and these are the invoice numbers. For each invoice i want to update a custom item field. When doing Import CSV, Update and then overwrite sublist it does not alter the item field.
c
AI generated answer (using internal Slack threads):
****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** Based on the conversations, it seems that updating a custom item field via CSV import in NetSuite can be a bit tricky. The CSV import tool in NetSuite does not support all record types, and in some cases, scripting might be the only solution. However, if you're trying to update a custom field on an invoice, you might be able to do it using the 'External ID' field. You can set the 'External ID' field in one file with a list of header values, and then in another file, also have 'External ID' as column 1 with each row representing the lines of the said transaction. This essentially creates a data table with a join on 'External ID'. If you're trying to update a sublist, such as an address field in a customer record, you might need to map the address ID since the address is a separate record. If the ID for the address record is not mapped, then updates won't work. Remember to select "overwrite sublist" when doing the import. If you're still having trouble, you might want to check out this NetSuite SuiteAnswers article for more information: https://suiteanswers.custhelp.com/app/answers/detail/a_id/69618/loc/en_US Please note that these are general suggestions and might not work in all scenarios. Always test in a sandbox environment before making changes in your live account.
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.859956741
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.834118903
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.831824243
Please provide your feedback on this answer.