I’m trying to update a custom line-level field called Interface Status on invoice records in NetSuite via CSV import. The import process completes successfully, and I can see changes to other fields, such as Ship To information however these are not added during the field mapping step. However, the Interface Status field isn’t being updated on any of the line items. I’ve ensured that the field is correctly mapped in the import assistant and that I have permissions to edit the field. Here are the settings I used: • Data Handling: Update • Ignore Read-Only Fields: Checked • Validate Mandatory Custom Fields: Checked • Overwrite Missing Fields: Unchecked The Interface Status field is accessible and editable for my role, and it’s enabled on the custom form I’m using for invoices. Additionally, the System Notes show no changes for this field, but they do show updates for other fields like Ship To. Could you help me understand why the Interface Status field isn’t updating through CSV import, even though all other mapped fields are working as expected? I do not have a Line ID, and I want to update all lines on the invoice with the same interface status.

AI generated answer (using internal Slack threads):

Based on the conversations provided, it seems like you're encountering a common issue with updating line-level fields via CSV import in NetSuite. The problem might be due to the fact that NetSuite requires a unique identifier to update line-level fields, which is typically the Line ID. However, you mentioned that you do not have a Line ID. In this case, you might want to consider using the 'Order Line' field as a unique identifier for each line item, as suggested in one of the conversations. This field represents the line number of the item on the sales order, and it might be available for you to use even if you don't have a Line ID. Here are the steps you could follow: 1. Add a column in your CSV file for 'Order Line'. This should contain the line number for each item on the invoice. 2. In the CSV Import Assistant, map the 'Order Line' field in your CSV file to the 'Order Line' field in NetSuite. 3. Proceed with the import as usual. Please note that this solution assumes that the 'Order Line' field is available and editable for your role, and that it's enabled on the custom form you're using for invoices. If this is not the case, you might need to adjust your form or role settings accordingly. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

I also do not have the order id

The agent hasn't yet been programed to respond to follow-up questions in the thread. But you can continue asking in the main channel.