how to upload invoices using csv file and this invoices contains lot inventory items and service items

AI generated answer (using internal Slack threads):

To upload invoices containing lot inventory items and service items using a CSV file in NetSuite, you can follow these steps: 1. Prepare your CSV file with all the necessary information. This should include the invoice number, customer details, item details (both inventory and service items), quantity, price, and any other necessary details. If you have lot inventory items, make sure to include the lot number in a separate column. 2. If there are multiple serial numbers for a single item, use Alt + Enter to put all the serial numbers in a single cell. 3. Go to NetSuite and navigate to Setup > Import/Export > Import CSV Records. 4. Select the record type as 'Transactions' and the import type as 'Sales Order' or 'Invoice' as per your requirement. 5. Upload your CSV file and map the fields in the CSV file to the corresponding fields in NetSuite. Make sure to map the lot number to the 'Inventory Detail' subrecord. 6. If you want to create the invoice number on demand and then assign it to child line items in the following rows in the CSV, you can use the 'Line #' field to group the transactions based on the customer. You can also set an 'External ID' for each transaction and use it to join the header values with the line items. 7. After mapping all the fields, click on 'Next' and then 'Finish' to start the import process. Please note that this process will create new invoices in NetSuite based on the data in the CSV file. If you want to update existing invoices, you might need to use a different approach. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******