I did an CSV Import, "ADD" of Inventory Adjustment, a few lines were successful but the rest failed with "This record already exists". But how is that possible when creating inventory adjustment records. I didn't import any columns that set the IA internal ID.

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like you're encountering an issue with the internal ID during the CSV import of Inventory Adjustment. This could be due to the fact that you're trying to map the internal ID of the items to the internal ID field listed in the import manager fields. This field is actually the internal ID for the transaction, not the items. Instead, you should map the internal item ID field in your file to the 'item' field in the import manager. After mapping, click the pencil icon next to the field mapping, and then select 'internal id' in the additional drop-down. This should allow the system to recognize the item using the internal ID. Also, when creating new records via import, an External ID is required. This can be any value, for example, 'Invadj_92922'. As for the issue with Inventory Status not showing up during CSV Import, it's not clear from the conversations why this is happening. It might be a system issue or related to the specific settings of your NetSuite account. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

FWIW I assumed that External ID was both mandatory and inconsequential - it's not inconsequential.