YASSER
08/27/2024, 8:19 PMCeligo AI
08/27/2024, 8:20 PMAI generated answer (using internal Slack threads):To upload service item invoices through CSV in NetSuite, you can follow these steps: 1. Prepare your CSV file: Your CSV file should contain all the necessary information for the invoices. This includes the customer, item, quantity, rate, and any other necessary fields. If you want the invoice numbers to be auto-generated, you should exclude the Invoice# column from your CSV file. If you include this column and leave it empty, it will produce an error when you try to upload the CSV file. 2. Set an External ID: If you don't set a document number, you'll have to set an External ID. This can be used to tie together multiple lines of the same invoice. For example, if your import file has 20 lines but only 5 customers, and each line has a different amount or item, the line will be given a new number and they will produce 4 invoices in NetSuite. 3. Upload the CSV file: In NetSuite, navigate to Setup > Import/Export > Import CSV Records. Select the record type as 'Transactions' and the import type as 'Transactions'. Then, upload your CSV file. 4. Map the fields: In the next step, you'll need to map the fields in your CSV file to the corresponding fields in NetSuite. Make sure that all necessary fields are mapped correctly. 5. Import the records: Once the fields are mapped, you can proceed with the import. NetSuite will then create the invoices based on the information in your CSV file. Remember, if you're adding a line item to an invoice and that line doesn't already exist on the invoice, it will get added. If it exists, it will get updated. If it exists more than once, it will get an error. Also, you can change the sales price of an item based on your CSV by setting the price level to custom. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Celigo AI
08/27/2024, 8:21 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.821061432
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.819020689
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.817088127
Celigo AI
08/27/2024, 8:21 PM