Account schedule

Hello,

I have created an account schedule which has 36 rows. I want to total 30 rows, however when I enter the formula 4+5+6+7+8+9+10+11+12+13+14+15+16+17+18+19+20+21+22+23+24+25+26+27+28+29+30+31+32+33+34+35 in the totaling field, I get the error message “the maximum length for string is 80”.

Is there a way to sum the 30 rows? I am using Navision 2009.

Any help will be much appreciated.

Thank you,

Teena

you can try global variables. like

gVariable1 ,gVariable3,gVariable2, total as decimal

gVariable1 := 1+2+3+4+5+6+7+8+9+10+11+12;

gVariable2:= 13+14+15+16+17+18+19+20+21+22;

gVariable3 := 23+24+25+26+27+28+29+30+31+32+33+34+35+36;

NOW

gTotal := gVariable1+gVariable2+gVariable3;

try whether this helps.

Can we do that in RTC? When I edit the account schedule I don’t see where I can create a global variable.

Hi, Teena

You should be able to enter a formula like this: 1…35

This includes any value between 1 and 35. If you want to exclude some accounts in between, say 21 and 22 you may write: 1…20|23…35

I tried but I get an error message, it says something like you have entered an illegal value

Where are you trying to enter it? I was talking about form 104, field Totaling… did I misunderstand your question?

4062.untitled.bmp (3 MB)

please see picture

Did you change the Totaling type into Total?

I changed the totaling type to total accounts. I do not get any error message but I do not get any totals. The columns are blanks.

In your chart of accounts have a totoal account, then just call it on the account schedule as a total account. No need for all of your hidden lines then. Construct the COA well and the Account schedules are easier to construct.

If I do that, the new chart of accounts will appear on my reports. How do I avoid them from appearing on my reports?

Well you would not print total accounts, which kind of defeats the object - why do you not want to show the total accounts?

The totals I am creating is for my income statement report. I have to design the report according to the client format.

The design you have shown in the screenshot shows you hiding the details on the report and just printing the total. If you had a total report doing this it would be easy. Whilst you have to design the report you also have to tell the client the best way to utilise the software.