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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
