How can I import a CSV file containing invoice numbers and update each line item with a specific manual value per invoice

AI generated answer (using internal Slack threads):

To import a CSV file containing invoice numbers and update each line item with a specific manual value per invoice, you can follow these steps: 1. Prepare your CSV file with the necessary columns. The columns should include the invoice number and the specific manual value you want to update for each line item. 2. In NetSuite, navigate to Setup > Import/Export > Import CSV Records. 3. Select the record type as 'Transactions' and the import type as 'Update'. 4. Upload your CSV file and map the fields in your CSV file to the corresponding fields in NetSuite. Make sure to map the invoice number field in your CSV to the 'External ID' field in NetSuite. This is because NetSuite uses the 'External ID' field to identify which records to update. 5. Run the import. NetSuite will update each line item in the invoices with the specific manual value from your CSV file. Remember, if you have activated auto-generated numbers in NetSuite, you can leave the invoice number column empty in your CSV file. NetSuite will automatically generate the next number in the sequence for each new invoice. However, if you do this, you will need to set an 'External ID' for each record in your CSV file. This is because NetSuite requires either a document number or an 'External ID' to identify records. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******