Need to print Department name on FR income statement

SOLVED

I am trying to print a departmental income statement from FR in Sage 300 ERP 2014 and need it to print the department name. Here is my scenario:

  • GL Account Structure is xxxx-xxxx with the second segment being the department
  • When running the report, "Report As" is consolidated and cannot be changed
  • At run-time, I am selecting the department that I want
  • Numbers are reporting correctly but the heading will not display the correct description for the department

I am using this formula:

=FRSDESC(2,FR("CurAcSegval02"))

In the report design section, this returns #VALUE! and when I run the report, it displays #N/A

If I modify my formula to =FRSDESC(2,"0301") it will give me the segment description from Sage 300 as expected.

I need to wildcard this value as we have over 300 departments in this database.

Thanks all...