I'm trying to import Customer Refunds via CSV import, and I'm having a bit of trouble applying them. Can you explain what data I should have in my csv file and what fields to match to in NetSuite to do this successfully?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To import Customer Refunds via CSV in NetSuite, you should be aware that direct CSV imports for Customer Refunds are not supported by default. However, there are workarounds that you can use to achieve this. One such workaround involves using a workflow to transform a record from a Credit Memo. Here's a step-by-step guide on how you can do this: 1. Add a checkbox to your Credit Memo record called "To be refunded". 2. Update this checkbox via CSV import to set it to true for the records you want to refund. 3. Create a workflow that triggers when this checkbox is set to true. This workflow should transform the Credit Memo into a Customer Refund. Please note that this method might not work well if your customer refunds are issued via credit card. It's recommended to try this method in a sandbox environment first to ensure it works as expected. Alternatively, you can use third-party tools like CloudExtend Excel for NetSuite, which supports Customer Refund record type. Remember to always test these methods in a controlled environment before applying them to your live data.