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...