Insert or Update Account is a powerful feature that simplifies account management within the NetSuite environment. By allowing you to seamlessly insert or update account information through the NetSuite API, this action enhances your ability to maintain accurate and up-to-date records. It supports efficient data management and ensures that your organization can respond quickly to changes in account details. Whether you are a small business or a large enterprise, this functionality helps you streamline your operations, improve data integrity, and make informed decisions with confidence.
Configuration
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.
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.
Input & Output Schema
Input
NetSuite - Account Update Request (ver. 1.6.0)
Column
Data type
Allow null
Description
ID
String
No
Unique identifier for the NetSuite account
Account
NetSuite - Account v1.6.0
No
Represents the version of the NetSuite account connector
NetSuite - Account (ver. 1.6.0)
Column
Data type
Allow null
Description
IsInactive
Bool
Yes
Indicates if the account is inactive
IsSummary
Bool
Yes
Specifies if the account is a summary account
OpeningBalance
Double
Yes
Represents the initial balance of the account
TranDate
DateTime
Yes
The date of the transaction associated with the account
ExternalID
String
Yes
Unique identifier for the account in external systems
Description
String
Yes
Provides a brief description of the account
Eliminate
Bool
Yes
Indicates if the account should be eliminated in reports
Inventory
Bool
Yes
Specifies if the account is used for inventory purposes
Revalue
Bool
Yes
Indicates if the account is subject to revaluation
AcctNumber
String
Yes
The account number assigned to the account
CurDocNum
Integer
Yes
Current document number for the account
SSpecAcct
NetSuite - S Spec Acct v1.4.0
Yes
Represents a specific account type in NetSuite
ID
String
Yes
Unique identifier for the account in NetSuite
AccountSearchDisplayNameCopy
String
Yes
Copy of the display name used in account searches
LastModifiedDate
DateTime
Yes
The date and time when the account was last modified
AcctType
NetSuite - Acct Type v1.4.0
Yes
Specifies the type of account in NetSuite
IncludeChildren
Bool
Yes
Indicates if child accounts should be included
AccountSearchDisplayName
String
Yes
The display name used for account searches
DisplayNameWithHierarchy
String
Yes
The display name of the account including its hierarchy
ReconcileWithMatching
Bool
Yes
Indicates if the account can be reconciled with matching transactions
FullName
String
Yes
The full name of the account as displayed in NetSuite
