Transform to Sales Order is a powerful feature that simplifies the process of converting customer information into actionable sales orders within the NetSuite environment. By seamlessly integrating customer data with sales order creation, this action enhances your workflow efficiency and reduces manual entry errors. It allows you to quickly respond to customer needs, ensuring that you can fulfill orders promptly and accurately. Whether you're a small business or a large enterprise, this functionality helps you streamline your sales processes, improve customer satisfaction, and drive revenue growth.
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 Customer To Sales Order Request (ver. 1.7.0)
Column
Data type
Allow null
Description
ID
String
No
Unique identifier for the customer in NetSuite
SalesOrder
NetSuite - Sales Order v1.5.0
No
Reference to the associated sales order in NetSuite
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 - 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 - Source (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 - Payment Operation (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 associated with the customer
NetSuite - Sales Order Accounting Book Detail Collection (ver. 1.5.0)
Column
Data type
Allow null
Description
Links
NetSuite - Ns Link v1.1.0
Yes
Provides a link to the NetSuite API for accessing customer data
TotalResults
Integer
Yes
Indicates the total number of customer records retrieved
Count
Integer
Yes
Represents the number of customer records in the current response
HasMore
Bool
Yes
Indicates if there are more customer records available for retrieval
Offset
Integer
Yes
Specifies the starting point for the next set of customer records
Items
NetSuite - Sales Order Accounting Book Detail Element v1.3.0
Yes
Contains the list of customer records retrieved from NetSuite
CustomFields
JSON
Yes
Holds additional custom field data associated with the customer records
NetSuite - Sales Order Shipping Address (ver. 1.4.0)
Column
Data type
Allow null
Description
Zip
String
Yes
Represents the postal code of the customer location
Country
NetSuite - Country v1.4.0
Yes
Indicates the country where the customer is located
Addr2
String
Yes
Additional address line for the customer
City
String
Yes
Specifies the city of the customer's address
Addr1
String
Yes
Primary address line for the customer
LastModifiedDate
DateTime
Yes
Records the last date and time the customer information was modified
Addr3
String
Yes
Optional third address line for the customer
ExternalID
String
Yes
Unique identifier for the customer in external systems
AddrPhone
String
Yes
Phone number associated with the customer's address
Addressee
String
Yes
Name of the person or entity to whom the address belongs
Attention
String
Yes
Additional attention information for the customer
Override
Bool
Yes
Indicates whether to override existing customer data
State
String
Yes
Specifies the state or province of the customer's address
AddrText
String
Yes
Full address text representation of the customer
RefName
String
Yes
Reference name for the customer, often used for identification
Links
NetSuite - Ns Link v1.1.0
Yes
Contains links to related resources or records in NetSuite
CustomFields
JSON
Yes
Stores custom field data specific to the customer
NetSuite - Sales Order Ship Group Collection (ver. 1.4.0)
Column
Data type
Allow null
Description
Links
NetSuite - Ns Link v1.1.0
Yes
Provides a link to the NetSuite API for data retrieval
TotalResults
Integer
Yes
Indicates the total number of results returned by the query
Count
Integer
Yes
Represents the number of items in the current response
HasMore
Bool
Yes
Indicates whether there are more results available beyond the current response
Offset
Integer
Yes
Specifies the starting point for the next set of results
Items
NetSuite - Sales Order Ship Group Element v1.2.0
Yes
Contains the list of sales order ship groups retrieved from NetSuite
CustomFields
JSON
Yes
Holds any additional custom fields associated with the customer data
NetSuite - Sales Order Gift Cert Redemption Collection (ver. 1.5.0)
Column
Data type
Allow null
Description
Links
NetSuite - Ns Link v1.1.0
Yes
Provides the link to the NetSuite instance for API calls
TotalResults
Integer
Yes
Indicates the total number of results returned by the query
Count
Integer
Yes
Represents the number of items in the current response
HasMore
Bool
Yes
Indicates whether there are more results available to fetch
Offset
Integer
Yes
Specifies the starting point for the next set of results
Items
NetSuite - Sales Order Gift Cert Redemption Element v1.3.0
Yes
Contains the list of items retrieved from the NetSuite API
CustomFields
JSON
Yes
Holds any additional custom fields associated with the customer
NetSuite - Sales Order Billing Address (ver. 1.4.0)
Column
Data type
Allow null
Description
Zip
String
Yes
Represents the postal code of the customer address
Country
NetSuite - Country v1.4.0
Yes
Indicates the country of the customer
Addr2
String
Yes
Contains additional address information
City
String
Yes
Specifies the city of the customer address
Addr1
String
Yes
Contains the primary address line for the customer
LastModifiedDate
DateTime
Yes
Records the last date and time the customer information was modified
Addr3
String
Yes
Provides further address details if needed
ExternalID
String
Yes
Unique identifier for the customer in external systems
AddrPhone
String
Yes
Contains the phone number associated with the customer address
Addressee
String
Yes
Specifies the name of the person or entity receiving the address
Attention
String
Yes
Indicates any specific attention required for the address
Override
Bool
Yes
Determines if the existing address should be overridden
State
String
Yes
Specifies the state or region of the customer address
AddrText
String
Yes
Provides a full text representation of the address
RefName
String
Yes
Contains a reference name for the customer
Links
NetSuite - Ns Link v1.1.0
Yes
Contains links to related resources in NetSuite
CustomFields
JSON
Yes
Holds any custom fields associated with the customer
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 - 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 - Sales Order Accounting Book Detail Element (ver. 1.3.0)
Column
Data type
Allow null
Description
Links
NetSuite - Ns Link v1.1.0
Yes
Represents the connection link to the NetSuite instance
ExchangeRate
Double
Yes
Indicates the currency exchange rate for transactions
RefName
String
Yes
Contains the reference name for the customer record
Subsidiary
NetSuite - ID v1.2.0
Yes
Identifies the subsidiary associated with the customer
AccountingBook
NetSuite - Ns Resource v1.6.0
Yes
Specifies the accounting book linked to the customer
CustomFields
JSON
Yes
Holds any custom fields related to the customer record
NetSuite - Sales Order Ship Group 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
ShippingRate
Double
Yes
Indicates the cost of shipping for the order
UniqueKey
Integer
Yes
Serves as a unique identifier for the customer record
SourceAddress
String
Yes
Contains the address from which the shipment originates
Weight
Double
Yes
Specifies the total weight of the shipment
HandlingRate
Double
Yes
Represents the cost associated with handling the shipment
ID
Integer
Yes
Unique identifier for the customer in the system
DestinationAddress
String
Yes
Contains the address where the shipment is to be delivered
ShippingMethod
String
Yes
Describes the method of shipping selected for the order
RefName
String
Yes
Provides a reference name for the customer record
CustomFields
JSON
Yes
Holds additional custom data related to the customer
NetSuite - Sales Order Gift Cert Redemption Element (ver. 1.3.0)
Column
Data type
Allow null
Description
Links
NetSuite - Ns Link v1.1.0
Yes
Represents the connection link to the NetSuite instance
AuthCodeApplied
Double
Yes
Indicates whether an authorization code has been applied
RefName
String
Yes
Contains a reference name for the customer record
AuthCode
NetSuite - Ns Resource v1.6.0
Yes
Holds the authorization code for accessing NetSuite resources
CustomFields
JSON
Yes
Stores additional custom fields related to the customer
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 - 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 - Cost Estimate Type (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 - Ship Carrier (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 - Create Po (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 for reference
CustomFields
JSON
Yes
Additional custom attributes related to the customer
NetSuite - Commit Inventory (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 for reference
CustomFields
JSON
Yes
Additional custom attributes related to the customer
