I'd like to have adagio insert the dept code into the title of the financial statement. I imported a generic statement that I made in accpac plus, all works fine except it seems adagio will not read the \DEPT code function. \DNAM and \DATE all work fine. I've searched help and can't find adagio equivalent to inserting the dept code. Your assistance would be much appreciated. THX

Hi Kevin,

Is your Financial Statement consolidated or departmentalized? If the globe toolbar button is selected at the top of the screen (to indicate a consolidated statement), then the department field will not display, because it doesn't really have meaning. If you do not have the consolidate option active, that means the department field immediately to the right will be active. Whatever department is selected in this drop-down box will display in the cell for the department.

In case you wanted to verify the syntax for the Department field in the cell, it is:

=ADGET("GLDATA.DEPT",X)

where X is the acct-dept key. It could be hardcoded (ie "4000-100"), linked to the toolbar (ie "4000-`"), part of a range of accounts (ie "4000:4999-`"), or a cell reference (ie $A22).

Regards,
Softrak Support

Cross referenced to the manual, found this function =DEPARTMENT(0), all is working okay, thanks for the assistance..