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.

Budget Vs Actual Report - Financial Reporter

Posted By Muhammad Mughal 10 months ago

Hello , i am running the Budget vs actual report on financial reporter.
our fiscal period is April to march but when i run the report lets say on December it shows budget only up to December, is there a way i can run the reports any months and it compares actuals up to December vs with total annual budget.

thanks very much

0 Django 10 months ago

One way is to make use of the PA formulas:

=@FRAMTA("NET1PA")

This will give you the value from 1 period ago. NET2PA will give you the value from 2 periods ago. This will allow you to build a financial report with period columns that are relative to the period that you're generating the financial report for.
Cancel
Vote Up 0 Vote Down

Reply

Verify Answer

Cancel
0 Terry Gair 10 months ago

What about using 1BALY to give you the total for the year for the budget set if you are looking for the current year budget total.
Cancel
Vote Up 0 Vote Down

Reply

Verify Answer

Cancel

Sage 300

Budget Vs Actual Report - Financial Reporter

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING