Sage 300

Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

How to generate Income Summary from GL Financial Reporter for user defined Range of Fiscal Periods

Posted By J-Y over 7 years ago

Sage 300 v2016

GL Financial Reporter (FR)

Is there a way to specify a range of Fiscal Periods that spans between two fiscal years when generating an Income Summary in FR? I have a bank asking an Income Summary from 7/1/2015 through 06/30/16. Coming from Sage PRO, it was easy to specify a user defined range of periods spanning across periods and even Fiscal Year.

TIA

Parents

0 J-Y over 7 years ago

Digging more into the FR functions, looks like I will have to use FR Statement Designer to create a custom Income Summary report and add a new column to compute for =FRAMTA("NETP12PA") where "NETP12PA" is for the previous 6 months and the Fiscal Option parameter is June 2016. Can anyone confirm that "NETTP12PA" will work?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 J-Y over 7 years ago

Digging more into the FR functions, looks like I will have to use FR Statement Designer to create a custom Income Summary report and add a new column to compute for =FRAMTA("NETP12PA") where "NETP12PA" is for the previous 6 months and the Fiscal Option parameter is June 2016. Can anyone confirm that "NETTP12PA" will work?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 J-Y over 7 years ago in reply to J-Y

Typo: Earlier I meant where "NETP12PA" is for the previous 12 months instead of 6 months :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

How to generate Income Summary from GL Financial Reporter for user defined Range of Fiscal Periods

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING