FlowField SumIndexField functions

In Chapter 3, Data Types and Fields, we discussed SumIndexFields and FlowFields in the context of table, field, and key definition. To recap briefly, SumIndexFields are defined in the screen where table keys are defined. They allow very rapid calculation of values in filtered data. In most ERP and accounting software systems, the calculation of group totals, periodic totals and such, require reading all of the data to be totaled.

SIFT allows a NAV system to respond almost instantly with totals in any area where the SumIndexField was defined. In fact, use of SIFT totals combined with NAV's retention of detailed data supports totally flexible ad hoc queries of the form "What were our sales for red widgets between November, 15 and December, 24?" And the answer is returned almost instantly! SumIndexFields are the basis of FlowFields which have a Method of Sum or Average; such a FlowField must refer to a data element that is defined as a SumIndexField.

When we...