Sum Index Field Technology(SIFT) in Navision

jaclyn

Whats a use of Sum Index Field Technology(SIFT) In Navision?

Karenh

Years ago, I worked with another accounting software application. The customer, vendor, and item tables all had fields which totalled transactions, such as Balance, YTD Sales, YTD Purchases, Previous Year Sales. During posting, these fields were increased by the transaction amount. Inevitably, something would happen during posting and these fields would not equal the sum of the transaction. So there was a recalc menu item, which would cause all these buckets to be re-populated with the summed transactions.

The NAV way of addressing this is to not have the buckets, but instead to sum the transactions on the fly. SIFT makes it fast so it is practical to do it this way.

The customer table has flowfields, that are the sum of transactions, and can be filtered by flowfilters, so you can get something like YTD Sales for a particular department. No more recalc.

logger

Hi @jaclyn ,
Have you already read https://msdn.microsoft.com/en-us/library/dd301342.aspx ?

jaclyn

Thanks @Karenh and @logger

pferreira

A SumIndexField, basically creates an index on SQL, making it faster to calculate values.
There are a few very interesting information on this from Jörg Stryk on indexing. You can find some on youtube.