, Has anyone here handled a NetSuite data migration that included historical transaction details? I'm just looking for some quick tips or best practices if you have any. Thanks!

AI generated answer (using internal Slack threads):

Based on the conversations, here are some tips and best practices for handling a NetSuite data migration that includes historical transaction details: 1. Ensure Data Consistency: When uploading transactional data, the sum of your balances on invoices must equal their trial balance for the same period. If you must upload paid invoices, you also must upload payments. 2. Consider Non-Posting Transactions: You could evaluate Custom Sales Transactions for this purpose. You can make them non-posting and even use your normal items and keep your historical dollar values and descriptions correct. This approach doesn't allow anyone to mess anything up - it's just strictly a reporting tool. 3. Use of Clearing Account: One approach is to upload historical invoices as Cash Sales to a clearing account and then reverse the clearing balance. 4. Consider the Degree of Information Needed: There are many parameters to take into account in a financial migration. It all depends on the degree of information from your old system that you need on your Netsuite. You must import GL, open transactions, interco transactions, deferred expense and revenue, if you are doing revenue recognition, fixed asset. 5. Use of CSV Import: NetSuite provides a CSV import feature which can be used to import data. You can find a User Guide for CSV import in the help center or Suite Answers. 6. Consider Professional Help: If the migration process seems complex, consider talking to somebody that knows what's involved. This could be a NetSuite professional or a consultant. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******