Transform to Vendor Payment is a powerful action that simplifies the process of converting vendor bills into vendor payments within the NetSuite platform. By seamlessly integrating financial operations, this action helps you manage your accounts payable more efficiently. It ensures that your payment processes are streamlined, reducing the time and effort required to handle vendor transactions. With this functionality, you can maintain accurate financial records and improve cash flow management, making it an essential tool for businesses of all sizes looking to enhance their financial operations and maintain strong vendor relationships.
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 - Transform Vendor Bill To Vendor Payment Request (ver. 1.5.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the vendor bill |
| VendorPayment | NetSuite - Vendor Payment v1.8.0 |
No | Reference to the associated vendor payment transaction |
NetSuite - Vendor Payment Payee Address (ver. 1.5.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 | Provides additional address information for the vendor |
| City | String | Yes | Specifies the city for 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 bill was modified |
| Addr3 | String | Yes | Offers further address details for the vendor |
| ExternalID | String | Yes | Serves as a unique identifier for the vendor bill in external systems |
| AddrPhone | String | Yes | Lists the contact phone number for the vendor |
| Addressee | String | Yes | Identifies the person or entity to whom the bill is addressed |
| Attention | String | Yes | Indicates the specific person or department to receive the bill |
| Override | Bool | Yes | Determines whether to override existing 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 | Contains a reference name for the vendor bill |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Holds related links for the vendor bill in NetSuite |
| CustomFields | JSON | Yes | Stores additional custom field data related to the vendor bill |
NetSuite - Vendor Payment Apply Collection (ver. 1.6.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Provides a unique identifier for the 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 available for retrieval |
| Offset | Integer | Yes | Specifies the starting point for the next set of vendor bills |
| Items | NetSuite - Vendor Payment 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 Payment 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 vendor bill resource |
| 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 available for retrieval |
| Offset | Integer | Yes | Specifies the starting point for the next set of vendor bills |
| Items | NetSuite - Vendor Payment 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 Payment Credit 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 vendor bill resource |
| 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 Payment Credit 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 bills |
NetSuite - Vendor Payment 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 vendor bill in NetSuite |
| DiscDate | DateTime | Yes | Indicates the discount date applicable to the bill |
| Amount | Double | Yes | Total amount of the vendor bill before discounts |
| Apply | Bool | Yes | Indicates whether the bill is applied to a payment |
| Line | Integer | Yes | Represents the line number of the bill entry |
| CreatedFrom | String | Yes | Identifies the source document from which the bill was created |
| Type | String | Yes | Specifies the type of the vendor bill |
| DiscAmt | Double | Yes | Amount of discount applied to the vendor bill |
| Total | Double | Yes | Final total amount of the vendor bill after discounts |
| ApplyDate | DateTime | Yes | Date when the bill is applied to a payment |
| RefNum | String | Yes | Reference number associated with the vendor bill |
| Due | Double | Yes | Amount due for the vendor bill |
| Currency | String | Yes | Currency in which the vendor bill is denominated |
| Disc | Double | Yes | Total discount amount applicable to the bill |
| RefName | String | Yes | Name associated with the reference number of the bill |
| Doc | NetSuite - Ns Resource v1.6.0 |
Yes | Represents the document resource related to the vendor bill |
| CustomFields | JSON | Yes | Contains any custom fields associated with the vendor bill |
NetSuite - Vendor Payment 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 |
| AccountingBook | NetSuite - Ns Resource v1.6.0 |
Yes | Specifies the accounting book associated with the bill |
| Subsidiary | NetSuite - ID v1.2.0 |
Yes | Identifies the subsidiary related to the vendor bill |
| CustomFields | JSON | Yes | Holds any custom fields defined for the vendor bill |
NetSuite - Vendor Payment Credit 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 |
| Amount | Double | Yes | Indicates the amount of the vendor bill |
| Total | Double | Yes | Represents the total amount due for the vendor bill |
| CreditDate | DateTime | Yes | Specifies the date when the credit is applied |
| RefNum | String | Yes | Contains the reference number for the vendor bill |
| Apply | Bool | Yes | Indicates whether the bill is applied to a payment |
| Due | Double | Yes | Represents the amount that is due for payment |
| CreatedFrom | String | Yes | Identifies the source document from which the bill was created |
| Line | Integer | Yes | Specifies the line number of the item on the bill |
| AppliedTo | String | Yes | Indicates the record to which the bill is applied |
| Currency | String | Yes | Specifies the currency used for the transaction |
| Type | String | Yes | Indicates 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 linked resource document in NetSuite |
| CustomFields | JSON | Yes | Contains any custom fields associated with 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