Insert or Update Vendor Credit is a powerful action that simplifies the management of vendor credits within your NetSuite environment. By seamlessly integrating with the NetSuite API, this action allows you to efficiently insert new vendor credits or update existing ones, ensuring your financial records are always accurate and up-to-date. This functionality enhances your ability to manage vendor relationships and streamline your accounting processes, making it an essential tool for businesses of all sizes looking to improve their financial operations and maintain precise vendor records.
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 - Vendor Credit Update Request (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the vendor credit record |
| VendorCredit | NetSuite - Vendor Credit v1.3.0 |
No | Represents the version of the vendor credit integration |
NetSuite - ID (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | Yes | The unique identifier |
NetSuite - Vendor Credit (ver. 1.3.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Unapplied | Double | Yes | Represents the amount that has not been applied to any invoice or payment |
| TranDate | DateTime | Yes | Indicates the transaction date of the vendor bill |
| Memo | String | Yes | Contains additional notes or comments related to the vendor bill |
| BillCountry | NetSuite - Bill Country v1.4.0 |
Yes | Specifies the country for billing purposes |
| ID | String | Yes | Unique identifier for the vendor bill |
| BillAddress | String | Yes | Full billing address for the vendor |
| BillAddr1 | String | Yes | First line of the billing address |
| BillAddr2 | String | Yes | Second line of the billing address |
| BillAddr3 | String | Yes | Third line of the billing address, if applicable |
| UserTotal | Double | Yes | Total amount calculated by the user for the bill |
| CreatedDate | DateTime | Yes | Date when the vendor bill was created |
| BillState | String | Yes | State associated with the billing address |
| PrevDate | DateTime | Yes | Date of the previous transaction related to the bill |
| CustomForm | NetSuite - Custom Form v1.4.0 |
Yes | Indicates the custom form used for the vendor bill |
| ExternalID | String | Yes | External identifier for integration purposes |
| ToBePrinted | Bool | Yes | Indicates whether the bill is marked for printing |
| BillPhone | String | Yes | Phone number associated with the billing address |
| BillOverride | String | Yes | Overrides for billing details, if any |
| BillAttention | String | Yes | Name of the person to whom the bill is addressed |
| BillingAddress_text | String | Yes | Text representation of the billing address |
| Applied | Double | Yes | Total amount that has been applied to invoices or payments |
| ExchangeRate | Double | Yes | Exchange rate used for currency conversion |
| BillZip | String | Yes | ZIP code for the billing address |
| Total | Double | Yes | Total amount of the vendor bill |
| TranID | String | Yes | Unique transaction ID for the vendor bill |
| LastModifiedDate | DateTime | Yes | Date when the vendor bill was last modified |
| BillAddressee | String | Yes | Name of the individual or entity receiving the bill |
| DueDate | DateTime | Yes | Date by which the payment for the bill is due |
| BillCity | String | Yes | City associated with the billing address |
| RefName | String | Yes | Reference name for tracking purposes |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Links to related records or documents |
| BillAddressList | NetSuite - Ns Resource v1.6.0 |
Yes | List of billing addresses associated with the vendor |
| Department | NetSuite - ID v1.2.0 |
Yes | Department responsible for the vendor bill |
| Apply | NetSuite - Vendor Credit Apply Collection v1.2.0 |
Yes | Collection of vendor credits applied to the bill |
| CreatedFrom | NetSuite - Ns Resource v1.6.0 |
Yes | Indicates the source transaction from which the bill was created |
| BillingAddress | NetSuite - Vendor Credit Billing Address v1.1.0 |
Yes | Billing address details for vendor credit |
| PostingPeriod | NetSuite - ID v1.2.0 |
Yes | Accounting period in which the bill is posted |
| Account | NetSuite - ID v1.2.0 |
Yes | Account associated with the vendor bill |
| Entity | NetSuite - ID v1.2.0 |
Yes | Entity related to the vendor bill |
| Currency | NetSuite - ID v1.2.0 |
Yes | Currency in which the bill is denominated |
| Class | NetSuite - ID v1.2.0 |
Yes | Class categorizing the vendor bill |
| Item | NetSuite - Vendor Credit Item Collection v1.2.0 |
Yes | Collection of items associated with the vendor bill |
| Location | NetSuite - ID v1.2.0 |
Yes | Location related to the vendor bill |
| Expense | NetSuite - Vendor Credit Expense Collection v1.2.0 |
Yes | Collection of expenses associated with the vendor bill |
| Subsidiary | NetSuite - ID v1.2.0 |
Yes | Subsidiary associated with the vendor bill |
| AccountingBookDetail | NetSuite - Vendor Credit Accounting Book Detail Collection v1.2.0 |
Yes | Details of the accounting book entries for the vendor bill |
| CustomFields | JSON | Yes | Custom fields for additional vendor bill information |
NetSuite - Bill Country (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the credit memo |
| RefName | String | Yes | Reference name for the credit memo |
| CustomFields | JSON | Yes | Additional custom fields related to the credit memo |
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 - Vendor Credit Apply 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 vendor bill record |
| TotalResults | Integer | Yes | Indicates the total number of vendor bills retrieved |
| Count | Integer | Yes | Represents the number of vendor bills in the current response |
| HasMore | Bool | Yes | Indicates if there are more vendor bills to fetch |
| Offset | Integer | Yes | Specifies the starting point for the next set of vendor bills |
| Items | NetSuite - Vendor Credit Apply Element v1.2.0 |
Yes | Contains the list of vendor bills returned in the response |
| CustomFields | JSON | Yes | Holds any additional custom fields associated with the vendor bill |
NetSuite - Vendor Credit Billing Address (ver. 1.1.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Zip | String | Yes | Represents the postal code for the vendor bill |
| Country | NetSuite - Country v1.4.0 |
Yes | Indicates the country associated with the vendor |
| Addr2 | String | Yes | Contains additional address information for the vendor |
| City | String | Yes | Specifies the city for the vendor's address |
| Addr1 | String | Yes | Provides the primary address line for the vendor |
| LastModifiedDate | DateTime | Yes | Records the last date and time the vendor bill was modified |
| Addr3 | String | Yes | Includes any further address details for the vendor |
| ExternalID | String | Yes | Serves as a unique identifier for the vendor bill in external systems |
| AddrPhone | String | Yes | Contains the phone number associated with the vendor |
| Addressee | String | Yes | Identifies the person or entity to whom the bill is addressed |
| Attention | String | Yes | Specifies the individual to whom the bill should be directed |
| Override | Bool | Yes | Indicates whether to override default settings for the vendor bill |
| State | String | Yes | Denotes the state or province for the vendor's address |
| AddrText | String | Yes | Provides a formatted text representation of the vendor's address |
| RefName | String | Yes | Represents a reference name for the vendor bill |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Contains links related to the vendor bill for easy navigation |
| CustomFields | JSON | Yes | Holds any custom fields associated with the vendor bill |
NetSuite - Vendor Credit 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 the vendor bill data |
| TotalResults | Integer | Yes | Indicates the total number of vendor bills returned in the response |
| Count | Integer | Yes | Represents the number of vendor bills in the current response |
| HasMore | Bool | Yes | Indicates whether there are more vendor bills available for retrieval |
| Offset | Integer | Yes | Specifies the starting point for the next set of vendor bills |
| Items | NetSuite - Vendor Credit Accounting Book Detail Element v1.2.0 |
Yes | Contains the details of each vendor bill retrieved |
| CustomFields | JSON | Yes | Holds any additional custom fields associated with the vendor bills |
NetSuite - Vendor Credit Apply Element (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Represents the link to the related NetSuite record |
| Total | Double | Yes | Indicates the total amount of the vendor bill |
| Amount | Double | Yes | Specifies the amount to be applied to the bill |
| ApplyDate | DateTime | Yes | Denotes the date when the bill is applied |
| RefNum | String | Yes | Contains the reference number for the vendor bill |
| Apply | Bool | Yes | Indicates whether the bill is to be applied |
| Due | Double | Yes | Represents the amount due for the vendor bill |
| Line | Integer | Yes | Specifies the line number of the bill entry |
| CreatedFrom | String | Yes | Identifies the source document from which the bill was created |
| Currency | String | Yes | Indicates the currency used for the vendor bill |
| Type | String | Yes | Specifies the type of the vendor bill |
| RefName | String | Yes | Contains the name associated with the reference number |
| Doc | NetSuite - Ns Resource v1.6.0 |
Yes | Represents the document related to the vendor bill |
| CustomFields | JSON | Yes | Contains any custom fields associated with the vendor bill |
NetSuite - Country (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the credit memo |
| RefName | String | Yes | Reference name for the credit memo |
| CustomFields | JSON | Yes | Additional custom fields related to the credit memo |
NetSuite - Vendor Credit Accounting Book Detail Element (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Represents the link to the vendor bill in NetSuite |
| ExchangeRate | Double | Yes | Indicates the exchange rate applied to the transaction |
| RefName | String | Yes | Contains the reference name for the vendor bill |
| Subsidiary | NetSuite - ID v1.2.0 |
Yes | Identifies the subsidiary associated with the vendor bill |
| AccountingBook | NetSuite - Ns Resource v1.6.0 |
Yes | Specifies the accounting book used for the transaction |
| CustomFields | JSON | Yes | Holds any custom fields related to the vendor bill |
NetSuite - Item Type (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the credit memo |
| RefName | String | Yes | Reference name for the credit memo |
| CustomFields | JSON | Yes | Additional custom fields related to the credit memo |
NetSuite - Bill Variance Status (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the customer in NetSuite |
| RefName | String | Yes | Display name of the customer used in the connector |
| CustomFields | JSON | Yes | Additional custom attributes related to the customer |
NetSuite - Item Subtype (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the credit memo |
| RefName | String | Yes | Reference name for the credit memo |
| CustomFields | JSON | Yes | Additional custom fields related to the credit memo |
NetSuite - Vendor Credit Item Inventory Detail Inventory Assignment Collection (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Provides a link to the specific NetSuite vendor bill record |
| TotalResults | Integer | Yes | Indicates the total number of vendor bills returned in the response |
| Count | Integer | Yes | Represents the number of vendor bills in the current response |
| HasMore | Bool | Yes | Indicates whether there are more vendor bills available for retrieval |
| Offset | Integer | Yes | Specifies the starting point for the next set of vendor bills |
| Items | NetSuite - Vendor Credit Item Inventory Detail Inventory Assignment Element v1.2.0 |
Yes | Contains the details of individual items associated with the vendor bill |
| CustomFields | JSON | Yes | Holds any custom fields related to the vendor bill for additional data |
NetSuite - Vendor Credit Item Inventory Detail Inventory Assignment Element (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Represents the link to the associated NetSuite record |
| PackCarton | String | Yes | Indicates the carton number for packing items |
| Quantity | Double | Yes | Specifies the total quantity of items in the bill |
| ExpirationDate | DateTime | Yes | Denotes the expiration date of the items billed |
| InventoryDetail | Integer | Yes | Provides details about the inventory associated with the bill |
| ReceiptInventoryNumber | String | Yes | Contains the inventory receipt number for tracking |
| InternalID | Integer | Yes | Unique identifier for the vendor bill in NetSuite |
| QuantityAvailable | Double | Yes | Shows the quantity of items available for this bill |
| PickCarton | String | Yes | Identifies the carton designated for picking items |
| RefName | String | Yes | Represents a reference name for the vendor bill |
| ToBinNumber | NetSuite - ID v1.2.0 |
Yes | Indicates the bin number where items are stored |
| IssueInventoryNumber | NetSuite - ID v1.2.0 |
Yes | Refers to the inventory issue number related to the bill |
| ToInventoryStatus | NetSuite - Ns Resource v1.6.0 |
Yes | Specifies the inventory status for the items billed |
| InventoryStatus | NetSuite - Ns Resource v1.6.0 |
Yes | Indicates the current status of the inventory items |
| BinNumber | NetSuite - ID v1.2.0 |
Yes | Represents the bin number associated with the vendor bill |
| CustomFields | JSON | Yes | Contains any custom fields related to the vendor bill |
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