The Insert or Update Account action allows you to either create a new account or update an existing one within the NetSuite system. This ensures that account information is always accurate and up to date.
Configuration
NetSuite - Connection (ver. 1.0.0)
URL
URL of your NetSuite instance.
Account ID
Account ID for NetSuite API.
Consumer Key
Consumer key for NetSuite API.
Consumer Secret
Consumer secret for NetSuite API.
Token ID
Token ID for NetSuite API.
Token Secret
Token secret for NetSuite API.
NetSuite - Configuration (ver. 1.0.0)
Error behavior
The available values are:
-
Fail and return response: The connector fails at the specified line but generates output with error details.
-
Fail without response: The connector fails - the error will be displayed only in the log.
-
Do not fail and return response: The connector does not fail but generates output records that may be marked with an error and detailed information.
Input & Output Schema
Input
NetSuite - Account Update Request (ver. 1.1.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | The unique identifier of the account to be updated |
| Account | NetSuite - Account 1.3.0 |
No | The updated account details to be applied to the specified account |
NetSuite - Account (ver. 1.3.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| IsInactive | Bool | Yes | Indicates if the account is inactive |
| IsSummary | Bool | Yes | Indicates if the account is a summary account |
| OpeningBalance | Double | Yes | The opening balance of the account |
| TranDate | DateTime | Yes | The transaction date for the account |
| ExternalId | String | Yes | External identifier for the account |
| Description | String | Yes | A description of the account |
| Eliminate | Bool | Yes | Indicates if the account is used for elimination transactions |
| Inventory | Bool | Yes | Indicates if the account is used for inventory |
| Revalue | Bool | Yes | Indicates if the account should be revalued |
| AcctNumber | String | Yes | The account number |
| CurDocNum | Integer | Yes | Current document number for transactions |
| SSpecAcct | NetSuite - S Spec Acct 1.2.0 |
Yes | Special specification account type |
| Id | String | Yes | Unique identifier for the account |
| AccountSearchDisplayNameCopy | String | Yes | Copy of the account display name used in searches |
| LastModifiedDate | DateTime | Yes | The date when the account was last modified |
| AcctType | NetSuite - Acct Type 1.2.0 |
Yes | The type of the account (e.g., expense, income) |
| IncludeChildren | Bool | Yes | Indicates if child accounts are included in the parent account |
| AccountSearchDisplayName | String | Yes | Display name used in account searches |
| DisplayNameWithHierarchy | String | Yes | Display name with hierarchy information |
| ReconcileWithMatching | Bool | Yes | Indicates if the account should be reconciled with matching |
| FullName | String | Yes | Full name of the account |
| AcctName | String | Yes | The name of the account |
| RefName | String | Yes | The reference name for the account |
| Links | NetSuite - ID 1.2.0 |
Yes | Links associated with the account |
| Custrecord_sta_swe_mandatory_dept | NetSuite - ID 1.2.0 |
Yes | Mandatory department custom field |
| Subsidiary | NetSuite - ID 1.2.0 |
Yes | The subsidiary associated with the account |
| DeferralAcct | NetSuite - ID 1.2.0 |
Yes | The deferral account associated with the account |
| Location | NetSuite - ID 1.2.0 |
Yes | The location associated with the account |
| Custrecord_cb_row | NetSuite - ID 1.2.0 |
Yes | Custom field for row tracking |
| Custrecord_sta_swe_mandatory_class | NetSuite - ID 1.2.0 |
Yes | Mandatory class custom field |
| AccountContextSearch | NetSuite - ID 1.2.0 |
Yes | Context for account search |
| Localizations | NetSuite - ID 1.2.0 |
Yes | Localization settings for the account |
| Parent | NetSuite - ID 1.2.0 |
Yes | The parent account, if applicable |
| Custrecord_fam_account_showinfixedasset | NetSuite - ID 1.2.0 |
Yes | Custom field for fixed asset display |
| Custrecord_cb_alter | NetSuite - ID 1.2.0 |
Yes | Custom field for account alterations |
| BillableExpensesAcct | NetSuite - ID 1.2.0 |
Yes | Account for billable expenses |
| Department | NetSuite - ID 1.2.0 |
Yes | The department associated with the account |
| Custrecord_cb_report | NetSuite - ID 1.2.0 |
Yes | Custom field for account reporting |
| Currency | NetSuite - ID 1.2.0 |
Yes | Currency associated with the account |
| Class | NetSuite - ID 1.2.0 |
Yes | Class associated with the account |
| Category1099Misc | NetSuite - ID 1.2.0 |
Yes | Category for 1099-MISC reporting |
| NetSuite - Custom Fields | NetSuite - Custom Fields 1.2.0 |
Yes | Custom fields for the account |
NetSuite - S Spec Acct (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Id | String | No | The unique identifier for the special specification account |
| RefName | String | Yes | The reference name for the special specification account |
| NetSuite - Custom Fields | NetSuite - Custom Fields 1.2.0 |
Yes | Custom fields associated with the special specification account |
NetSuite - Custom Fields (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Key | String | Yes | The identifier for the custom field |
| Value | String | Yes | The value associated with the custom field |
NetSuite - Acct Type (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Id | String | No | The unique identifier for the account type |
| RefName | String | Yes | The reference name for the account type |
| NetSuite - Custom Fields | NetSuite - Custom Fields 1.2.0 |
Yes | Custom fields associated with the account type |
NetSuite - ID (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | Yes | The unique identifier |
Output
NetSuite - Response (ver. 1.0.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| StatusCode | Integer | No | HTTP status code returned by the NetSuite API indicating the result of the operation |
| IsError | Bool | No | Indicates whether there was an error during the operation |
| Message | String | Yes | Error or status message providing additional information |
Status Code
- 200 Success
- 400 Bad request
- 404 Not found
- 500 Server error