On csv import of a sales order with lots, I'm getting an error of "The total inventory detail quantity cannot be greater than 1." How can I resolve this?

AI generated answer (using internal Slack threads):

The error message "The total inventory detail quantity cannot be greater than 1" typically occurs when you are trying to import a CSV file of a sales order with lot numbers, and the total quantity of the inventory detail is more than the quantity of the item available. To resolve this issue, you need to ensure that the total quantity of the inventory detail matches the quantity of the item available. This can be done by adjusting the quantities in your CSV file to match the available inventory. Here are the steps you can follow: 1. Open your CSV file and locate the column for the inventory detail quantity. 2. Adjust the quantities in this column to match the available inventory for each item. 3. Save your changes and try to import the CSV file again. If you are still encountering the error, you may need to check the lot numbers for each item. Each lot number should be unique and should not be duplicated in the CSV file. If there are duplicate lot numbers, you will need to correct them before importing the CSV file. Remember, when importing inventory information and lot numbers from a CSV file in NetSuite, you need to map the fields to the appropriate subrecord of the inventory detail. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******