Please complete the steps below before your call with the Cube team. This should take approximately 15–20 minutes. All steps are performed in your NetSuite account.
When you're done, you will have:
- A NetSuite integration record with Consumer Key and Consumer Secret
- An Access Token with Token ID and Token Secret
- Your NetSuite Account ID
- A saved Transaction Search exported to CSV
Phase 1: Create the Integration Record
This creates a connection point in NetSuite that Cube will authenticate against.
- Go to Setup > Integration > Manage Integrations > New
- Name the integration Cube Data Extract (or any name you prefer).
- Check Token-based Authentication and uncheck Authorization Code Grant.
- Click Save.
- Copy the Consumer Key and Consumer Secret displayed at the bottom of the screen. You will share these on the call.
| ⚠ IMPORTANT: The Consumer Key and Consumer Secret are only shown once. Copy them before navigating away. |
Phase 2: Generate an Access Token
Access tokens link your user, role, and integration together. Follow the Standard Workflow below. If you see a permissions error, use the Alternate Workflow instead.
Standard Workflow
- Go to Setup > Users/Roles > Access Tokens > New.
- Set Application Name to the integration you just created (Cube Data Extract).
- Set User to your own Admin user account.
- Set Role to Administrator.
- Click Save.
- Copy the Token ID and Token Secret. You will share these on the call.
| ⚠ IMPORTANT: If you see a ‘You do not have permission’ error or cannot reach the Access Tokens page from the Setup menu, skip to the Alternate Workflow below. |
Alternate Workflow: Generate Token via the Home Dashboard
NetSuite’s home dashboard Settings portlet provides direct access to token management and bypasses the Setup menu permission check.
- Go to your NetSuite Home page (house icon in the top nav).
- Locate the Settings portlet in the bottom-left of the dashboard.
| NOTE: If the Settings portlet isn’t visible, click Personalize Dashboard in the top-right, find Settings in the portlet list, and add it. |
- Click Manage Access Tokens in the Settings portlet.
- Click New Access Token.
- Set Application Name to Cube Data Extract.
- Confirm the User field defaults to your logged-in Admin account — leave it as-is.
- Set Role to Administrator.
- Click Save.
- Copy the Token ID and Token Secret immediately. You will share these on the call.
| ⚠ IMPORTANT: The Token ID and Token Secret are only shown once at creation. If lost, the token must be deleted and a new one generated. |
Phase 3: Retrieve Your Account ID
- Go to Setup > Integration > SOAP Web Services Preferences.
- Copy the Account ID displayed at the top left of the page. You will share this on the call.
Phase 4: Create the Transaction Saved Search
Cube uses this saved search to pull your transaction data. Follow the steps carefully — the field labels must match exactly.
Create the Search
- Go to Reports > Saved Searches > All Saved Searches > New.
- Select Transaction as the search type.
Criteria Tab
Under the Criteria tab, add the following four filters:
| Filter | Value |
| Posting | Yes |
| Internal ID (Number) | Not Empty |
| Account Type | None of: Non Posting, Statistical |
| Date | Not before Jan 1, 2025 |
Results Tab
Under the Results tab, click Remove All to clear the default fields, then add the following required fields exactly as listed. Custom Labels must match exactly, including capitalization.
| ⚠ IMPORTANT: The file upload will fail if any required field is missing or if any Custom Label does not exactly match what is listed below — including capitalization. |
| Field | Custom Label (type exactly as shown) |
| Line Unique Key | lineuniquekey |
| Account Fields > Internal ID | Account ID |
| Account Fields > Name | Account Name |
| Type | No custom label needed |
| Amount | No custom label needed |
| Account Type | No custom label needed |
| Period | No custom label needed |
Additional Dimension Fields (if applicable)
If you report on dimensions such as Department, Subsidiary, Vendor, Class, or Location, add an Internal ID and Name pair for each one:
- For each dimension: add [Dimension] Fields > Internal ID with the Custom Label “[Dimension] ID” (e.g., Department Fields > Internal ID → Custom Label: Department ID)
- For each dimension: add [Dimension] Fields > Name with the Custom Label “[Dimension] Name” (e.g., Department Fields > Name → Custom Label: Department Name)
| NOTE: When adding Results fields, the “[Dimension] Fields” options (e.g., Department Fields, Subsidiary Fields) appear at the bottom of the dropdown list. They are sorted alphabetically, but the alphabet repeats at the bottom with “fields...” after each entry. |
Save the Search
- Name the search Cube Transaction Search and click Save.
Phase 5: Export the Search Results and Upload to Cube
- Go to Reports > Saved Searches > All Saved Searches.
- Find the Cube Transaction Search you just created and click Persist CSV on the right side.
- Refresh the browser until the file is ready, then click Download.
- Upload the downloaded CSV file to the Cube File Library so the Cube team can access it directly.
| NOTE: Uploading to the Cube File Library is preferred over email — transaction exports can be large and may exceed email attachment limits. |
What to Have Ready for the Call
Please have the following on hand when you join:
| Credential / Item | Where to find it |
| Consumer Key | Phase 1 — Integration record |
| Consumer Secret | Phase 1 — Integration record |
| Token ID | Phase 2 — Access Token |
| Token Secret | Phase 2 — Access Token |
| Account ID | Phase 3 — SOAP Web Services Preferences |
| Transaction CSV uploaded | Phase 5 — Cube File Library |
If you run into any issues completing these steps, reach out to the Cube team before the call and we’ll help you sort it out.