Enhanced Data Import and Export Options in NetSuite

Data import and export in Oracle NetSuite offers various options that extend beyond the standard CSV Import Assistant. These methods allow users to streamline data handling activities while maintaining accuracy and efficiency in transactions.

What Are the Additional Import and Export Options?

NetSuite provides several functional areas for importing and exporting data:

• Importing a Peachtree CSV File: This is specifically designed for users of Peachtree Accounting software. Users can import lists such as Accounts Receivable, Accounts Payable, Payroll, General Ledger, and Inventory items.
• Exporting Selected Lists and Reports as CSV Files: This includes exporting data on accounting lists, classes, contacts, customers, departments, and more.
• Extracting Data from NetSuite: A detailed process for data extraction tailored to specific business needs.
• Replacements for smbXML: These options help ensure that necessary data formats are supported in NetSuite.
• Emailing or Faxing NetSuite Forms: Facilitates direct communication from within the platform.

How to Import a Peachtree CSV File

To import Peachtree data into NetSuite, follow these steps:

1. Export data from Peachtree: Navigate to the Import/Export section in Peachtree, select the list category, and ensure to check 'Include Headings' in the export options. This helps maintain the correct mapping.
2. Review Column Headings: Open the CSV file in a spreadsheet application to confirm the column headings match the required NetSuite fields.
3. Import into NetSuite: Follow the guidelines in the "Importing CSV Files with the Import Assistant" documentation for best practices during the import process.

Full CSV Export Capabilities

The Full CSV Export feature in NetSuite enables users to export data for:

• Accounting Lists
• Customers
• Employees
• Vendors
• Classes and more.

Known Limitations

Be aware that CSV files exported may face formatting issues when opened directly in Excel, particularly with numeric sequences longer than 16 digits. It’s advisable to use the Excel Text Import Wizard to avoid precision loss.

Conclusion

Utilizing the varied options for data import and export in NetSuite not only simplifies the data transition process but enhances overall operational efficiency, ensuring businesses can leverage their financial information effectively.

Who This Affects

• Administrators: Responsible for managing system integrations and data.
• Developers: Need to understand how to manipulate data effectively with different formats.
• Accountants: Regularly utilize financial data for reporting and analysis.

Key Takeaways:

• NetSuite offers more than just the CSV Import Assistant for data handling.
• Users can import Peachtree data and export a range of record types using Full CSV Export.
• Be cautious of Excel's limitations with long numeric values to preserve data integrity.
• Always ensure column headings match between exported and expected formats for successful imports.

Source: This article is based on Oracle's official NetSuite documentation.