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.

Financial Reporter - help with formula

Posted By ChristK over 9 years ago

I'm working on a template for 2016 budget. The BOD want 3 columns - 1) Actual 2014, 2) Budget 2015, 3) Budget 2016. I can't figure out what the formula would be to pick up the Actuals for 2014. Any suggestions? I tried =FRAMTA("ABALP.2014"), also =FRAMTA("BALPY").

Thanks, Christine

0 Ettienne Schwagele over 9 years ago

Try

=FRAMTA("BALPY.L1")

.L1 = one year ago
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ettienne Schwagele over 9 years ago in reply to Ettienne Schwagele

Do you want the budget for the whole year for 2014 in one column?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 ChristK over 9 years ago in reply to Ettienne Schwagele

Yes, I'm looking to have the completed year in one column to compare to what we've budgeted. I also tried =FRAMTA("BALPY.L1" and it isn't giving me the whole year either. I'm just getting bits and pieces.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ettienne Schwagele over 9 years ago in reply to ChristK

=FRAMTA("NETY.L1") or

=FRAMTA("BALY.L1")
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 ChristK over 9 years ago in reply to Ettienne Schwagele

=FRAMTA("NETY.L1") appears to have worked. Thanks for the help!!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

Financial Reporter - help with formula

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING