For the current year and up to four previous years the in and outflow is counted from the Relation Management file 146 (default name Status history).
The start date and the end date of the active status trigger the counting. Enter the code of the active status in the selection. More codes are allowed, e.g. ACT1, ACT2.
After choosing the button Update In & Outflow the data is extracted from Mill7 and Excel will open using the In & Outflow template to show the data.
The data sheet consists of three tables. The first one shows for each year per month the totals of clients arrived and clients left.
The table below shows the in and out flow per client per year. The small table on the right show the aggregate of clients in and out for each year.
