There is a feature in Adagio FX that allows a site to retrieve a subset of the G/L into a separate data folder. This is useful in cases like yours where you want individual departments to have access to their Financial data without have access to the G/L.

This feature will be fully documented in next release of FX.

In order to use this feature you need to edit the AFWININI.??? file in the FX data folder and add specific entries to the [Retrieve?]section.

An example would be:

[Retrieve1]
Database="F:\Data\ProductionData\GLGLOB.DAT"
UserID="SYS"
Password="SYS"
SelectedDepartments=100,200,800
AppendData=0
UseExistingBudget=0
RetrieveAllYears=1

Your FX Shortcut requires a /R

So a FX shortcut of
F:\Softrak\FX\FX.EXE /USYS /PSYS /dC:\Data\Ton\FX /EAFX /R

would open the FX data located at C:\Data\Ton\FX, read the AFWININI.AFX file, and then retrieve Departments 100, 200 and 800 from the G/L located at F:\Data\ProductionData

Generally a "scheduled task" would be used to perform the retrieve after hours so that the Department would have current data as of yesterday's closing.