Community Question
What are FlowFields in Business Central?
Share knowledge. Learn from experts. Build together.
Question
FlowFields in Microsoft Dynamics 365 Business Central are calculated fields whose values are dynamically calculated when they are accessed, rather than being stored as ordinary database values. They are commonly used to display aggregated or related information such as totals, balances, quantities, and counts.
For example, a FlowField can calculate the total outstanding amount for a customer based on related ledger entries. The calculation is defined using AL and a CalcFormula, allowing Business Central to derive the value from related records.
FlowFields are useful because they allow applications to present meaningful calculated information without physically storing every calculated result.
Answers
FlowFields are virtual fields in Business Central that calculate values dynamically instead of storing them physically in the database.
Examples include:
Customer Balance
Total Sales
Inventory Availability
Outstanding Orders
FlowFields improve database efficiency because values are calculated only when requested. Developers define FlowFields using CalcFormula in AL, enabling real-time business calculations without increasing storage requirements.
Your Answer
Login required
Please login to participate in this discussion
and post your answer.