Sage Accpac Financial Reporter Titles Generated 1

[jsh8286]

We have a G/L specification that is exactly what we want for the exception of one thing. They use it to print departmentalized statements and a consolidated statement. When they print department statements all is good since the department being printed the title appears properly at the top of the page (we are using the following formula to get this description):

"=FRDESC(2,FR("CurAcSegVal2"))

The issue and the question is when we print a consolidated statement the resulting title is "N/A" obviously since we did not generate a departmental statement.

Is there a formula that will combine the best of both worlds so that when we print departmental statements we continue to get the department description and when we print consolidated we get the word "Consolidated" as opposed to "N/A" when printed?

Thanks in advance for any information posted.

 

[ettienne]

=IF(FR("ReportAs")="Consolidated","Consolidated",FRDESC(2,FR("CurAcSegVal2")))

 

[jsh8286]

Thanks Ettienne! Much appreciated.