How can I recalculate the display of advances and transitory items in the mandate list?

How can I recalculate the display of advances and transitory items in the mandate list?

This article has been machine translated. If you find any errors, we would be grateful if you could report them to translation@timesensor.com.

Background

In the mandate list you can display various columns which are calculated from linked data. For example, in order to display the date of the last service or the balance of the advances, the corresponding services or invoices must be searched for in the database, the result calculated and then displayed. On fast systems this is not really a problem, but in slower infrastructures or under high load (with many users), the response times for displaying the list can become too long, since the calculation must be made for each individual mandate.

For this reason, redundant totalisation fields are used, i.e. the calculation of the data takes place continuously in the background and the result is written into the totalisation fields directly in the mandate data record. This eliminates the "live" calculation and the display is fast in any case.

Recalculation

It may happen that the automatic calculation could not be completed in the background, e.g. in the event of a system interruption or other malfunction. In this case, if you have administration rights, you can trigger the recalculation manually. This function is somewhat hidden: hold down the Alt/Option key and click on the calculator icon at the bottom of the mandate list.