NetCash Transfer from Sandbox to Production

Overview

Once user acceptance testing in sandbox is complete, all NetCash data will need to be transferred to production before Go Live. This process is outlined below.

Step by Step Process

Client Preparation

• Delete or inactivate any records that should not be transferred to production (i.e. test automation rules, bank accounts)
• Ensure your data validation has been completed
• Configure NetCash permissions in production (your consultant is unable to do this per Netgain policy)
• Connect your bank institution and bank accounts, if connecting via API
• Provide your Netgain implementation consultant access to your production account

Transfer to Production

If granted production access, your Netgain implementation consultant will perform the following steps.

Transfer Bank Institutions and Bank Accounts

1. Add Bank Institution and Bank Accounts Manually
2. If adding several bank accounts, it's recommended to do a CSV upload. Instructions can be found in the last section of the article linked above

Transfer Automation Rule Groups

To add Automation Rule Groups manually, follow the instructions found here. If adding a large quantity of automation rule groups, it's recommended to do a CSV upload, as instructed below. 

1. In sandbox, search 'NetCash Automation Rule Group' in your global search bar and navigate to Page: NetCash Automation Rule Group
2. Ensure that Name, NetCash Bank Account, and Description are displayed. To add fields, select Edit View View full size
3. Download this list as a CSV file
4. In production, navigate to Setup > Import/Export > Import CSV Records
5. For Import Type, select Custom Records, and for Record Type, select NetCash Automation Rule Group
6. Ensure the Custom Multi-Select Value Delimiter is a comma View full size
7. Follow the prompts to finish the import

Transfer Transaction Templates

Each automation rule contains a transaction template. These transaction templates are numbered and may be associated with transaction template lines (transferred in another step below). Before uploading your automation rules, you will need to upload your transaction template numbers.

1. In sandbox, search 'NetCash Transaction Template' in your global search bar and navigate to Page: NetCash Transaction Template
2. The only field needed is "Name." Download this list as a CSV file View full size
3. In production, navigate to Setup > Import/Export > Import CSV Records
4. For Import Type, select Custom Records, and for Record Type, select NetCash Transaction Template
5. Follow the prompts to finish the import

Transfer Automation Rules

To ensure all fields are included, the best way to pull your automation rule list is via saved search.

1. In sandbox, create a NetSuite saved search on NetCash Automation Rule
2. Under Results, select Add Multiple View full size
3. Select All fields (select the first row, hold down SHIFT, then select the last row) and Add View full size
4. Save & Run search View full size
5. Download the results as a CSV file
6. In production, navigate to Setup > Import/Export > Import CSV Records
7. For Import Type, select Custom Records, and for Record Type, select NetCash Automation Rule
8. Follow the prompts to finish the import

Transfer Automation Rule Filters

1. In sandbox, search 'NetCash Automation Rule Filter' in your global search bar and navigate to Page: NetCash Automation Rule Filter
2. Ensure all fields below are displayed. To add fields, select Edit View View full size
3. Download this list as a CSV file
4. In production, navigate to Setup > Import/Export > Import CSV Records
5. For Import Type, select Custom Records, and for Record Type, select NetCash Automation Rule Filter
6. Follow the prompts to finish the import

Transfer Matching Criteria

To ensure all fields are included, the best way to pull the Matching Criteria list is via saved search.

1. In sandbox, create a NetSuite saved search on NetCash Matching Criteria
2. Under Results, select Add Multiple View full size
3. Select All fields (select the first row, hold down SHIFT, then select the last row) and Add View full size
4. Save & Run search View full size
5. Download the results as a CSV file
6. In production, navigate to Setup > Import/Export > Import CSV Records
7. For Import Type, select Custom Records, and for Record Type, select NetCash Matching Criteria
8. Follow the prompts to finish the import

Transfer Automation Rule Grouping

If any rules include a grouping (matching one-to-many), follow the steps below to transfer this list.

1. In sandbox, search NetCash Automation Rule Grouping in your global search bar and navigate to Page: NetCash Automation Rule Grouping
2. Ensure that Name, Data Source, Field, and Rule are displayed. To add fields, select Edit View View full size
3. Download this list as a CSV file
4. In production, navigate to Setup > Import/Export > Import CSV Records
5. For Import Type, select Custom Records, and for Record Type, select NetCash Automation Rule Grouping
6. Follow the prompts to finish the import

Transfer Transaction Template Lines

To ensure all fields are included, the best way to pull the Transaction Template Line list is via saved search.

1. In sandbox, create a NetSuite saved search on NetCash Transaction Template Line
2. Under Results, select Add Multiple View full size
3. Select All fields (select the first row, hold down SHIFT, then select the last row) and Add View full size
4. Save & Run search View full size
5. Download this list as a CSV file
6. In production, navigate to Setup > Import/Export > Import CSV Records
7. For Import Type, select Custom Records, and for Record Type, select NetCash Transaction Template Line
8. Follow the prompts to finish the import

Client Data Validation in Production

Once data has been uploaded to production, it is the client's responsibility to validate the data. It is recommended to use this article as a guide.