Insert or Update Vendor Bill is a powerful action that simplifies financial management by allowing you to seamlessly insert or update vendor bills within the NetSuite API. This functionality enhances your ability to manage vendor transactions efficiently, ensuring that your financial records are accurate and up-to-date. By integrating this action into your workflow, you can streamline your accounts payable processes, reduce manual data entry, and improve overall operational efficiency. Whether you are a small business or a large enterprise, this action helps you maintain precise financial oversight and supports informed decision-making.
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 - Vendor Bill Update Request (ver. 1.5.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the vendor bill |
| VendorBill | NetSuite - Vendor Bill v1.8.0 |
No | Represents the version of the vendor bill integration |
NetSuite - ID (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | Yes | The unique identifier |
NetSuite - Vendor Bill (ver. 1.8.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| StartDate | DateTime | Yes | Indicates the start date of the vendor bill transaction |
| Received | Bool | Yes | Indicates whether the vendor bill has been received |
| BillAddr1 | String | Yes | The primary billing address line for the vendor |
| BillAddr2 | String | Yes | The secondary billing address line for the vendor |
| BillAddr3 | String | Yes | Additional billing address information for the vendor |
| CreatedDate | DateTime | Yes | The date when the vendor bill was created |
| ApprovalStatus | NetSuite - Approval Status v1.4.0 |
Yes | The current approval status of the vendor bill |
| PrevDate | DateTime | Yes | The previous date associated with the vendor bill |
| CustomForm | NetSuite - Custom Form v1.4.0 |
Yes | The custom form used for the vendor bill |
| ExternalID | String | Yes | An external identifier for the vendor bill |
| ToBePrinted | Bool | Yes | Indicates if the vendor bill is pending printing |
| BillPhone | String | Yes | The phone number associated with the billing address |
| BillAttention | String | Yes | The attention line for the billing address |
| DiscountDate | DateTime | Yes | The date by which any discounts must be applied |
| ExchangeRate | Double | Yes | The exchange rate applicable to the vendor bill |
| BillZip | String | Yes | The ZIP code for the billing address |
| LandedCostMethod | NetSuite - Landed Cost Method v1.4.0 |
Yes | The method used to calculate landed costs |
| BillAddressee | String | Yes | The name of the person or entity to whom the bill is addressed |
| DueDate | DateTime | Yes | The date by which payment for the vendor bill is due |
| CreditLimit | Double | Yes | The credit limit assigned to the vendor |
| BillCity | String | Yes | The city for the billing address |
| TranDate | DateTime | Yes | The transaction date of the vendor bill |
| Memo | String | Yes | Additional notes or comments related to the vendor bill |
| BillCountry | NetSuite - Bill Country v1.4.0 |
Yes | The country associated with the billing address |
| Balance | Double | Yes | The outstanding balance on the vendor bill |
| ID | String | Yes | The unique identifier for the vendor bill |
| DocumentStatus | String | Yes | The current status of the vendor bill document |
| BillAddress | String | Yes | The complete billing address for the vendor |
| EndDate | DateTime | Yes | The end date of the vendor bill transaction |
| UserTotal | Double | Yes | The total amount calculated for the user |
| Status | NetSuite - Status v1.4.0 |
Yes | The current status of the vendor bill |
| DiscountAmount | Double | Yes | The total discount amount applicable to the vendor bill |
| BillState | String | Yes | The state for the billing address |
| BillOverride | String | Yes | Override information for the billing details |
| BillingAddress_text | String | Yes | Text representation of the billing address |
| AvailableVendorCredit | Double | Yes | The amount of vendor credit available for use |
| Total | Double | Yes | The total amount of the vendor bill |
| TranID | String | Yes | The transaction ID associated with the vendor bill |
| LastModifiedDate | DateTime | Yes | The date when the vendor bill was last modified |
| PaymentHold | Bool | Yes | Indicates if payment is currently on hold for the vendor bill |
| RefName | String | Yes | The reference name associated with the vendor bill |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Links related to the vendor bill |
| Item | NetSuite - Vendor Bill Item Collection v1.7.0 |
Yes | Collection of items associated with the vendor bill |
| Expense | NetSuite - Vendor Bill Expense Collection v1.7.0 |
Yes | Collection of expenses associated with the vendor bill |
| Location | NetSuite - ID v1.2.0 |
Yes | The location associated with the vendor bill |
| Class | NetSuite - ID v1.2.0 |
Yes | The class categorizing the vendor bill |
| BillingAddress | NetSuite - Vendor Bill Billing Address v1.5.0 |
Yes | Detailed billing address information for the vendor |
| Currency | NetSuite - ID v1.2.0 |
Yes | The currency used for the vendor bill |
| Terms | NetSuite - ID v1.2.0 |
Yes | The payment terms associated with the vendor bill |
| BillAddressList | NetSuite - Ns Resource v1.6.0 |
Yes | List of billing addresses associated with the vendor |
| AccountingBookDetail | NetSuite - Vendor Bill Accounting Book Detail Collection v1.6.0 |
Yes | Details of the accounting book for the vendor bill |
| PostingPeriod | NetSuite - ID v1.2.0 |
Yes | The accounting period for posting the vendor bill |
| Subsidiary | NetSuite - ID v1.2.0 |
Yes | The subsidiary associated with the vendor bill |
| Entity | NetSuite - ID v1.2.0 |
Yes | The entity related to the vendor bill |
| Department | NetSuite - ID v1.2.0 |
Yes | The department associated with the vendor bill |
| Account | NetSuite - ID v1.2.0 |
Yes | The account linked to the vendor bill |
| CustomFields | JSON | Yes | Custom fields associated with the vendor bill |
NetSuite - Approval Status (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the vendor in NetSuite |
| RefName | String | Yes | The reference name of the vendor used in the connector |
| CustomFields | JSON | Yes | Additional custom attributes related to the vendor |
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 - Landed Cost Method (ver. 1.4.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the vendor in NetSuite |
| RefName | String | Yes | The reference name of the vendor used in the connector |
| CustomFields | JSON | Yes | Additional custom fields related to the vendor 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 - Status (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 data related to the credit memo |
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 - Vendor Bill Billing Address (ver. 1.5.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Zip | String | Yes | Represents the postal code of the vendor's address |
| Country | NetSuite - Country v1.4.0 |
Yes | Indicates the country where the vendor is located |
| Addr2 | String | Yes | Provides additional address information for the vendor |
| City | String | Yes | Specifies the city of the vendor's address |
| Addr1 | String | Yes | Contains the primary address line for the vendor |
| LastModifiedDate | DateTime | Yes | Records the last date and time the vendor information was modified |
| Addr3 | String | Yes | Offers further address details for the vendor |
| ExternalID | String | Yes | Serves as a unique identifier for the vendor in external systems |
| AddrPhone | String | Yes | Lists the phone number associated with the vendor's address |
| Addressee | String | Yes | Identifies the name of the person or entity to contact at the vendor |
| Attention | String | Yes | Specifies the name of the person to whom correspondence should be directed |
| Override | Bool | Yes | Indicates whether to override existing vendor information |
| State | String | Yes | Denotes the state or province of the vendor's address |
| AddrText | String | Yes | Provides a formatted text representation of the vendor's address |
| RefName | String | Yes | Contains a reference name for the vendor, useful for identification |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Contains links to related resources or information about the vendor |
| CustomFields | JSON | Yes | Holds additional custom data fields specific to the vendor |
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 Bill Accounting Book Detail Collection (ver. 1.6.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Provides a link to the NetSuite API for vendor data access |
| TotalResults | Integer | Yes | Indicates the total number of vendor records retrieved |
| Count | Integer | Yes | Represents the number of vendor records in the current response |
| HasMore | Bool | Yes | Indicates if there are more vendor records available for retrieval |
| Offset | Integer | Yes | Specifies the starting point for the next set of vendor records |
| Items | NetSuite - Vendor Bill Accounting Book Detail Element v1.4.0 |
Yes | Contains the detailed vendor records retrieved from NetSuite |
| CustomFields | JSON | Yes | Holds any additional custom fields associated with the vendor records |
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 Bill Accounting Book Detail Element (ver. 1.4.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 | Indicates the currency exchange rate for transactions |
| RefName | String | Yes | Provides a reference name for the vendor entry |
| AccountingBook | NetSuite - Ns Resource v1.6.0 |
Yes | Links to the accounting book associated with the vendor |
| Subsidiary | NetSuite - ID v1.2.0 |
Yes | Identifies the subsidiary to which the vendor belongs |
| CustomFields | JSON | Yes | Contains additional custom fields related to the vendor |
NetSuite - Item Receipt Collection (ver. 1.2.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| TotalResults | Integer | Yes | Indicates the total number of vendor records available in the response |
| Items | NetSuite - ID v1.2.0 |
Yes | Contains the list of vendor records retrieved from NetSuite |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Provides links to related resources or actions for the vendor records |
| Count | Integer | Yes | Represents the number of vendor records returned in the current response |
| HasMore | Bool | Yes | Indicates whether there are more vendor records available beyond the current response |
| Offset | Integer | Yes | Specifies the starting point for the next set of vendor records to retrieve |
| CustomFields | JSON | Yes | Contains any additional custom fields associated with the vendor records |
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 Bill 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 NetSuite vendor data source |
| TotalResults | Integer | Yes | Indicates the total number of vendor records retrieved |
| Count | Integer | Yes | Represents the number of vendor records in the current response |
| HasMore | Bool | Yes | Indicates whether there are more vendor records available |
| Offset | Integer | Yes | Specifies the starting point for the next set of vendor records |
| Items | NetSuite - Vendor Bill Item Inventory Detail Inventory Assignment Element v1.2.0 |
Yes | Contains the detailed list of vendor records retrieved |
| CustomFields | JSON | Yes | Holds any additional custom field data associated with the vendors |
NetSuite - Vendor Bill 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 connection to the NetSuite vendor record |
| PackCarton | String | Yes | Specifies the carton packaging details for the vendor |
| Quantity | Double | Yes | Indicates the quantity of items associated with the vendor |
| ExpirationDate | DateTime | Yes | Defines the expiration date for the vendor's inventory |
| InventoryDetail | Integer | Yes | Provides detailed inventory information for the vendor |
| ReceiptInventoryNumber | String | Yes | Contains the inventory receipt number for tracking |
| InternalID | Integer | Yes | Unique identifier for the vendor within NetSuite |
| QuantityAvailable | Double | Yes | Shows the available quantity of items from the vendor |
| PickCarton | String | Yes | Identifies the carton designated for picking items |
| RefName | String | Yes | Holds a reference name for the vendor for easy identification |
| ToInventoryStatus | NetSuite - Ns Resource v1.6.0 |
Yes | Indicates the target inventory status for the vendor's items |
| InventoryStatus | NetSuite - Ns Resource v1.6.0 |
Yes | Represents the current inventory status of the vendor's items |
| ToBinNumber | NetSuite - ID v1.2.0 |
Yes | Specifies the target bin number for inventory placement |
| IssueInventoryNumber | NetSuite - ID v1.2.0 |
Yes | Contains the inventory issue number for tracking purposes |
| BinNumber | NetSuite - ID v1.2.0 |
Yes | Identifies the bin number where the vendor's items are stored |
| CustomFields | JSON | Yes | Stores additional custom fields related to the vendor |
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