Account Schedule - Circular References

annie1234
annie1234 Member Posts: 27
edited 2009-05-13 in NAV/Navision Classic Client
Hi all,

May any expert can help how to sort out this issue, this is an error message popping up in the Account Schedule.

"Because of circular references, the program cannot calculate a formula.
The error occured when the program tried to calculate
Acc. Sched. Line: Row No.=PBT, Line No.=780000, Totaling=EBIT+71+72+73+74+75+76+77+78
Acc. Sched. Column: Column No.=1, Line No.=10000, Formula="

THX
Annie

Comments

  • ara3n
    ara3n Member Posts: 9,258
    I suggest to set all the RowNo with a prefix of R

    So that formular won't get confused. Also Make sure 71+72+73+74+75+76+77+78 do not reference themselves.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • pmusu
    pmusu Member Posts: 55
    Use a maximum of 3 totals.
    Name it E.G. EBITA 71+72+73
    EBITB 74+75+76
    ...

    Hope it helps.

    annie1234 wrote:
    Hi all,

    May any expert can help how to sort out this issue, this is an error message popping up in the Account Schedule.

    "Because of circular references, the program cannot calculate a formula.
    The error occured when the program tried to calculate
    Acc. Sched. Line: Row No.=PBT, Line No.=780000, Totaling=EBIT+71+72+73+74+75+76+77+78
    Acc. Sched. Column: Column No.=1, Line No.=10000, Formula="

    THX
    Annie

Categories