Financial Reporter FRFISCAL prior years

Question

I have a report that is pulling info for each my end of years. the .L1, etc works for every year when I use it with BALP, but it only works to L9 when using it with FRFISCAL. My formula is =@FRFISCAL("END","L9"). When I change the 9 to 10 I get the fiscal year end for L1. 
 Is there a way to get my fiscal year ends for all years needed?

Shane - Ascend Business Solutions · Accepted Answer

You should be able to test the formula by trying variations of" =FRFISCAL("End","2010") or 
 =FRFISCAL("End","2015") Also, ensure you're clicking the F9 or FR View to set the current year / period

Stephen Bagnall · Answer

I believe that it is limited to values 1 to 9 as you have discovered. Seems a fair limitation. I've never come across anyone wanting to go back 10 years in a financial report. Interesting that you have the requirement.

Sage 300

Financial Reporter FRFISCAL prior years

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING