Doc Summary 
Swedish Business Central view name: Web Connect Dynamic Flow Fields
Web Connect Dynamic Flow Fields are used to calculate or construct values in Microsoft Business Central that are not simple field mappings.
They allow you to build dynamic values based on Business Central data, relationships, and logic — and then use those values in outgoing or incoming Web Connect processes.
Purpose #
Dynamic Flow Fields are commonly used to:
- Calculate available inventory to send to eCommerce or POS systems
- Build tracking URLs by combining carrier links with shipment data
- Derive values that do not exist directly on a record
(for example, EAN codes from Item References) - Aggregate or transform data before it is sent to an external system
Unlike mappings, Dynamic Flow Fields do not write data back to Business Central — they calculate values that can be consumed by Web Connect.
Dynamic Flow Field header #
Each Dynamic Flow Field starts with a header definition.
| Field | Description |
|---|---|
| Code | Unique identifier for the Dynamic Flow Field. |
| Description | User-friendly description explaining what the field calculates. |
| Fixed Value | Optional fixed value. Typically left blank. |
| Table Name | The table context where the calculation starts (same as Web Object table). |
| Table No. | Table number corresponding to the Table Name. |
| Field Type | The result type of the calculation. Supported types include Text, Date, DateTime, Integer, Decimal, Boolean. |
Flowfield lines (calculation logic) #
The Flowfield Lines define how the value is calculated.
Each line represents one part of the calculation.
| Field | Description |
|---|---|
| Entry no | In which order should the calculation take place. |
| Header Object | Same table context as defined in the header. |
| Condition Code | Optional condition that must be fulfilled for the line to be calculated. See Web Connect Condition List. |
| Flow Calculation | Defines how the value is applied: Plus, Minus, Multiply, Divide. |
| Relation Code | Defines how to relate data from another table. Required when the value does not exist on the header table. See Web Connect Table Filter/Relation. (LÄNK) |
| Table Key | Key used to retrieve records. 0 = Primary Key (default). |
| Table No. | Table number of the related data source. |
| Field No. | Field number of the related value to retrieve. |
| Dynamic Flow Field | Allows chaining another Dynamic Flow Field instead of a direct field. |
| Field Calculation | Lookup logic used on the related data. Supported values: Lookup, Lookup (Last), Sum, Count, Exists. |
| Field Name | Display name of the related field (informational). |
Common examples #
A very common use case for Web Connect Dynamic Flow Fields is to calculate the available inventory that should be sent to an external system such as an e-commerce platform, POS, or marketplace.
Instead of mapping a single field, the available inventory is calculated dynamically based on multiple values in Microsoft Business Central.
Example A – Available Inventory (Web Inventory)
#
Purpose #
Calculate how much inventory is actually available for sale by subtracting outstanding demand from the physical inventory.
Header setup #
The Dynamic Flow Field is created on the Web Connect Item Inventory object.
Example configuration:
- Code: INVENTORY
- Description: Calculate inventory to site
- Table Name: WCM Item Inventory
- Field Type: Decimal
This defines where the calculated value will be used.
Flow Field Lines (Calculation Logic) #
The actual calculation is defined in Flow Field Lines.
In this example, the following logic is used:
Available Inventory =
Inventory
– Quantity on Sales Orders
– Quantity on Transfer Orders
Each row represents one calculation step.
| Flow Calculation | Source Table | Field | Description |
|---|---|---|---|
| Add (+) | Item (Table 27) | Inventory | Physical inventory in Business Central |
| Subtract (–) | Item (Table 27) | Qty. on Sales Orders | Reserved quantity on sales orders |
| Subtract (–) | Item (Table 27) | Qty. on Transfer Orders | Quantity reserved for transfers |
A Relation Code (e.g. ITEM-WEBBINVENTORY) is used to link the Web Connect Item Inventory object to the Item table, since the inventory values do not exist directly on the Web Connect table.
Result #
The calculated value is stored as Web Inventory and can be used by:
- Web Connect Destinations
- Outgoing inventory messages
- External systems (web, POS, marketplace, etc.)
The value is recalculated automatically when underlying data changes, based on configured Outgoing Sync Triggers.
Example B – Tracking URL generation #
- Base URL from shipping agent setup
- Combined with Package or Tracking Number from Shipment Header
Example C – Variant EAN resolution #
- Lookup EAN from Item Reference table
- Returned dynamically per Item Variant
Where Dynamic Flow Fields are used #
Dynamic Flow Fields can be referenced in:
- Web Connect Destinations
- Web Connect Outgoing Data
- Web Connect Objects
- Inventory and price calculations
- Custom outbound payload structures