Skip to main content

ExactOnlineV2 - Connector settings

ExactOnlineV2 - Connector Settings These settings control the behavior of the Exact Online V2 connector. They influence how data is synchr...

Updated over a week ago

ExactOnlineV2 - Connector Settings

These settings control the behavior of the Exact Online V2 connector. They influence how data is synchronized, how prices are calculated, and how orders are sent to Exact Online.

Settings are configured in the App4Sales CMS and are applied at runtime during synchronization and order processing.

Setting

Description

Values / Defaults

Dependencies / Effects

Application key

The application key for the Exact Online API.

String

Required for authentication.

Currency code iso

The ISO currency code to use for financial transactions.

String (e.g., "EUR")

Affects all financial data synchronization.

VAT liable code

The VAT code to use for customers who are liable for VAT.

String

Used in customer and order synchronization.

Not VAT liable code

The VAT code to use for customers who are not liable for VAT.

String

Used in customer and order synchronization.

Auto synchronize all pricelists

If enabled, all pricelists from Exact Online will be synchronized automatically.

Boolean (True/False)

When disabled, specific pricelists must be configured using the PriceList2Id, PriceList3Id, and PriceList4Id settings.

Pricelist 2 ID

The ID of the second pricelist to synchronize.

String

Only used if "Auto synchronize all pricelists" is disabled.

Pricelist 3 ID

The ID of the third pricelist to synchronize.

String

Only used if "Auto synchronize all pricelists" is disabled.

Pricelist 4 ID

The ID of the fourth pricelist to synchronize.

String

Only used if "Auto synchronize all pricelists" is disabled.

Use item extra description for item field

Specifies which App4Sales item field should be populated with the extra description from the Exact Online item.

String (e.g., "ExtraDescription")

Affects item synchronization.

Variant currency

If enabled, the connector will handle variant currencies for items.

Boolean (True/False)

Affects item and price synchronization.

Search code for EAN code

If enabled, the connector will use the search code from Exact Online as the EAN code in App4Sales.

Boolean (True/False)

Affects item synchronization.

Unit factor as purchase package size

If enabled, the unit factor from the Exact Online item will be used as the purchase package size in App4Sales.

Boolean (True/False)

Affects item synchronization.

Account classification on customer name

If enabled, the customer's account classification in Exact Online will be appended to the customer's name in App4Sales.

Boolean (True/False)

Affects customer synchronization.

Account classification on customer manager

If enabled, the customer's account classification in Exact Online will be used to determine the customer manager in App4Sales.

Boolean (True/False)

Affects customer synchronization.

Only sync webshop items

If enabled, only items marked as "webshop items" in Exact Online will be synchronized.

Boolean (True/False)

Affects item synchronization.

Get prospects

If enabled, prospects from Exact Online will be synchronized as customers in App4Sales.

Boolean (True/False)

Affects customer synchronization.

Get suspects

If enabled, suspects from Exact Online will be synchronized as customers in App4Sales.

Boolean (True/False)

Affects customer synchronization.

Add prefix for prospects and suspects

If enabled, a prefix will be added to the names of synchronized prospects and suspects to distinguish them from regular customers.

Boolean (True/False)

Requires "Get prospects" or "Get suspects" to be enabled.

Get purchase package size on extra item description

If enabled, the purchase package size will be extracted from the extra item description field in Exact Online.

Boolean (True/False)

Affects item synchronization.

Order history backoffice

If enabled, order history will be retrieved from the backoffice system.

Boolean (True/False)

Affects order history synchronization.

Use date as delivery date

If enabled, the order date will be used as the delivery date for new orders.

Boolean (True/False)

Affects order creation.

Languages

A comma-separated list of languages to synchronize from Exact Online.

String (e.g., "en,nl,de")

Affects multilingual data synchronization.

Use current quantity as last available stock

If enabled, the current stock quantity will be used as the last available stock level in App4Sales.

Boolean (True/False)

Affects stock synchronization.

Order select top

The maximum number of orders to retrieve from Exact Online in a single request.

Integer

Used for performance tuning during order synchronization.

Free sort field

The name of the free sort field in Exact Online to use for sorting items.

String

Affects item sorting in App4Sales.

GL account sales code

The general ledger account code to use for sales transactions.

String

Used when creating orders in Exact Online.

Use notes as description

If enabled, the notes field from the Exact Online item will be used as the item description in App4Sales.

Boolean (True/False)

Affects item synchronization.

Use reference as your ref

If enabled, the "Your reference" field from the App4Sales order will be sent to the "Reference" field in the Exact Online order.

Boolean (True/False)

Affects order creation.

Set unit price

If enabled, the unit price will be explicitly set on order lines sent to Exact Online.

Boolean (True/False)

Affects order creation.

Set original price on unit price

If enabled, the original (gross) price will be set on the unit price field of the order line.

Boolean (True/False)

Affects order creation.

Check if item is active

If enabled, the connector will only synchronize active items from Exact Online.

Boolean (True/False)

Affects item synchronization.

Net price including VAT

If enabled, the net price sent to App4Sales will include VAT.

Boolean (True/False)

Affects price synchronization.

Calculate correct net price based on the VAT liability of the customer

If enabled, the net price will be calculated based on the customer's VAT liability.

Boolean (True/False)

Affects price calculations.

Cost unit for orders by sales rep

If enabled, the cost unit for orders will be determined based on the sales representative.

Boolean (True/False)

Affects order creation.

Cost center for orders based on user

If enabled, the cost center for orders will be determined based on the user placing the order.

Boolean (True/False)

Affects order creation.

Use VAT liability for default country

If enabled, VAT liability will be determined based on the default country.

Boolean (True/False)

Affects VAT calculations.

Use discount without price on order

If enabled, discounts can be applied to orders even if no price is specified.

Boolean (True/False)

Affects order creation.

VAT code based on country code

A mapping of country codes to VAT codes.

String (e.g., "NL:HIGH,DE:LOW")

Used to determine the correct VAT code for an order based on the customer's country.

Not VAT liable code outside EU

The VAT code to use for customers outside the European Union who are not liable for VAT.

String

Used for international orders.

Default country for VAT liability

The default country to use for determining VAT liability.

String (e.g., "NL")

Used when the customer's country is not available.

Price list code for staffel free field

The free field in Exact Online that contains the price list code for tiered pricing (staffels).

String

Affects tiered pricing synchronization.

Split character for extra item description

The character used to split the extra item description field into multiple parts.

String (e.g., ";")

Used for parsing the extra item description field.

Purchase package size index

The index of the part in the split extra item description that contains the purchase package size.

Integer

Requires "Split character for extra item description" to be set.

Use item notes for item field

Specifies which App4Sales item field should be populated with the notes from the Exact Online item.

String (e.g., "Notes")

Affects item synchronization.

Cost center code for orders

The cost center code to use for all orders.

String

Affects order creation. Overridden by "Cost center for orders based on user" if enabled.

Update email only for customer

If enabled, only the email address of the customer will be updated during synchronization.

Boolean (True/False)

Affects customer synchronization.

Update phone only for customer

If enabled, only the phone number of the customer will be updated during synchronization.

Boolean (True/False)

Affects customer synchronization.

Skip discount for staffel items

If enabled, discounts will not be applied to items with tiered pricing (staffels).

Boolean (True/False)

Affects order creation.

Generate pricelists for every currency

If enabled, a separate pricelist will be generated for each currency in App4Sales.

Boolean (True/False)

Affects pricelist synchronization.

Fill order description with 'App4sales order' when none is supplied

If enabled, the order description will be set to 'App4sales order' if no description is provided.

Boolean (True/False), Default: True

Affects order creation.

Hide invoices on relation card

If enabled, invoices will be hidden on the customer card in App4Sales.

Boolean (True/False)

Affects the App4Sales UI.

Warehouse used for stock

The ID of the warehouse to use for stock synchronization.

String

Affects stock synchronization.

Warehouse used for order

The ID of the warehouse to use when creating orders.

String

Affects order creation.

Warehouse used for purchase package size

The ID of the warehouse to use for retrieving the purchase package size.

String

Affects item synchronization.

Set customer account when creating a new customer

The general ledger account code to set for new customers created in Exact Online.

String

Affects customer creation.

Shipping method code for new orders

The shipping method code to use for new orders.

String

Affects order creation.

Use item group description for pricelists

If enabled, the item group description will be used for pricelist names instead of the item group code.

Boolean (True/False)

Affects pricelist synchronization.

Use search code as customer manager

If enabled, the search code from the Exact Online customer will be used as the customer manager in App4Sales.

Boolean (True/False)

Affects customer synchronization.

Use the currency code from a priceList

If enabled, the currency code from the pricelist will be used instead of the default currency.

Boolean (True/False)

Affects price synchronization.

Purchase package size from search code

If enabled, the purchase package size will be retrieved from the search code of the item.

Boolean (True/False)

Affects item synchronization.

Show only backorder lines in App4Sales

If enabled, only backorder lines will be shown in the order history in App4Sales.

Boolean (True/False)

Affects order history display.

Get delivery dates as free field (offline)

If enabled, delivery dates will be retrieved as a free field and will be available offline.

Boolean (True/False)

Affects item synchronization.

Synchronize next delivery date

If enabled, the next delivery date of an item will be synchronized.

Boolean (True/False)

Affects item synchronization.

Check stock (shelf - to be delivered) and set orderline deliverydate

If enabled, the stock level will be checked and the delivery date on the order line will be set accordingly.

Boolean (True/False)

Affects order creation.

Only load customers that are dealers

If enabled, only customers marked as "dealers" in Exact Online will be synchronized.

Boolean (True/False)

Affects customer synchronization.

Store package size in instruction line

If enabled, the package size will be stored in an instruction line on the order.

Boolean (True/False)

Affects order creation.

Only set delivery date for unchanged order date

If enabled, the delivery date will only be set if the order date has not been changed by the user.

Boolean (True/False)

Affects order creation.

Field used to include items in sync

Specifies a field in Exact Online that is used to determine whether an item should be included in the synchronization.

String

Affects item synchronization.

Warehouse per salesrep

If enabled, the warehouse for an order will be determined based on the sales representative.

Boolean (True/False)

Affects order creation.

Place extra description on item description

If enabled, the extra description of the item will be appended to the main description.

Boolean (True/False)

Affects item synchronization.

Warehouse from order type (value to backoffice)

If enabled, the warehouse for an order will be determined based on the order type.

Boolean (True/False)

Affects order creation.

Create item filter based on warehouse

If enabled, an item filter will be created for each warehouse, allowing users to filter items by warehouse.

Boolean (True/False)

Affects item filtering in App4Sales.

Create alternative address at customer

If enabled, an alternative address will be created for the customer in Exact Online.

Boolean (True/False)

Affects customer and order creation.

Create the alternative contactperson of an order in Exact Online and attach it to the delivery address

If enabled, an alternative contact person will be created in Exact Online and linked to the delivery address of the order.

Boolean (True/False)

Affects order creation.

Use sales price including VAT as free field

If enabled, the sales price including VAT will be stored in a free field.

Boolean (True/False)

Affects item synchronization.

Account classification property name

The name of the account classification property in Exact Online.

String

Used to retrieve the account classification.

Set item description when sending order

If enabled, the item description will be sent with the order.

Boolean (True/False), Default: True

Affects order creation.

Rename the freefields which are selected as extra fields (JSON format)

A JSON mapping to rename free fields to more user-friendly names.

String (JSON format)

Affects the display of free fields in App4Sales.

Use correct price on item to check on unit

If enabled, the connector will use the correct price based on the item's unit of measurement.

Boolean (True/False)

Affects price calculations.

Mapping for custom customer fields (JSON format)

A JSON mapping to map custom fields from App4Sales to custom fields in Exact Online for new customers.

String (JSON format)

Affects customer creation.

Include items which are not marked as sales item

If enabled, items that are not marked as "sales items" in Exact Online will also be included in the synchronization.

Boolean (True/False)

Affects item synchronization.

Add order type name to the description of the order

If enabled, the name of the order type will be added to the order description.

Boolean (True/False)

Affects order creation.

Register chosen contactperson on order in EOL

If enabled, the contact person selected in App4Sales will be registered on the order in Exact Online.

Boolean (True/False)

Affects order creation.

VAT Liability based on VAT Regime (Belgium)

If enabled, VAT liability will be determined based on the Belgian VAT regime.

Boolean (True/False)

Affects VAT calculations, specific to Belgium.

Exclude a price list from Exact Online

A comma-separated list of pricelist IDs to exclude from synchronization.

String

Affects pricelist synchronization.

Disable pictures from Exact Online

If enabled, pictures will not be synchronized from Exact Online.

Boolean (True/False)

Affects item synchronization.

No VAT code means customer is VAT liable

If enabled, customers without a VAT code will be considered VAT liable.

Boolean (True/False)

Affects VAT calculations.

Disable pricelist currency check

If enabled, the currency check for pricelists will be disabled.

Boolean (True/False)

Can be used to work around currency inconsistencies.

Round orderline prices to two decimals

If enabled, order line prices will be rounded to two decimal places.

Boolean (True/False)

Affects order creation.

Set the pricelist on a orderLine when a price or discount isn't changed (does not working with staffles)

If enabled, the pricelist will be set on the order line if the price or discount has not been changed by the user. Does not work with tiered pricing.

Boolean (True/False)

Affects order creation.

Cost unit for orders

The cost unit to use for all orders.

String

Affects order creation. Overridden by "Cost unit for orders by sales rep" if enabled.

GLAccount code for invoices

The general ledger account code to use for invoices.

String

Used when creating invoices in Exact Online.

Sort orderlines by itemcode before sending the order (only works for numeric item codes)

If enabled, order lines will be sorted by item code (numerically) before the order is sent to Exact Online.

Boolean (True/False)

Affects order creation.

Synchronise customer notes from Exact Online

If enabled, customer notes will be synchronized from Exact Online.

Boolean (True/False)

Affects customer synchronization.

Get purchase package size from free field

The name of the free field in Exact Online that contains the purchase package size.

String

Affects item synchronization.

Disable instruction as orderline deliverydate to the backoffice

If enabled, the instruction field will not be used as the delivery date for the order line.

Boolean (True/False)

Affects order creation.

Enable offline tier prices

If enabled, tiered prices (staffels) will be available in offline mode.

Boolean (True/False)

Affects pricing in offline mode.

Item free field name for item status

The name of the free field in the Exact Online item that contains the item status.

String

Affects item synchronization.

Account classification property name for customer manager

The name of the account classification property in Exact Online to use for determining the customer manager.

String

Affects customer synchronization.

Exclude VAT from history totals

If enabled, VAT will be excluded from the totals in the order history.

Boolean (True/False)

Affects order history display.

Always create a credit note for return orders in Exact Online (instead of the default redelivery)

If enabled, a credit note will always be created for return orders instead of a redelivery.

Boolean (True/False)

Affects return order processing.

Alternative invoice address overwrites the default invoice address on the customer

If enabled, the alternative invoice address will overwrite the default invoice address for the customer.

Boolean (True/False)

Affects customer data.

Send the housenumber & addition in addressline 2 & 3 fields

If enabled, the house number and addition will be sent in separate address line fields to Exact Online.

Boolean (True/False)

Affects address formatting for orders and customer creation.

Show the next delivery date on back order lines based on A4S item next delivery date

If enabled, the next delivery date from the App4Sales item will be shown on backorder lines.

Boolean (True/False)

Affects backorder display.

Don't delete pricelist prices which are the same as the default price

If enabled, pricelist prices that are the same as the default price will not be deleted during synchronization.

Boolean (True/False)

Affects pricelist synchronization.

Retrieve item assortment property descriptions instead of the codes

If enabled, the descriptions of item assortment properties will be retrieved instead of their codes.

Boolean (True/False)

Affects item data synchronization.

Only retrieve customers with specific customer classification value(s)

A comma-separated list of customer classification values. Only customers with one of these classifications will be retrieved.

String

Affects customer synchronization.

Sales channel code to use for orders

The sales channel code to use for orders sent to Exact Online.

String

Affects order creation.

Did this answer your question?