I am new to Sage300 so i'll apologies in advance. I am trying 2 things to work on sage300 (2021).
1) I am trying to get department name on FR View dynamically. I have tried following but did not work for me.
=IF(ISNA(IF(FR("ReportAs")="Separate",FRSDESC(2,FR("CurAcSegval2")),"Consolidated")),"",IF(FR("ReportAs")="Separate",FRSDESC(2,FR("CurAcSegval2")),"Consolidated"))
2) I just want to display a specific department e.g HR's income statement for specific account group e.g (Salary and Wages).