In Sage 300 v2025 the column formula to filter by account segment on GL Financial Report template does not work.
The column formula worked in version 2022. I've rebuilt the formula using FR Paste. In some instances N/A is returned and in other instances, values for all accounts are returned.
Here our samples of the column formulas:
=@FRAMTA("NETYTD","","(ACSEGVAL02 = ""10"") OR (ACSEGVAL02 = ""11"") OR (ACSEGVAL02 = ""12"") OR (ACSEGVAL02 = ""13"") OR (ACSEGVAL02 = ""14"") or (ACSEGVAL02 = ""15"") or (ACSEGVAL02 = ""16"")")
=@FRAMT("NETY","","(ACSEGVAL02 = ""300"")")
