i want to upload invoice through csv file with two...
# ask-stanley-ai
y
i want to upload invoice through csv file with two item lines one line for service item and line for lot inventory item the error You cannot create an inventory detail for this service item appear.
c
AI generated answer (using internal Slack threads):
The error you're encountering, "You cannot create an inventory detail for this service item", is likely due to the fact that you're trying to assign an inventory detail (such as a lot number) to a service item. In NetSuite, service items do not have inventory details as they are not physical items that can be tracked in an inventory. When you're creating your CSV file for the invoice, you should only include inventory details for the lot inventory item line, not for the service item line. Here's a simplified example of how your CSV file might look:
Copy code
Invoice Number, Item, Quantity, Rate, Inventory Detail
INV123, Service Item 1, 1, 100, 
INV123, Lot Inventory Item 1, 2, 50, Lot123
In this example, the service item line does not have an inventory detail, while the lot inventory item line does. When you import this CSV file into NetSuite, make sure to map the 'Inventory Detail' column to the appropriate subrecord of the inventory detail in your CSV Import mapping. Remember, you cannot assign an inventory detail to a service item in NetSuite. If you try to do so, you will encounter the error message you mentioned. ****** 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.847466171
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.84732753
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.846185505
Please provide your feedback on this answer.