how to import invoice contain service item and lot inventory items in net suite

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To import invoices containing service items and lot inventory items in NetSuite, you can follow these steps: 1. Prepare your CSV file: Your CSV file should contain all the necessary information for the invoices, including service items and lot inventory items. For lot inventory items, you should include the lot number in the inventory detail subrecord. 2. Import the CSV file: In NetSuite, navigate to Setup > Import/Export > Import CSV Records. Choose the record type as 'Transaction' and the import type as 'Sales Order' or 'Invoice' depending on your requirement. 3. Map the fields: In the mapping step, map the fields in your CSV file to the corresponding fields in NetSuite. For lot inventory items, map the lot number to the appropriate subrecord of the inventory detail. 4. Run the import: After mapping the fields, run the import. NetSuite will import the invoices and create the necessary records. Remember, if you are importing historical transactions and inventory movements, the complexity increases significantly. It's recommended to have a clear understanding of your needs and the implications of the import process. If you're unsure, consider seeking advice from experts or those with experience in this area. For creating new lots of lot controlled items, you can do this via an inventory adjustment import. This allows you to add new inventory for an existing item and assign specific new lot numbers. Please note that this process should be done with care, as it directly affects your accounting and inventory management in NetSuite.