https://www.sikich.com

NetSuite 2017.1 Updates: CSV Import Enhancements

Mike Kean

May 19 2017

2 min read

The new NetSuite 2017.1 release has enhanced the user experience in a variety of ways, one of which is the CSV import function. NetSuite has added two new features to using the CSV import function: consolidated exchange rate updates and large custom list imports.

CSV Import Supported for Consolidated Exchange Rate Updates

Users are now able to import from CSV files to update consolidated exchange rate record data in NetSuite. If your organization uses OneWorld, has multiple subsidiaries with different base currencies, and manually edits various consolidated exchange rates, then take advantage of this enhancement!

First, navigate to List > Accounting > Consolidated Exchange Rates and view a current exchange rates. Before updating a record via import, it is always a good idea to familiarize yourself with the fields of this record.

Notice the following fields. These are the fields on the record that you can map to and update.

Average Exchange Rate
Current Exchange Rate
Historical Exchange Rate

NetSuite also requires an external ID or an internal ID to uniquely identify the consolidated exchange rate you are updating.

To import updated consolidated exchange rate data, navigate to Setup > Import/Export > Import CSV Records. Only the Update data handling option is available for the import of this type of data.

Large Custom List Imports Supported

Users are also now able to import a much larger amount of data than previously. CSV Import now supports the import of custom lists that have up to 25,000 values. The import Assistant checks to ensure that the custom list you are importing has 25,000 values or less before proceeding with the import.

If you would like more information abut the new CSV import function features, please contact us at any time. You can also learn about more great tips for NetSuite on our YouTube playlist or our other blog posts.

This publication contains general information only and Sikich is not, by means of this publication, rendering accounting, business, financial, investment, legal, tax, or any other professional advice or services. This publication is not a substitute for such professional advice or services, nor should you use it as a basis for any decision, action or omission that may affect you or your business. Before making any decision, taking any action or omitting an action that may affect you or your business, you should consult a qualified professional advisor. In addition, this publication may contain certain content generated by an artificial intelligence (AI) language model. You acknowledge that Sikich shall not be responsible for any loss sustained by you or any person who relies on this publication.

About the Author

Mike Kean

Mike Kean is the managing principal of Sikich’s technology practice with more than 25 years of experience serving clients. His expertise lies in the software selection process and managing of multi-faceted implementations for mid-market businesses. Mike has extensive experience working with companies making critical and complex decisions regarding software solutions to manage and grow their businesses.