how to import expense report with several lines?
# ask-stanley-ai
h
how to import expense report with several lines?
c
AI generated answer (using internal Slack threads):
To import an expense report with several lines in NetSuite, you need to use the multi-file CSV import feature. This is because each line of the expense report needs to have a unique external ID, and the multi-file CSV import allows you to do this. Here are the steps to follow: 1. Prepare your CSV files. You will need one file for the expense report header and separate files for each line of the expense report. Each line should have a unique external ID. 2. Go to Setup > Import/Export > Import CSV Records. 3. Select the record type you want to import. In this case, it would be 'Expense Report'. 4. Choose 'Multiple Files to Upload' and upload your CSV files. 5. Map the fields in your CSV files to the corresponding fields in NetSuite. Make sure to include the external ID in your mapping. 6. Click 'Next' and then 'Finish' to start the import process. Remember, the external ID must be unique for each line in the same Expense Report. If you omit the External ID, it creates multiple records, if you repeat the ID, it fails on the second line. Please refer to SuiteAnswers ID 31843 for more detailed information. ****** 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.86197114
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.830790341
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.830605924
Please provide your feedback on this answer.