Sage ACCPAC ERP Financial Reporter - Adding a Budget Column

[Piotr99]

Hello,
I'm trying to add an Annual Budget column to an existing report in Sage ACCPAC ERP Financial Reporter but don't know how... can anyone help please?

 

[ettienne]

Add a column, the formula will be 1 prefixed to whatever budget number you are seeking:
=FRAMTA("1NETP") gives you the budget for the current period
=FRAMTA("1NETYTD") gives you the budget for the current year
=FRAMTA("1NETY") gives you the budget for the whole year

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[ettienne]

A shortcut is to copy an existing column and then change the formula to read the budget.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[Piotr99]

I just tried that but the budget column doesn't display any data.
Any other suggestions?

 

[ettienne]

Did you expand the SPEC range to include the new column?

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[Piotr99]

Sorry, I don't know how to do this. Can you please tell me how?

 

[ettienne]

Insert a column to the left of the last column - that automatically expands the named range.
Then take it from there.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[Piotr99]

Unfortunately that didn't work either... any other suggestions?
I appreciate your help.

 

[ettienne]

Dude that works, you did something wrong.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[Piotr99]

I honestly did what you suggested but I'm getting no data... these reports are frustrating!
I don't know what else to do... any other suggestions?

 

[ettienne]

Do it right. I've been writing these reports for 20+ years, what I gave you works.
When you say you're getting no data... what exactly do you mean?
Do you have a budget set in the GL?

Sage 300 ERP Certified Consultant

http://www.adssglobal.net