I would like to display the department description in one column of the Financial Reporter by referencing the department number which will be located in the adjacent column. Is there a FR function for displaying department names other than Department(1) which shows the currently selected department when the Consolidated icon is unselected?

Thanks,
-Phil

Hello Phil M,

Although not documented (I think), you can get at a department description in the same way that would can get an account desciption. then formula is:

code:

---

=ADGET("gldept.DESC","deptkey")

---

where:

"gldept.DESC" references the department file and requests the description -and-
"deptkey" is a string that contains the department code (or a cell that contains this string value).

If you "drag and drop" a departmental comparative, or take a look at "GL!deptdemo.sam", you'll see how the department name is retrieved from the department code.