Setting

Description

Values / Defaults

Dependencies / Effects

Account ID

The NetSuite account ID for API access. This identifies your NetSuite instance.

Required string.

Required for all API communication. Value is trimmed.

Consumer Key

The consumer key obtained from NetSuite for OAuth authentication.

Required string.

Required for all API communication. This value is encrypted.

Consumer Secret

The consumer secret obtained from NetSuite for OAuth authentication.

Required string.

Required for all API communication. This value is encrypted.

Token Key

The token ID obtained from NetSuite for OAuth authentication.

Required string.

Required for all API communication. This value is encrypted.

Token Secret

The token secret obtained from NetSuite for OAuth authentication.

Required string.

Required for all API communication. This value is encrypted.

Name of base price level

Specifies the name of the price level in NetSuite that contains the base prices for items.

String. No default.

Influences how item base prices are retrieved from NetSuite.

Name of role for primary contacts

Defines the role name in NetSuite used to identify primary contacts for customers.

String. No default.

Determines which contact is considered primary during customer synchronization.

Use item department as item category

If enabled, the item department field in NetSuite will be used as the item category in App4Sales during synchronization.

Boolean (true/false). Default is 'false'.

Affects how item categories are assigned in App4Sales.

Item types for synchronization

A comma-separated list of NetSuite item types that should be synchronized with App4Sales. Only items matching these types will be included.

Comma-separated string. Possible values: Assembly Item (BOM Item), Description Item, Discount Item, Download Item, Gift Certificate Item, Inventory Item, Item Group, Kit/Package Item, Lot Numbered Assembly Item, Lot Numbered Inventory Item, Markup Item, Noninventory Purchase Item, Noninventory Resale Item, NonInventory Sales Item, Other Charge Purchase Item, Other Charge Resale Item, Other Charge Sale Item, Payment Item, Serialized Assembly Item, Serialized Inventory Item, Service Purchase Item, Service Resale Item, Service Sale Item, Subtotal Item.

Filters which items are synchronized from NetSuite to App4Sales.

Show the shift prices as free fields

If enabled, shift prices from NetSuite will be displayed as free fields within the App4Sales application.

Boolean (true/false). Default is 'false'.

Adds additional data points to App4Sales item details.

Show the pick locations as free fields

If enabled, pick locations from NetSuite will be displayed as free fields within the App4Sales application.

Boolean (true/false). Default is 'false'.

Adds additional data points to App4Sales item details.

Show base price as free field

If enabled, the base price of an item from NetSuite will be displayed as a free field within the App4Sales application.

Boolean (true/false). Default is 'false'.

Adds additional data points to App4Sales item details.

Mapping for custom customer fields (JSON format)

Configures how custom customer fields from NetSuite are mapped and displayed as free fields in App4Sales. This setting expects a JSON array defining the mapping.

JSON string. Example: [{ "ObjectName": "Customer", "PropertyName": "AddressLine3", "XmlName": "CustomerAddressLine3", "NameInApp": "Addressline 3" }]

Customizes customer information displayed in App4Sales.

Account concurrency limit

Sets the maximum number of concurrent API calls that can be made to the NetSuite account. This helps prevent rate limiting.

Integer. Default is '0'.

Controls the load on the NetSuite API. Setting to 0 might indicate no explicit limit, or an internal default.

Download pictures concurrency limit

Sets the maximum number of concurrent picture downloads from NetSuite.

Integer. Default is '0'.

Controls the load during image synchronization. Setting to 0 might indicate no explicit limit, or an internal default.

Page size to use for batch calls (customers, items)

Specifies the number of records (customers or items) to retrieve in a single batch API call from NetSuite.

Integer. Default is '500'.

Affects performance and memory usage during data synchronization.

Default customer subsidiary name

Defines the default subsidiary name to be used for new customers created in NetSuite.

String. No default.

Used when creating new customer records.

Allow custom item prices on order

If enabled, allows custom item prices to be set for order items within App4Sales.

Boolean (true/false). Default is 'false'.

Affects pricing flexibility for order entry.

Sync only customers in stages

A comma-separated list of NetSuite customer stages. Only customers in these specified stages will be synchronized to App4Sales.

Comma-separated string. Possible values: customer, lead, prospect. No default.

Filters which customers are synchronized from NetSuite to App4Sales.

Store a customer category field to the free fields

If enabled, a customer category field from NetSuite will be stored as a free field in App4Sales.

Boolean (true/false). Default is 'false'.

Adds customer category information to App4Sales.

Set 'class' for an order based on passed order type

Enables specific logic for a "RedLuxury" customer. If enabled and the OrderType value has the format 'Order:InternalId', it sets the 'class' field for the created sales order in NetSuite.

Boolean (true/false). Default is 'false'.

Requires 'Trade type custom field name for orders' to be empty/disabled. Specific to sales order creation and "RedLuxury" customer setup.

Company name (custom field name)

Specifies the name of the custom field in NetSuite that holds the company name.

String. No default.

Used to map the company name to a custom field during customer synchronization.

Consumer email custom field name on sales orders

Specifies the name of the custom field in NetSuite that holds the consumer's email address on sales orders.

String. No default.

Used to populate the consumer email on sales orders.

Salesrep email custom field name on sales orders

Specifies the name of the custom field in NetSuite that holds the sales representative's email address on sales orders.

String. No default.

Used to populate the sales rep email on sales orders.

Order received by (custom field name)

Specifies the name of the custom field in NetSuite that indicates who received the order.

String. No default.

Used to populate order reception information.

Order received by (custom field value)

Specifies the value to be used for the custom field indicated by 'Order received by (custom field name)'.

String. No default.

Used in conjunction with 'Order received by (custom field name)'.

Contact custom field name for orders

Specifies the name of the custom field in NetSuite that links to the contact for an order.

String. No default.

Used to associate a contact with an order.

Trade type custom field name for orders

Specifies the name of the custom field in NetSuite that defines the trade type for orders.

String. No default.

Used to categorize orders by trade type.

Order delivery date (custom field name)

Specifies the name of the custom field in NetSuite that stores the order delivery date.

String. No default.

Used to map delivery date information to a custom field.

Order delivery date (custom field format, like MM/dd/yyyy)

Defines the format of the date string expected for the custom order delivery date field.

String. Example: MM/dd/yyyy. No default.

Used in conjunction with 'Order delivery date (custom field name)' for correct date parsing.

Estimate delivery date (custom field name)

Specifies the name of the custom field in NetSuite that stores the estimate delivery date.

String. No default.

Used to map estimate delivery date information to a custom field.

Estimate delivery date (custom field format, like MM/dd/yyyy)

Defines the format of the date string expected for the custom estimate delivery date field.

String. Example: MM/dd/yyyy. No default.

Used in conjunction with 'Estimate delivery date (custom field name)' for correct date parsing.

Currency of the pricelist that will be used for the default sales price

Specifies the currency of the price list to be used for the default sales price in App4Sales.

String (e.g., USD, EUR). No default.

Influences default pricing for items.

Generate customer entity id for new customers

If enabled, the connector will generate an entity ID for new customers created in NetSuite.

Boolean (true/false). Default is 'false'.

Affects the generation of customer IDs in NetSuite.

Send VAT liable for new customers

If enabled, the VAT liability status will be sent to NetSuite for newly created customers.

Boolean (true/false). Default is 'false'.

Affects tax calculation and reporting for new customers.

Custom form used when creating new customers

Specifies the name of the custom form to be used in NetSuite when creating new customer records.

String. No default.

Influences the layout and fields available when creating new customers.

Status used for new customers

Specifies the default status to be assigned to new customers created in NetSuite.

String. No default.

Influences the initial lifecycle stage of new customer records.

Use Your Reference for PO number in NetSuite

If enabled, the "Your Reference" field from App4Sales will be mapped to the Purchase Order (PO) number field in NetSuite.

Boolean (true/false). Default is 'false'.

Affects how purchase order numbers are transferred to NetSuite.

Default payment condition id for orders

Specifies the default payment condition ID to be used for orders created in NetSuite.

String. No default.

Influences payment terms for new orders.

Next delivery shipping date (custom field name)

Specifies the name of the custom field in NetSuite that stores the next possible shipping date for delivery.

String. No default.

Used to map shipping date information to a custom field.

Next delivery quantity (custom field name)

Specifies the name of the custom field in NetSuite that stores the next possible delivery quantity.

String. No default.

Used to map quantity information to a custom field.

Use salesrep default pricelist for creating a customer

If enabled, the default price list associated with the sales representative will be used when creating a new customer in NetSuite.

Boolean (true/false). Default is 'false'.

Influences the pricing assigned to new customers.

Chamber of commerce (custom field name)

Specifies the name of the custom field in NetSuite that stores the Chamber of Commerce registration number.

String. No default.

Used to map Chamber of Commerce information to a custom field.

Customer manager (custom field name)

Specifies the name of the custom field in NetSuite that stores the customer manager's name.

String. No default.

Used to map customer manager information to a custom field.

Use Tax Reg Nr to determine VAT liability

If enabled, the Tax Registration Number will be used to determine the customer's VAT liability in NetSuite.

Boolean (true/false). Default is 'false'.

Affects VAT calculations based on the tax registration number.

Country check for Tax Reg Nr VAT liability

Specifies the country code to be used in conjunction with the Tax Registration Number for VAT liability checks.

String. No default.

Used with "Use Tax Reg Nr to determine VAT liability" to perform country-specific VAT checks.

Locations to include in stock values

A comma-separated list of NetSuite location IDs. Only stock values from these specified locations will be included in App4Sales.

Comma-separated string. No default.

Filters which stock values are synchronized from NetSuite to App4Sales.

Sync customers based on custom yes/no field

Specifies the name of a custom "Yes/No" (boolean) field in NetSuite. Only customers where this field is set to "Yes" will be synchronized.

String. No default.

Provides a filter for customer synchronization based on a custom flag.

Sync items based on custom yes/no field

Specifies the name of a custom "Yes/No" (boolean) field in NetSuite. Only items where this field is set to "Yes" will be synchronized.

String. No default.

Provides a filter for item synchronization based on a custom flag.

Item VAT percentage (%)

Defines a default VAT percentage to be applied to items.

Decimal. Default is '21'.

Used in VAT calculations for items.

Field name (or regex) for the X value of the matrix

Specifies the field name or a regular expression to identify the X-axis value for matrix items in NetSuite.

String (field name or regex). No default.

Used for mapping matrix item variations.

Field name (or regex) for the Y value of the matrix

Specifies the field name or a regular expression to identify the Y-axis value for matrix items in NetSuite.

String (field name or regex). No default.

Used for mapping matrix item variations.

Alternative source of item picture (custom field name)

Specifies the name of a custom field in NetSuite that contains an alternative URL or path for item pictures.

String. No default.

Allows overriding the default item picture source.

JSON mapping for items fields

Configures the mapping between NetSuite item fields (standard or custom) and App4Sales item fields or categories. Expects a JSON array.

JSON string. Example: [{ "NetSuiteItemFieldName" : "", "NetSuiteItemCustomFieldName" : "", "A4SItemFieldName" : "", "A4SItemCategoryName" : ""}]

Customizes how item data is transferred and categorized in App4Sales.

JSON mapping for items descriptions

Configures the mapping between NetSuite item fields (standard or custom) and specific App4Sales item description fields (Description 2, 3, 4, 5). Expects a JSON array.

JSON string. Example: [{ "NetSuiteItemFieldName" : "", "NetSuiteItemCustomFieldName" : "", "LanguageCode" : "", "A4SDescriptionFieldNumber" : ""}]

Customizes how item descriptions are populated in App4Sales.

Default location id

Specifies the default NetSuite internal ID of the location to be used.

String. No default.

Used when a location is required but not explicitly specified.

Field name for Vat liable

Specifies the name of the custom field in NetSuite that indicates whether an entity is VAT liable.

String. No default.

Used to determine VAT liability for transactions.

Tax item value for VAT liable = true

Specifies the tax item value to be used in NetSuite when the VAT liable field is set to 'true'.

String. No default.

Works in conjunction with 'Field name for Vat liable' to apply the correct tax item.

Tax item value for VAT liable = false

Specifies the tax item value to be used in NetSuite when the VAT liable field is set to 'false'.

String. No default.

Works in conjunction with 'Field name for Vat liable' to apply the correct tax item.

Use App4Sales visit address as Netsuite Sales order invoice address

If enabled, the visit address from App4Sales will be used as the invoice address for sales orders created in NetSuite.

Boolean (true/false). Default is 'false'.

Affects the billing address on sales orders.

Address custom fields values (JSON format)

Configures the mapping for NetSuite address custom fields and their values. Expects a JSON array.

JSON string. Example: [{ "NetSuiteAddressFieldId" : "", "NetSuiteAddressFieldValue" : "", "ExtraFieldType" : ""}]

Customizes how address-related custom fields are handled.

Custom field used for Purchase package size (Technical ID)

Specifies the technical ID of the custom field in NetSuite that stores the purchase package size.

String. No default.

Used to map purchase package size information.

Include quotations in the orders history

If enabled, quotations from NetSuite will be included when retrieving the order history in App4Sales.

Boolean (true/false). Default is 'false'.

Expands the scope of order history displayed.

Leave the order ship date empty

If enabled, the ship date for orders sent to NetSuite will be left empty.

Boolean (true/false). Default is 'false'.

Overrides automatic population of the ship date.

Map order Source to a sales order field (name)

Specifies the name of a standard sales order field in NetSuite to which the order source from App4Sales will be mapped.

String. No default.

Used to populate the order source in NetSuite.

Map order Reference to a sales order field (name)

Specifies the name of a standard sales order field in NetSuite to which the order reference from App4Sales will be mapped.

String. No default.

Used to populate the order reference in NetSuite.

Ship method code to retrieve shipments for

Specifies the ship method code in NetSuite used to filter and retrieve shipment information.

String. No default.

Filters which shipments are retrieved for tracking.

Name of the custom field to retrieve track & trace code for shipments

Specifies the name of the custom field in NetSuite that contains the track and trace code for shipments.

String. No default.

Used to retrieve shipment tracking information.

Item status (custom field name)

Specifies the name of the custom field in NetSuite that defines the item's status.

String. No default.

Used to map item status information.

Item status custom values mapping (JSON format)

Configures the mapping between App4Sales item statuses and NetSuite item status custom field values. Expects a JSON array.

JSON string. Example: [{"App4SalesStatus" : "PreSales", "NetSuiteStatus" : "Pre-order Page"}, {"App4SalesStatus" : "Stock", "NetSuiteStatus" : "Stock Page"}]

Translates item statuses between App4Sales and NetSuite.

Mapping for credit card types (JSON format)

Configures the mapping for credit card types, determining the NetSuite credit card type ID based on the starting numbers of the card. Expects a JSON array.

JSON string. Example: [{ "CardType": 1, "CardNumberStartsWith": "5" }]. Possible NetSuite card types (internal IDs): _amex=0,_cirrus=1,_dinersClub=2,_discover=3,_jcb=4,_laser=5,_localCard=6,_maestro=7,_masterCard=8,_solo=9,_unionPay=10,_visa=11.

Used for processing credit card payments.

Mapping for credit card payment method (JSON format)

Configures the mapping for credit card payment methods, determining the NetSuite payment method ID based on the starting numbers of the card. Expects a JSON array.

JSON string. Example: [{ "CardType": "1", "CardNumberStartsWith": "5" }]. Payment method is a customizable list in Netsuite.

Used for processing credit card payments.

To be received stock (custom field name)

Specifies the name of the custom field in NetSuite that indicates the quantity of stock to be received.

String. No default.

Used to track incoming stock.

Include ordered quantity to stock values

If enabled, the quantity of ordered items will be included in the stock values synchronized to App4Sales.

Boolean (true/false). Default is 'false'.

Affects the calculation of available stock in App4Sales.

Use following order statuses for backorders retrieve (comma separated)

A comma-separated list of NetSuite order statuses. Only backorders with these statuses will be retrieved.

Comma-separated string. Possible values: Closed, Pending Approval, Pending Fulfillment, Partially Fulfilled, Pending Billing, Pending Billing/Partially Fulfilled, Billed, Canceled, Undefined. No default.

Filters which backorders are visible in App4Sales.

Show only backorder lines

If enabled, only backorder lines will be displayed, filtering out fully fulfilled or non-backorder lines.

Boolean (true/false). Default is 'false'.

Affects the display of order lines in App4Sales.

Send credit card to backoffice

If enabled, credit card information will be sent to the back office system.

Boolean (true/false). Default is 'false'.

Impacts security and PCI compliance.

Customer discount custom field name

Specifies the name of the custom field in NetSuite that stores the customer discount.

String. No default.

Used to apply customer-specific discounts.

Custom order checkbox to set to true for new orders (comma separated)

A comma-separated list of custom checkbox field names in NetSuite. These fields will be set to 'true' for new orders created from App4Sales.

Comma-separated string. No default.

Used to set specific flags on new orders.

UseStoreDisplayNameAsDescription

If enabled, the display name of the store will be used as the description for certain entities.

Boolean (true/false). Default is 'false'.

Affects descriptions where applicable.

Remove the following prefix for the linked order numbers in the shipments history

Specifies a prefix that should be removed from linked order numbers when displaying shipment history.

String. No default.

Cleans up order numbers in shipment history display.

Map order Source to a custom order field

Specifies the name of a custom order field in NetSuite to which the order source from App4Sales will be mapped.

String. No default.

Used to populate the order source in a custom field in NetSuite.

Split item live stock by locations

If enabled, live stock quantities for items will be split and displayed per NetSuite location.

Boolean (true/false). Default is 'false'.

Provides a more detailed view of stock availability by location.

Only show available stock

If enabled, only the available stock quantities will be displayed, excluding reserved or on-order stock.

Boolean (true/false). Default is 'false'.

Filters stock display to show only immediately fulfillable quantities.

Use the full warehouse location name

If enabled, the full name of the warehouse location from NetSuite will be used instead of a truncated or abbreviated version.

Boolean (true/false). Default is 'false'.

Affects the display of warehouse location names.

SendCustomerPriceOnOrder

If enabled, the customer-specific price will be sent with the order to NetSuite.

Boolean (true/false). Default is 'false'.

Influences pricing sent with orders.

Use the subsidiary of the salesrep

If enabled, the subsidiary associated with the sales representative in NetSuite will be used for transactions.

Boolean (true/false). Default is 'false'.

Influences the subsidiary assigned to sales transactions.

Only send in business data on the company when creating a customer

If enabled, only business-related data will be sent when creating a new customer for a company in NetSuite, excluding personal contact information.

Boolean (true/false). Default is 'false'.

Controls the data sent during customer creation.

Script parameter value to retrieve stock data from servlets

Specifies the script parameter value required to retrieve stock data from NetSuite servlets.

String. No default.

Required for servlet-based stock data retrieval. Must be set in conjunction with 'Deploy parameter value to retrieve stock data from servlets'.

Deploy parameter value to retrieve stock data from servlets

Specifies the deployment parameter value required to retrieve stock data from NetSuite servlets.

String. No default.

Required for servlet-based stock data retrieval. Must be set in conjunction with 'Script parameter value to retrieve stock data from servlets'.

Stock data properties (list property names without angle brackets separated by semicolons: <quantity>;<on_hand>;<delivery_date>)

Defines the mapping for stock data properties received from NetSuite servlets. Provide a semicolon-separated list of property names (e.g., quantity;on_hand;delivery_date).

Semicolon-separated string. Example: quantity;on_hand;delivery_date. No default.

Used to parse and understand stock data received from servlets.

VAT percentages: tax schedule names and percentages separated by semicolons: Standard=20;Zero rate=0

Defines a mapping of NetSuite tax schedule names to their corresponding VAT percentages. This is a semicolon-separated list of Name=Percentage pairs.

Semicolon-separated string. Example: Standard=20;Zero rate=0. No default.

Used for accurate VAT calculations based on NetSuite tax schedules.

Amount of years of history for orders/invoices (1 year by default)

Specifies the number of years for which order and invoice history should be retrieved from NetSuite.

Integer. Default is '1'.

Controls the depth of historical data retrieved.

Hide invoices on relation card

If enabled, invoices will not be displayed on the customer relation card in App4Sales.

Boolean (true/false). Default is 'false'.

Affects the visibility of invoice data in App4Sales.

Retrieve the minimum quantity on items as purchase package size

If enabled, the minimum quantity defined for an item in NetSuite will be interpreted and used as the purchase package size in App4Sales.

Boolean (true/false). Default is 'false'.

Affects how purchase package size is determined for items.

Hide discount items in backorders

If enabled, discount-related items will be hidden from the backorder list in App4Sales.

Boolean (true/false). Default is 'false'.

Filters the display of items in backorders.

Only retrieve sales history for this subsidiary ID

Specifies a NetSuite subsidiary ID. If set, sales history will only be retrieved for this specific subsidiary.

Integer (nullable). No default.

Filters sales history retrieval by subsidiary.