Plus Community - for users of ACCPAC & Adagio accounting software

Welcome to the PlusCommunity forums! PlusCommunity is a gathering place for companies running Simply Accounting, ACCPAC Plus, Sage Accpac ERP (ACCPAC Advantage/ACCPAC for Windows), and Adagio Accounting.
New visitors, please click here!

Page 1 of 1 1
Topic Options
#53474 - 03/04/18 12:57 PM FR formula
Mr Mayor
Member


Registered: 04/22/09
Posts: 460
Loc: Zimbabwe
What’s the formula for total budget for the year. I have columns Jan to Dec for expenses and YTD figures that will be compared with YTD budget.

If my report had budget per month I would just add the total budget into YTD budget. Can’t find any FRAMTA formula for YTD budget

Top
#53475 - 03/05/18 01:41 AM Re: FR formula [Re: Mr Mayor]
Ettienne
Member


Registered: 06/28/02
Posts: 3631
Loc: Orlando, Florida USA
It's the same as YTD actual, with a 1 in front.
_________________________
Sage 300 ERP Certified Consultant

Top
#53476 - 03/05/18 02:46 AM Re: FR formula [Re: Ettienne]
Mr Mayor
Member


Registered: 04/22/09
Posts: 460
Loc: Zimbabwe
but why

hahaha

thank you so much

Top
#53478 - 03/05/18 06:38 AM Re: FR formula [Re: Mr Mayor]
Ettienne
Member


Registered: 06/28/02
Posts: 3631
Loc: Orlando, Florida USA
1 = budget set 1,
2 = budget set 2,
...
5 = budget set 5
_________________________
Sage 300 ERP Certified Consultant

Top
#53487 - 03/16/18 01:44 PM Re: FR formula [Re: Ettienne]
Mr Mayor
Member


Registered: 04/22/09
Posts: 460
Loc: Zimbabwe
Back to the same report. Now modified to represent other segments in column form e.g column F (Acsegval02 = USA) column G (Acsegval02 = IOM) etc

My columns A and B
6700:7900 (Acsegval03= 05)
6700: 7900 (Acsegval03= 10)
6700:7900 (Acsegval03= 15)
For the above if I have a D in column D the figures are ok but if I put a T the figures are all identical, thereby meaning they are corrupted somehow. Tried creating a new report and same output.

Is there something wrong with my formulas

Top
#53488 - 03/17/18 12:01 PM Re: FR formula [Re: Mr Mayor]
Mr Mayor
Member


Registered: 04/22/09
Posts: 460
Loc: Zimbabwe
Alternatively a more direct question is I would like to create a report whereby I compare expenses by department(segment 2 of my account) side by side(in column form)

My account number is like
6700-USA-05-HRE
6700-IOM-05-HRE
7000-USA-10-HRE
7000-USA-10-HRE

Column F should be USA, column G should be IOM etc

As of current if I say
6700%% acsegval03 =“05”
7000%% acsegval03 =“10” if in detail the value is correct but totalized the value is identical and wrong

Top
Page 1 of 1 1


Moderator:  Jay Converse 
Hop to: