It's very complicated. The program cannot tell the difference when it "wakes up" between a department that the user is not allowed to see, and a department that has been added since the last time it was launched.

The more I have been thinking about this, the more I think the program is doing exactly what it has been asked to do.It is correctly displaying the summary amounts and hiding the details unless specifically told that this is OK.

In Adagio, when you add a new menu item or security controlled feature, the item is disabled for everyone until it is explicitly turned on. I think that has to remain the way it works. Otherwise users may be given access to functions you want to keep private.

But this also means that you have to edit the specs, every time you add a department to your chart - hardly optimal.

Normally when there is this kind of implementation dilemma you resolve the problem with an "option" and let the user decide how it should work. But in this case I think the desired behaviour will change at a single site, depending on the circumstance at the time.

Another approach for the interim would be to dispense with the user department restrictions in FX and set up automated retrieves into separate databases for the individuals involved that only retrieve the departments they are allowed to see. Then you don't have to worry about restrictions in their data since it will only contain departments they are authorized to inspect.