Book demo

Outgoing Inventory to External Systems

AI Doc Summarizer Doc Summary
Table of contents

⚠️ Important #

Changes to Web Connect in a production environment are sensitive and may cause integrations to stop working if configured incorrectly. We strongly recommend testing all changes in a test/sandbox environment first.
If you are unsure, contact us before making changes.

This guide describes how to calculate and send web inventory from Microsoft Business Central to an external system using Web Connect.

The setup is based on:

  • A calculated inventory value (Dynamic FlowField)
  • Explicit relations between Business Central tables
  • Triggers that control when inventory updates are sent
  • Full result of inventory being sent found in Web Connect Item Inventory (LÄNK)

Prerequisites – Web Object Mapping #

A Web Connect Object must exist and be mapped to the external system.
This object represents the item or inventory entity that will be sent out.

All inventory values calculated later will be sent through this object.

Calculate Web Inventory using Dynamic FlowField #

To calculate web inventory, a Web Connect Dynamic FlowField is created and used in Web Connect Item Inventory.

Standard calculation logic #

The most common logic for web inventory is:

Inventory
– Quantity on Sales Order Line
– Quantity on Transfer Order Line

All values used in this calculation are based on standard Business Central table 27 (Item) and related tables.

Define Table Relations for Inventory Calculation #

To allow Web Connect to calculate this logic correctly a Web Connect Table Filter/Relation (LÄNK) must be configured.

This relation connects:

  • Item
  • Sales Line
  • Transfer Line

Location filtering (recommended) #

In most cases, one or more Location Codes are filtered to control which warehouse stock is included in the calculation. This is added as filter string as shown in above image (line no 2).

This ensures that only inventory from relevant locations is sent to the external system.

Configure Web Connect Destinations #

Next, configure Web Connect Destinations to define what data is sent to the external system.

In this view you select:

  • The Dynamic FlowField used for Web Inventory
  • Optional: Calculate Next Available Date

Next Available Date (optional) #

If enabled, Web Connect calculates the next date when the item becomes available by considering:

  • Purchase Orders and expected receipt dates
  • Sales Orders and required shipment dates
  • Transfer Orders and transfer dates

This value can be sent together with inventory to the external system.

Configure Outgoing Sync Triggers #

To control when inventory updates are sent, configure Web Connect Outgoing Sync Triggers.

Main trigger (Item level) #

Start by creating the main trigger rule.

Recommended settings:

  • Trigger by Object: Item (or the object mapped to the external system)
  • Trigger by Table View: Filtered view (e.g. Item Type = WEBB-SE)
  • Trigger on Modify Fields:
    • Web Inventory change

This ensures inventory updates are sent whenever the calculated web inventory changes.

Trigger on Sales Order changes #

Inventory must also be recalculated when Sales Orders change.

Add a new trigger row:

Settings:

  • Trigger by Object: Sales Line
  • Relation: INVENTORY-SALESLINE
  • Trigger on Modify Fields:
    • No.
    • Quantity

Trigger on Transfer Order changes #

Inventory must also be recalculated when Transfer Orders change.

Add another trigger row:

Settings:

  • Trigger by Object: Transfer Line
  • Relation: INVENTORY-TRANSFERLINE
  • Trigger on Modify Fields:
    • No.
    • Quantity

Summary #

To send web inventory to an external system:

  1. Map an object to the external system
  2. Create a Dynamic FlowField to calculate web inventory
  3. Define table relations for Item, Sales Line and Transfer Line
  4. Configure Web Connect Destinations
  5. Set up Outgoing Sync Triggers for:
    • Item changes
    • Sales Order changes
    • Transfer Order changes

This ensures that inventory and next available date are always accurate and automatically synchronized.

Scroll to Top