Transform to Vendor Return Authorization is a powerful feature that simplifies the process of managing vendor returns by converting vendor bills into vendor return authorizations. This action enhances your operational efficiency by ensuring that returns are processed accurately and swiftly, reducing the potential for errors and delays. By integrating this functionality into your workflow, you can maintain better control over inventory and financial transactions, ultimately supporting your organization's goal of streamlined operations and improved vendor relationships. Whether you're a small business or a large enterprise, this action helps you optimize your return processes and make informed decisions.
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 - Transform Vendor Bill To Vendor Return Authorization Request (ver. 1.5.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ID | String | No | Unique identifier for the vendor bill |
| VendorReturnAuthorization | NetSuite - Vendor Return Authorization v1.2.0 |
No | Reference to the associated vendor return authorization |
NetSuite - Vendor Return Authorization 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 vendor bill resource |
| TotalResults | Integer | Yes | Indicates the total number of vendor bills returned |
| Count | Integer | Yes | Represents the number of vendor bills in the current response |
| HasMore | Bool | Yes | Indicates if there are more vendor bills to retrieve |
| Offset | Integer | Yes | Specifies the starting point for the next set of vendor bills |
| Items | NetSuite - Vendor Return Authorization 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 Return Authorization Billing Address (ver. 1.1.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Zip | String | Yes | Represents the postal code for the vendor's address |
| Country | NetSuite - Country v1.4.0 |
Yes | Indicates the country of the vendor's address |
| Addr2 | String | Yes | Contains additional address information, if applicable |
| 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 | Provides further address details, if necessary |
| ExternalID | String | Yes | Unique identifier for the vendor bill in external systems |
| AddrPhone | String | Yes | Contains the phone number associated with the vendor's address |
| Addressee | String | Yes | Names the individual or entity to whom the bill is addressed |
| Attention | String | Yes | Specifies the person or department to direct the bill to |
| Override | Bool | Yes | Indicates whether to override existing settings for the vendor bill |
| State | String | Yes | Specifies the state or province for the vendor's address |
| AddrText | String | Yes | Provides a textual representation of the full address |
| RefName | String | Yes | Contains a reference name for the vendor bill |
| Links | NetSuite - Ns Link v1.1.0 |
Yes | Contains links to related records or resources in NetSuite |
| CustomFields | JSON | Yes | Holds any custom fields associated with the vendor bill |
NetSuite - Order Status (ver. 1.4.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 associated with the customer |
NetSuite - Vendor Return Authorization 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 linked to the vendor bill |
| CustomFields | JSON | Yes | Holds any custom fields related to the vendor bill |
NetSuite - Vendor Return Authorization 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 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 Return Authorization Item Inventory Detail Inventory Assignment Element v1.2.0 |
Yes | Contains the list of vendor bill items returned |
| CustomFields | JSON | Yes | Holds any additional custom fields associated with the vendor bill |
NetSuite - Vendor Return Authorization 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 related NetSuite record |
| PackCarton | String | Yes | Specifies the carton used for packing items |
| Quantity | Double | Yes | Indicates the total quantity of items billed |
| ExpirationDate | DateTime | Yes | Denotes the expiration date of the items |
| InventoryDetail | Integer | Yes | Provides details about the inventory item |
| ReceiptInventoryNumber | String | Yes | Identifies the inventory receipt number |
| InternalID | Integer | Yes | Unique identifier for the vendor bill in NetSuite |
| QuantityAvailable | Double | Yes | Shows the available quantity of the item |
| PickCarton | String | Yes | Indicates the carton designated for picking |
| RefName | String | Yes | Contains the reference name for the vendor bill |
| ToInventoryStatus | NetSuite - Ns Resource v1.6.0 |
Yes | Specifies the target inventory status for the items |
| BinNumber | NetSuite - ID v1.2.0 |
Yes | Identifies the bin location of the inventory |
| ToBinNumber | NetSuite - ID v1.2.0 |
Yes | Indicates the target bin location for the items |
| InventoryStatus | NetSuite - Ns Resource v1.6.0 |
Yes | Describes the current inventory status of the items |
| IssueInventoryNumber | NetSuite - ID v1.2.0 |
Yes | Identifies the inventory issue number |
| CustomFields | JSON | Yes | Contains additional 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