Get your business online with free website builder (en)

FlowField in Dynamics 365 BC

FlowField in Dynamics 365:

(1) “FlowField” is used mainly for the calculation of data from other table fields based on the conditions applied on it. Data is displayed in these fields at runtime only. It increases the performance in activities such as calculating balance, count no. of records etc.

(2) FlowField Type: There are seven types of FlowField in D365 BC.

  • SUM: Field type must be Decimal, Integer, BigInteger and Duration. It is used when we calculate sum of a specific set in column in a table. In the below example, FlowField calculate runtime inventory in Item Master from Item Ledger Entry.
Sum FlowField in Business Central
  • AVERAGE: Field type must be Decimal, Integer, BigInteger and Duration. It is used when we calculate average of a specific set in column in a table. In the below example, FlowField calculate runtime inventory in Item Master from Item Ledger Entry.
average flow field in business central
  • EXIST: Field type must be Boolean. Indicates whether any records exist in a specified set in a table. Below example find that the item in item list is exist in item ledger entry or not.
exist flow field in business central
  • COUNT: Field type must be Integer. Number of records exist in a specified set in a table. Below example find that the count of item in item ledger entry or not.
count flow field in business central
  • MIN: Field type must be Any. The minimum value in a column in a specified set in a table. Below example find the Min. quantity of item in item ledger entry.
min flow filed in business central
  • MAX: Field type must be Any. The maximum value in a column in a specified set in a table. Below example find the Max. quantity of item in item ledger entry.
max flow filed in business central
  • LOOKUP: Field type must be Any. Looks up a value in a column in another table. Below example make lookup field as per defined filters.
lookup flow filed in business central

How to define Custom Object Range in AL in D365 BC
SchemaUpdateMode in AL in launch.json in D365 BC
How to Import EXCEL data in Business Central D365
How to add or show new field in existing Page in D365 BC
AL Control Statements– Microsoft Docs

Leave a Reply