How to Connect Amalgam to NetSuite
Connect Oracle NetSuite to Amalgam to pull your NetSuite reports into your spreadsheets, Claude or ChatGPT, and to create and edit NetSuite records from Excel or Google Sheets. NetSuite connects through an integration record you set up in your NetSuite account, then a NetSuite sign-in.
What You Need
Section titled “What You Need”- A NetSuite administrator, or someone who can enable features and create integration records in NetSuite.
- A NetSuite role that includes the Log in using OAuth 2.0 Access Tokens permission, for the person who signs in.
- An Amalgam account.
Set Up NetSuite
Section titled “Set Up NetSuite”1. Turn On the Features
Section titled “1. Turn On the Features”Go to Setup, then Company, then Enable Features, then SuiteCloud:
- Under “SuiteTalk (Web Services)”: enable SOAP Web Services and REST Web Services
- Under “Manage Authentication”: enable OAuth 2.0
2. Create the Integration Record
Section titled “2. Create the Integration Record”Go to Setup, then Integration, then Manage Integrations, and create a new record with these settings:
- Integration State: Enabled
- Token-based authentication: checked
- TBA: Authorization Flow: unchecked
- OAuth 2.0: checked
- Authorization Code grant: checked
- Public Client: checked
- Redirect URL:
https://app.amalgam.me/callback/netsuite/ - Refresh token validity (in hours): 720
- Maximum time for token rotation (in hours): 720
- Client credentials (machine-to-machine) grant: checked
- Scopes: RESTlets, REST Web Services and SuiteAnalytics Connect, all checked
Public Client and the two 720-hour settings keep the connection signed in for up to 30 days, instead of NetSuite’s default of 7.
3. Copy the Client ID and Client Secret
Section titled “3. Copy the Client ID and Client Secret”NetSuite shows the Client ID and Client Secret once, when you save the record. Copy both; you enter them in Amalgam next.
Connect NetSuite
Section titled “Connect NetSuite”- Log in at app.amalgam.me.
- Click New Integration and choose Oracle NetSuite. You can type the name in the search box to find it.
- Enter a company name, your NetSuite Account ID, and the Client ID and Client Secret from the integration record. The Account ID must match the one in your NetSuite URL.
- Amalgam sends you to NetSuite’s sign-in page. Sign in, choose the role to connect with, and allow access. If more than one application is listed, pick the one you created the integration record under. NetSuite sends you back to Amalgam with the integration ready to use.
What You Can Pull
Section titled “What You Can Pull”Reports include Balance Sheet, P&L, Trial Balance, General Ledger, Trended P&L by Department, and A/P and A/R Aging in detail and summary. See Reports by Provider.
Resources let you read and write Accounts, Customers, Vendors, Invoices and Journal Entries, load new transactions with the Transaction Loader, and bulk edit existing transactions with the Transaction Reclassifier. See Resources Introduction.
Troubleshooting
Section titled “Troubleshooting”- Reports fail after 7 days: the integration record is still on NetSuite’s default token settings. Edit the record in NetSuite: tick Public Client and set Refresh token validity (in hours) and Maximum time for token rotation (in hours) to 720. Then open the integration in Amalgam and reconnect. After that the connection lasts up to 30 days before you need to reconnect.
- The sign-in fails: go back through the settings in Set Up NetSuite, especially the Account ID, the redirect URL, and the OAuth 2.0 permission on the role you sign in with.