FlowField and SumIndexField methods
In Chapter 3, Data Types and Table Fields, we discussed SumIndexFields and FlowFields in the context of table, field, and key definition. To recap briefly, SumIndexFields are defined where the table keys are defined. They allow for the very rapid calculation of values in filtered data. In most ERP and accounting software systems, the calculation of group totals, periodic totals, and so on requires time-consuming processing of all the data to be totaled.
The SumIndexField Technology (SIFT) allows a Business Central system to respond almost instantly with totals in any area where the SumIndexField was defined and is maintained. In fact, the use of SIFT totals combined with Business Central’s retention of detailed data supports totally flexible ad hoc queries of the “What were our sales for red widgets between the dates of November 15th through December 24th?” form. The answer is returned almost instantly! SumIndexFields are...
