Setting

Description

Values / Defaults

Dependencies / Effects

Tenant Domain

Specifies the Azure Active Directory GUID. This can be located in the Azure Portal under Azure Active Directory > Settings > CatalogID.

String (GUID)

Required for Azure AD-based authentication.

Client ID

The client ID for authentication with Microsoft Business Central. This is a sensitive credential.

String (GUID)

Required for API access. Encrypted property.

Client Secret

The client secret for authentication with Microsoft Business Central. This is a sensitive credential.

String

Required for API access. Encrypted property.

Scope

Defines the permissions requested for API access.

String (e.g., https://api.businesscentral.dynamics.com/.default)

Determines the operations App4Sales can perform.

Use service-to-service authentication

Enables authentication using a service principal instead of a user account.

Boolean (True/False)

When enabled, Client ID and Client Secret are used for authentication.

Use Basic authorization for requests to backoffice

Activates basic authentication (username and password) for API requests to Microsoft Business Central.

Boolean (True/False)

Alternative to token-based authentication.

Microsoft Business Central version

Indicates the version of Microsoft Business Central, which influences the API endpoints and functionalities used. This property name is misleading as its usage actually refers to the version of MBC itself.

String (e.g., "v2.0")

Determines compatibility and available features.

Version of Optimizers AL extensions

Specifies the version of Optimizers' custom AL (Application Language) extensions installed in Microsoft Business Central.

String (e.g., "1.0.0.0")

Ensures compatibility with custom functionalities.

Microsoft Business Central environment name

The name of the Microsoft Business Central environment (e.g., 'Production', 'Sandbox').

String

Used to target the correct environment for API calls.

Microsoft Business Central base currency code

The base currency code used in Microsoft Business Central.

String (e.g., "EUR", "USD")

Used for currency conversions and financial calculations.

Use the new prices feature from MBC

Enables the use of price list lines for retrieving item prices from Microsoft Business Central.

Boolean (True/False)

If enabled, prices are fetched from price list lines; otherwise, a different pricing mechanism is used.

Indicator field name to sync items

Specifies a custom field in Microsoft Business Central that acts as an indicator for which items should be synchronized with App4Sales.

String (field name)

Items are only synced if this field meets specific criteria defined in the connector's logic.

Indicator field name to sync item categories

Specifies a custom field in Microsoft Business Central that indicates which item categories should be synchronized.

String (field name)

Only categories matching the indicator will be synced.

Only sync items which are marked as Webshop item

When enabled, only items explicitly marked as "Webshop item" in Microsoft Business Central will be synchronized.

Boolean (True/False)

Filters the item synchronization based on a specific item attribute.

Indicator field name to sync customers

Defines a custom field in Microsoft Business Central that signals which customers are eligible for synchronization.

String (field name)

Customers are synced based on the value of this field.

Unit of Measure for Purchase Package Size

Specifies the Unit of Measure (UOM) to be used for the purchase package size of items.

String (UOM code)

Affects how purchase quantities are interpreted.

Country code for always VAT liable customers

Sets the country code for customers who are always considered VAT liable, regardless of other VAT settings.

String (ISO 3166-1 alpha-2 country code, e.g., "NL")

Influences VAT calculation for specific customers.

Mark customers without VAT number as VAT liable

If enabled, customers who do not have a VAT number recorded in Microsoft Business Central will automatically be marked as VAT liable in App4Sales.

Boolean (True/False)

Affects VAT status for customers lacking VAT numbers.

VAT Business posting group code for item VAT percent

Specifies the VAT Business Posting Group code in Microsoft Business Central used to determine the VAT percentage for items.

String (posting group code)

Essential for correct item VAT calculation.

Enable dynamic item VAT percent determination during order send

Activates dynamic calculation of item VAT percentages during the order sending process.

Boolean (True/False)

If enabled, VAT is calculated at the time of order transmission, potentially overriding static values.

VAT business posting group code for vat liable customers (comma separated)

A comma-separated list of VAT Business Posting Group codes for customers identified as VAT liable.

String (e.g., "DOMESTIC,EU")

Used in conjunction with VAT liability determination.

VAT business posting group code for not vat liable customers (comma separated)

A comma-separated list of VAT Business Posting Group codes for customers who are not VAT liable.

String (e.g., "EXEMPT")

Used in conjunction with VAT liability determination.

Free field name for last available stock

Defines the name of a free field in Microsoft Business Central that holds the last available stock quantity for items.

String (field name)

Used to retrieve stock information.

Show date of next purchase order arrival for item

When enabled, App4Sales will display the expected arrival date from the next purchase order for an item.

Boolean (True/False)

Provides visibility into future stock availability.

Use dimension values in the dimension

If enabled, dimension values will be utilized within the dimensions structure for items or other entities.

Boolean (True/False)

Affects how dimensions are handled during synchronization.

Add additional data to sales headers using Optimizers AL script

Activates an Optimizers AL script to add additional data to sales headers during synchronization.

Boolean (True/False). Default: True

Enables custom data enrichment for sales orders.

Show only backorder lines in App4Sales

Restricts the display in App4Sales to only show backorder lines.

Boolean (True/False)

Filters order line visibility.

Show only not delivered order lines (in order lines for order)

When enabled, only order lines that have not yet been delivered will be shown in App4Sales.

Boolean (True/False)

Filters order line visibility based on delivery status.

Map Sales order your reference to External Document No.

Maps the "Your Reference" field from an App4Sales sales order to the "External Document No." field in Microsoft Business Central.

Boolean (True/False)

Ensures consistency in document referencing.

Map Sales order webshop reference to External Document No.

Maps the webshop reference from an App4Sales sales order to the "External Document No." field in Microsoft Business Central.

Boolean (True/False)

Ensures consistency in document referencing for webshop orders.

Save item category code using item category levels

Enables the use of item category levels when saving item category codes.

Boolean (True/False)

Affects how item categories are structured and stored.

Use Order multiply field for item purchase package size

Activates the use of an order multiply field to determine the item purchase package size.

Boolean (True/False)

Influences how purchase quantities are calculated based on package sizes.

Item workflow statuses for sync (comma separated)

A comma-separated list of item workflow statuses that should be synchronized from Microsoft Business Central.

String (e.g., "ACTIVE,NEW")

Only items with these statuses will be synced.

Mapping for custom customer fields (JSON format)

Defines a JSON mapping for custom customer fields between App4Sales and Microsoft Business Central. Example: [{ "ObjectName": "Customer", "PropertyName": "AddressLine3", "XmlName": "CustomerAddressLine3", "NameInApp": "Addressline 3" }]

String (JSON array)

Enables synchronization of additional customer-specific data.

Sync customer comment as customer note

When enabled, customer comments from Microsoft Business Central are synchronized as customer notes in App4Sales.

Boolean (True/False)

Transfers textual information about customers.

Mapping for item status (JSON format)

Provides a JSON mapping for item statuses between Microsoft Business Central and App4Sales. Example: [{ "MBCItemStatus": "J", "App4SalesItemStatus": "Noos" }]

String (JSON array)

Translates item statuses between the two systems.

Send customer language code

Enables the sending of the customer's language code during synchronization.

Boolean (True/False)

Important for multi-language support.

Extra field name for purchase package size

Specifies an additional field in Microsoft Business Central that can be used for purchase package size information.

String (field name)

Provides flexibility for custom package size definitions.

Price list code for standard price

Defines the price list code in Microsoft Business Central that represents the standard price for items.

String (price list code)

Used to identify and synchronize standard pricing.

Item reference type for EAN code

Specifies the item reference type used for EAN codes in Microsoft Business Central.

String (reference type)

Helps in accurately identifying items by EAN.

Item reference unit of measure for EAN code

Defines the Unit of Measure (UOM) used in conjunction with the EAN code for item references.

String (UOM code)

Ensures correct interpretation of EAN-related quantities.

Item reference barcode type for EAN code

Specifies the barcode type used for EAN codes in item references.

String (barcode type)

Aids in barcode scanning and identification.

Use customer custom endpoints for send order calls

Activates the use of customer-specific custom endpoints when sending orders to Microsoft Business Central.

Boolean (True/False)

Allows for routing orders to different endpoints based on customer.

Customer specific endpoint route part

Defines the route part for customer-specific endpoints used in send order calls.

String (route part)

Used in conjunction with "Use customer custom endpoints for send order calls".

Customer specific order fields mapping (JSON)

Provides a JSON mapping for customer-specific order fields. Example: { "entityRoutePart": "salesOrder","fieldsMapping": [ { "app4salesColumnName":"order.Customer.CustomerCode", "mbcColumnName":"customerNo", "defaultValue": "", "isDocumentNumberProperty": false, "isKeyProperty": true }, { "app4salesColumnName":"OrderNr", "mbcColumnName":"no", "defaultValue": "", "isDocumentNumberProperty": true, "isKeyProperty": true } ] }

String (JSON object)

Enables flexible mapping of order fields for specific customers.

Customer specific order line fields mapping (JSON)

Provides a JSON mapping for customer-specific order line fields. Example: { "entityRoutePart": "salesOrderLine","fieldsMapping": [ { "app4salesColumnName":"order.Customer.CustomerCode", "mbcColumnName":"customerNo", "defaultValue": "", "isDocumentNumberProperty": false, "isKeyProperty": true }, { "app4salesColumnName":"OrderNr", "mbcColumnName":"no", "defaultValue": "", "isDocumentNumberProperty": true, "isKeyProperty": true } ] }

String (JSON object)

Enables flexible mapping of order line fields for specific customers.

Include customer discount group discounts to live prices

When enabled, discounts from customer discount groups are included in the calculation of live prices.

Boolean (True/False)

Affects real-time price calculations for customers.

Use sales shipment header transport method as tracking method

Maps the transport method from the sales shipment header in Microsoft Business Central to the tracking method in App4Sales.

Boolean (True/False)

Helps in tracking order shipments.

Not include shipment quantity into send order line

When enabled, the shipment quantity will not be included when sending order lines to Microsoft Business Central.

Boolean (True/False)

Modifies the data sent with order lines.

Codes of customer discount group codes for customer discount percent sync CSV

A comma-separated list of customer discount group codes that should be synchronized for customer discount percentages.

String (e.g., "DISC1,DISC2")

Filters which discount groups are considered for synchronization.

Add accept language header for item pictures get requests

When enabled, an "Accept-Language" header will be added to requests for item pictures.

Boolean (True/False)

Allows for language-specific image retrieval.

Max count of parallel requests for item pictures upload

Sets the maximum number of parallel requests allowed when uploading item pictures.

Integer

Controls the concurrency of image uploads, impacting performance.

Sync address code as address line 3

Synchronizes the address code from Microsoft Business Central as address line 3 in App4Sales.

Boolean (True/False)

Maps a specific address component to a different field.

Use customer ledger entries to indicate posted invoice status

Utilizes customer ledger entries in Microsoft Business Central to determine the status of posted invoices.

Boolean (True/False)

Influences how invoice statuses are tracked.

Include invoice status into invoice history entry description

When enabled, the invoice status will be included in the description of invoice history entries.

Boolean (True/False)

Enriches invoice history details.

Delete orders which are not available at MBC from orders overview

If enabled, orders that exist in App4Sales but are no longer present in Microsoft Business Central will be removed from the App4Sales orders overview.

Boolean (True/False)

Maintains data consistency by removing stale order data.

Only send the discount to the backoffice with customer price if discount is calculated

When a discount is calculated, only the discount value and the default sales price will be sent to the back office.

Boolean (True/False)

Affects how discount information is transmitted.

Include discount into order line price (in order lines for order)

If enabled, the discount will be factored into the order line price displayed for orders in App4Sales.

Boolean (True/False)

Affects how order line prices are presented.

Post delivery address to MBC during customer create/update

Enables the posting of the delivery address to Microsoft Business Central when creating or updating customer records.

Boolean (True/False)

Ensures delivery address information is transferred.

Use customer visit address as delivery address if delivery not specified

If no specific delivery address is provided, the customer's visit address will be used as the delivery address.

Boolean (True/False)

Provides a fallback for delivery address.

Use sales prices per customer as maximum priority price for live prices

Prioritizes customer-specific sales prices as the highest priority when calculating live prices.

Boolean (True/False)

Ensures customer-specific pricing is applied.

New MBC address code prefix

Defines the prefix to be used for newly generated Microsoft Business Central address codes.

String (e.g., "A4S"). Default: A4S

Used for generating unique address codes.

Ignore delivery addresses without code during customers sync

When enabled, delivery addresses in Microsoft Business Central that do not have an associated code will be ignored during customer synchronization.

Boolean (True/False). Default: True

Filters delivery addresses based on the presence of a code.

Microsoft Business Central WebService API version

Specifies the version of the Microsoft Business Central WebService API to use.

String (e.g., "2.0")

Ensures compatibility with the correct API version.

Update sales header shipping address using webservice

Enables updating the sales header shipping address in Microsoft Business Central via a webservice call.

Boolean (True/False). Default: False

Facilitates updates to shipping information.

Send prefix plus order timestamp to MBC

When enabled, a prefix along with the order timestamp will be sent to Microsoft Business Central with orders.

Boolean (True/False)

Aids in uniquely identifying orders.

Use posting date as document date for sales invoice history

Uses the posting date from Microsoft Business Central as the document date for sales invoice history in App4Sales.

Boolean (True/False)

Ensures consistent dating of invoice records.

Locations for stock (comma separated)

A comma-separated list of location codes in Microsoft Business Central from which stock should be synchronized.

String (e.g., "MAIN,WAREHOUSE2")

Filters stock synchronization by specific locations.

Only use stock from locations

If enabled, only stock quantities from the locations specified in "Locations for stock" will be considered.

Boolean (True/False)

Restricts stock data to defined locations.

Add Price Lists To Item Categories

This setting, when configured, is used to associate specific price lists with item categories. This allows for category-specific pricing rules.

String (e.g., JSON or comma-separated list of price list and category pairings)

Influences how pricing is applied to items based on their category.

Order statuses for backorders call (comma separated)

A comma-separated list of order statuses that are considered when retrieving backorders from Microsoft Business Central.

String (e.g., "PENDING,PARTIAL")

Filters backorder retrieval based on status.

Update contact information on Customer update call

When enabled, contact information will be updated in Microsoft Business Central during customer update calls from App4Sales.

Boolean (True/False)

Ensures contact details are kept current.

On premise Business Central installation

Indicates whether the Microsoft Business Central installation is on-premise.

Boolean (True/False)

Influences connection parameters and API usage.

Prefix for credit memo invoices

Defines a prefix to be used for credit memo invoices generated in Microsoft Business Central.

String

Used for consistent naming of credit memos.

Use priceList line prices during sync

When enabled, price list line prices from Microsoft Business Central will be used during synchronization.

Boolean (True/False)

Ensures accurate pricing based on defined price lists.

Send sales order source as reason code

If enabled, the source of a sales order (e.g., "Webshop", "App4Sales") will be sent as a reason code to Microsoft Business Central.

Boolean (True/False)

Provides additional context for sales orders.

Sales order (default) reason code

Specifies the default reason code to be used for sales orders when no specific source reason code is available.

String (reason code)

Provides a fallback reason code for sales orders.

Sales order Portal4Sales Pro reason code

Defines the reason code to be used for sales orders originating from Portal4Sales Pro.

String (reason code)

Categorizes sales orders by their source.

Sales order ChannelEngine reason code

Specifies the reason code for sales orders that originate from ChannelEngine.

String (reason code)

Categorizes sales orders by their source.

SyncTrackAndTraceCodeFromShippingUnit

When enabled, the track and trace code will be synchronized from the shipping unit.

Boolean (True/False)

Enables tracking information transfer.

Customer price group code for Item UOM

Specifies the customer price group code used in conjunction with the item's Unit of Measure (UOM).

String (price group code)

Influences pricing based on customer and UOM.

Send the order note to MBC

If enabled, the order note from App4Sales will be sent to Microsoft Business Central.

Boolean (True/False)

Transfers additional order information.

Use Item information table for additional item info (Customer specific)

Activates the use of a dedicated Item Information table in Microsoft Business Central for storing customer-specific additional item details.

Boolean (True/False)

Enables more granular item information per customer.

Use fax field (if not empty) from BC as customer email

If the fax field in Microsoft Business Central is not empty, its value will be used as the customer's email address in App4Sales.

Boolean (True/False)

Provides a fallback for customer email.

Start sales header lines numeration from

Sets the starting number for sales header line numeration in Microsoft Business Central.

Integer (e.g., 10000)

Controls the sequencing of sales order lines.

Use PST_ItemAttributeValue table for item attributes (Customer specific)

Enables the use of the PST_ItemAttributeValue table for customer-specific item attributes.

Boolean (True/False)

Allows for custom item attributes per customer.

Use custom endpoint for sales lines search

Activates the use of a custom endpoint for searching sales lines in Microsoft Business Central.

Boolean (True/False)

Provides flexibility in sales line retrieval.

Get companies API route

Specifies the API route to retrieve company information from Microsoft Business Central.

String (API route)

Used for fetching available companies.

Item boolean custom field for sync flag

Defines a custom boolean field in Microsoft Business Central that serves as a synchronization flag for items.

String (field name)

Items are synced based on the state of this flag.

Use payment terms as payment conditions

Maps payment terms from Microsoft Business Central to payment conditions in App4Sales.

Boolean (True/False)

Ensures consistent payment agreement representation.

Include archived orders in history

When enabled, archived orders from Microsoft Business Central will be included in the order history displayed in App4Sales.

Boolean (True/False)

Provides a comprehensive view of past orders.

Use Expected Receipt Date as Next delivery date

Utilizes the "Expected Receipt Date" from Microsoft Business Central as the "Next delivery date" in App4Sales.

Boolean (True/False)

Provides accurate future delivery estimates.

NL customer default Gen. Bus. Posting Group

Specifies the default General Business Posting Group for Dutch (NL) customers.

String (posting group code)

Used for financial postings specific to Dutch customers.

EU customer default Gen. Bus. Posting Group

Defines the default General Business Posting Group for EU customers.

String (posting group code)

Used for financial postings specific to EU customers.

NL customer default Customer Posting Group

Specifies the default Customer Posting Group for Dutch (NL) customers.

String (posting group code)

Used for customer-specific financial postings.

EU customer default Customer Posting Group

Defines the default Customer Posting Group for EU customers.

String (posting group code)

Used for customer-specific financial postings.

Customer default Payment terms code

Specifies the default payment terms code for customers.

String (payment terms code)

Sets standard payment expectations for new customers.

NL customer default Reminder Terms Code

Defines the default reminder terms code for Dutch (NL) customers.

String (reminder terms code)

Used for setting payment reminder policies.

Not NL customer default Reminder Terms Code

Specifies the default reminder terms code for non-Dutch customers.

String (reminder terms code)

Used for setting payment reminder policies for international customers.

Customer default Location code

Defines the default location code for customers.

String (location code)

Associates customers with a primary location.

Ignore customer price group when create customer

When enabled, the customer price group from Microsoft Business Central will be ignored when creating new customers in App4Sales.

Boolean (True/False)

Allows for App4Sales to determine the price group independently.

Send order note as sales comment line

Sends the order note from App4Sales as a sales comment line in Microsoft Business Central.

Boolean (True/False)

Transfers textual order information as a comment.

Use API v2.0 (for now only for the sales orders/quotations and lines)

Enables the use of API version 2.0 for sales orders, quotations, and their respective lines.

Boolean (True/False)

Leverages newer API functionalities for specific order types.

Ignore posting date filtration during Invoice History sync

If enabled, posting date filtration will be ignored during the synchronization of invoice history.

Boolean (True/False)

Retrieves all invoice history regardless of posting date.

Use only purchase lines where item stock greater than reserved

When enabled, only purchase lines where the item's stock is greater than the reserved quantity will be used.

Boolean (True/False)

Filters purchase lines based on available stock.

Map order notes to order work description

Maps order notes from App4Sales to the order work description field in Microsoft Business Central.

Boolean (True/False)

Transfers order notes to a different descriptive field.

Subtract reserved from purchase lines

When enabled, reserved quantities will be subtracted from purchase lines.

Boolean (True/False)

Adjusts purchase quantities based on reservations.

Location for return orders

Specifies the location code in Microsoft Business Central to be used for return orders.

String (location code)

Routes return orders to a designated location.

Adjust ordered items amount with package size

When enabled, the ordered items amount will be adjusted based on the item's package size.

Boolean (True/False)

Ensures order quantities align with packaging.

Only send manual discount and when there is no manual discount, send the changed unit price

This setting, originally implemented for a specific customer (KosterFiskarn), controls how discounts and unit prices are sent to the back office. If a manual discount is present, only that discount is sent. If no manual discount exists, the changed unit price is sent instead.

Boolean (True/False)

Custom logic for handling discount and unit price transmission.

Add order line instruction to the order item description

When enabled, order line instructions from App4Sales will be appended to the order item description in Microsoft Business Central.

Boolean (True/False)

Enriches item descriptions with specific instructions.

Value of the type for companies for during the contact synchronization (default: Company)

Defines the value used for the 'type' field when synchronizing company contacts (e.g., "Company").

String (e.g., "Company"). Default: Company

Ensures consistent categorization of company contacts.

Retrieve Warehouse Receipt Headers for stocking (instead of Purchase Headers)

When enabled, warehouse receipt headers will be used for stocking information instead of purchase headers.

Boolean (True/False)

Changes the source of stock data.

Use the Warehouse Activities, Put Away, for stocking

Activates the use of Warehouse Activities, specifically "Put Away," for determining stocking information.

Boolean (True/False)

Utilizes specific warehouse processes for stock updates.

Don't send the (main)contactpersonId on the salesOrders

If enabled, the contact person ID will not be sent with sales orders to Microsoft Business Central.

Boolean (True/False)

Controls the inclusion of contact person data with orders.

Allow partial shipping on orders

Enables the functionality for partial shipping on orders.

Boolean (True/False)

Allows for orders to be shipped in multiple consignments.

Enable item variant support

Activates support for item variants in App4Sales, allowing for synchronization and management of items with variations (e.g., size, color).

Boolean (True/False)

Enables more detailed item management.

Calculate webshop discount over lines

When enabled, webshop discounts will be calculated across individual order lines rather than the entire order.

Boolean (True/False)

Affects how webshop discounts are applied.

ExtraItemExpandProperties

Specifies additional properties to expand when retrieving item information. This can be used to fetch related data that is not included by default.

String (comma-separated list of properties)

Enables fetching more comprehensive item details.