importing Sales order via CSV to close out lines but receiving Invalid item reference key for subsidiary 1 but the item has that subsidiary selected

AI generated answer (using internal Slack threads):

Based on the conversations, the error "Invalid item reference key for subsidiary" typically occurs when there is a mismatch between the item's internal ID and the subsidiary ID during a CSV import. Here are some potential solutions: 1. Ensure the item and subsidiary are active: The item and subsidiary must be active in NetSuite. You can check this by navigating to the item or subsidiary record and ensuring the 'Inactive' checkbox is not selected. 2. Check the mapping: Make sure you are mapping the internal ID of the item and subsidiary correctly in the CSV import. You can do this by clicking on the pencil icon in the mapping settings and changing the reference type to 'Internal ID'. 3. Verify the subsidiary field on the item record: The subsidiary field on the item record should include the subsidiary you are trying to import. You can do this by either selecting the subsidiary directly or using the 'Include Children' checkbox. 4. Check the system info tab: Navigate to the system info tab on the item record and ensure the item is not set to inactive. 5. Check the custom form: If you are using a custom form for your import, ensure it does not have an Item Filter. You can also try importing using the standard sales order form. 6. Turn off "Trigger Custom Scripts and Workflows": This can be done in the CSV import settings. 7. Check for scripts: If you have any scripts deployed to the sales order, they could be causing the issue. 8. Check the data in your CSV file: Ensure there are no special characters or extra spaces in your CSV file that could be causing the issue. 9. Try using the item name instead of the internal ID: If all else fails, you can try importing using the item name instead of the internal ID. Remember to always double-check your data and settings before attempting the import. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******