Account Schedule Formula Row Summary

Witty
Witty Member Posts: 20
edited 2012-07-12 in NAV/Navision Classic Client
I have an account schedule formula row that needs to total 400 lines. Is there an easier way create a summary instead of entering 1+2+3+4+5+...... I tried to enter 1..400 however this returns an error message when printing the account schedule. Any help is appreciated as this type of data entry is mind numbing.

Comments

  • jglathe
    jglathe Member Posts: 639
    Hi Witty,

    the formula can also do ranges. The problem is that you can encounter cyclic references with this. Usually it's a good idea to give Row Nos to every Account Schedule Line, all with the same length (Row No. is a code field). If you already have totaling lines in the Acc. Schedule, I would suggest to give them a distinct range. This way you can easily specify a totaling range for the "base" lines, or for the totaling lines (depends on what is more apropriate).

    with best regards

    Jens
  • Witty
    Witty Member Posts: 20
    I was able to sum lines 1-400 by giving each line the same row number of "REV" then entering "REV" in the totaling line. This summarized all lines. Thanks for the quick help.

Categories