importing inventory worksheet and receiving the fo...
# ask-stanley-ai
a
importing inventory worksheet and receiving the following error: Invalid invtid reference key A21 for subsidiary 3.
c
AI generated answer (using internal Slack threads):
The error message "Invalid invtid reference key A21 for subsidiary 3" typically indicates that the inventory item with internal ID A21 is not available or not active for the subsidiary with internal ID 3. Here are a few things you can check: 1. Verify the Inventory Item: Check if the inventory item with internal ID A21 is active and available in your NetSuite account. You can do this by navigating to Lists > Accounting > Items and searching for the item. 2. Check the Subsidiary Association: Ensure that the inventory item is associated with the correct subsidiary (subsidiary 3 in this case). You can check this in the item record under the 'Subsidiaries' subtab. 3. Check the CSV File: Make sure that the CSV file you are using for import is correctly formatted and the values for the inventory item and subsidiary are correct. The inventory item internal ID should match the 'invtid' field and the subsidiary internal ID should match the 'subsidiary' field. 4. Check the Import Assistant Settings: When using the Import Assistant, ensure that you have selected the correct options for the 'invtid' and 'subsidiary' fields. For 'invtid', you should select 'Internal ID' and for 'subsidiary', you should select 'Internal ID' or 'Name' depending on the data in your CSV file. Remember, the inventory item must be active and associated with the correct subsidiary for the import to be successful. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.840621948
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.832157671
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.828370929
Please provide your feedback on this answer.