Name of department and account group values of a department.

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

Parents Reply Children
No Data