Insert or Update Journal Entry is a powerful action that simplifies financial record-keeping by allowing you to seamlessly insert or update journal entries within the NetSuite API. This functionality enhances your ability to manage financial data accurately and efficiently, ensuring that your accounting records are always up to date. By integrating this action into your workflows, you can streamline your financial operations, improve data accuracy, and support informed decision-making. Whether you're a small business or a large enterprise, this action helps you maintain precise financial documentation, ultimately contributing to better financial management and reporting.
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 - Journal Entry Update Request (ver. 1.3.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the journal entry |
| JournalEntry | NetSuite - Journal Entry v1.9.0 |
No | Represents the version of the journal entry in the NetSuite connector |
NetSuite - Journal Entry (ver. 1.9.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| TranDate | DateTime | Yes | Represents the date of the transaction |
| Memo | String | Yes | Contains additional information about the journal entry |
| Approved | Bool | Yes | Indicates whether the journal entry is approved |
| ID | String | Yes | Unique identifier for the journal entry |
| CreatedDate | DateTime | Yes | Date when the journal entry was created |
| ReversalDefer | Bool | Yes | Specifies if the reversal is deferred |
| IsReversal | Bool | Yes | Indicates if the journal entry is a reversal |
| CustomForm | NetSuite - Custom Form v1.4.0 |
Yes | Refers to the custom form used for the journal entry |
| ReversalDate | DateTime | Yes | Date when the reversal is processed |
| ExternalID | String | Yes | External identifier for the journal entry |
| Void | Bool | Yes | Indicates if the journal entry is voided |
| ExchangeRate | Double | Yes | The exchange rate applied to the transaction |
| TranID | String | Yes | Identifier for the transaction |
| LastModifiedDate | DateTime | Yes | Date when the journal entry was last modified |
| RefName | String | Yes | Reference name associated with the journal entry |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Contains links related to the journal entry |
| AccountingBook | NetSuite - Ns Resource v1.6.0 |
Yes | Refers to the accounting book associated with the entry |
| AccountingBookDetail | NetSuite - Journal Entry Accounting Book Detail Collection v1.2.0 |
Yes | Details of the accounting book for the journal entry |
| PostingPeriod | NetSuite - ID v1.2.0 |
Yes | The posting period for the journal entry |
| Subsidiary | NetSuite - ID v1.2.0 |
Yes | Identifies the subsidiary associated with the journal entry |
| Department | NetSuite - ID v1.2.0 |
Yes | Department linked to the journal entry |
| Currency | NetSuite - ID v1.2.0 |
Yes | Currency used for the journal entry |
| Line | NetSuite - Journal Entry Line Collection v1.2.0 |
Yes | Contains line items for the journal entry |
| CreatedFrom | NetSuite - Ns Resource v1.6.0 |
Yes | Refers to the source from which the journal entry was created |
| ParentExpenseAlloc | NetSuite - Ns Resource v1.6.0 |
Yes | Links to the parent expense allocation |
| Class | NetSuite - ID v1.2.0 |
Yes | Class associated with the journal entry |
| Location | NetSuite - ID v1.2.0 |
Yes | Location related to the journal entry |
| CustomFields | JSON | Yes | Contains custom fields for additional data |
NetSuite - ID (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | Yes | The unique identifier |
NetSuite - Custom Form (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the contact in NetSuite |
| RefName | String | Yes | Display name of the contact used for reference |
| CustomFields | JSON | Yes | Additional user-defined fields for the contact |
NetSuite - Ns Link (ver. 1.1.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Rel | String | Yes | Represents the relationship identifier for the Netsuite account |
| Href | String | Yes | Contains the URL link to access the Netsuite account |
| CustomFields | JSON | Yes | Holds additional custom field data specific to the Netsuite account |
NetSuite - Ns Resource (ver. 1.6.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the Netsuite account |
| RefName | String | Yes | User-friendly name for the Netsuite account |
| ExternalID | String | Yes | Identifier used for external references to the account |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Links to related resources or entities in Netsuite |
| CustomFields | JSON | Yes | Additional custom attributes specific to the Netsuite account |
NetSuite - Journal Entry Accounting Book Detail Collection (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Provides a link to the NetSuite API for further details |
| TotalResults | Integer | Yes | Indicates the total number of journal entries available |
| Count | Integer | Yes | Represents the number of journal entries returned in the response |
| HasMore | Bool | Yes | Indicates if there are more journal entries to fetch |
| Offset | Integer | Yes | Specifies the starting point for the next set of journal entries |
| Items | NetSuite - Journal Entry Accounting Book Detail Element v1.2.0 |
Yes | Contains the list of journal entries retrieved from NetSuite |
| CustomFields | JSON | Yes | Holds any additional custom fields associated with the journal entries |
NetSuite - Journal Entry Accounting Book Detail Element (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Represents the connection to the NetSuite instance |
| ExchangeRate | Double | Yes | Specifies the exchange rate for the journal entry |
| RefName | String | Yes | Contains the reference name for the journal entry |
| AccountingBook | NetSuite - Ns Resource v1.6.0 |
Yes | Identifies the accounting book associated with the entry |
| Subsidiary | NetSuite - ID v1.2.0 |
Yes | Indicates the subsidiary related to the journal entry |
| CustomFields | JSON | Yes | Holds any custom fields defined for the journal entry |
NetSuite - Schedule Type (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the journal entry |
| RefName | String | Yes | Reference name for the journal entry |
| CustomFields | JSON | Yes | Additional custom fields related to the journal entry |
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