CALCFIELDS in NAV2015

Roelof
Roelof Member Posts: 377
in NAV Three Tier
I have a weird issue. I'm trying to get a value from a calculated field, by using the 'CALCFIELDS' function.
When I run the table I can see the calculated value. But when I use the 'CALCFIELDS' function in a report or CodeUnit it is just not calculating. I ran the debugger and all that and no value. It's zero.
Any ideas what could be the cause?
Roelof de Jonghttp://www.wye.com

Answers

  • rjbeltran
    rjbeltran Member Posts: 7
    You can use CalcFields Property in reports.
  • rjbeltran
    rjbeltran Member Posts: 7
    You have to set certain field to "Flowfield" so you can use calcfields. When you did not set that and you tried to get the value, for sure you will get a zero value.
  • Roelof
    Roelof Member Posts: 377
    Yes, the fields in question are defined as flowfields. That's not the issue.
    The table itself is not part of the report data-items so I can not use the 'calcfield' property'. The table is defined as a global variable.
    This is a very strange behavior. I have used many times calcfields but I've never seen this.
    Roelof de Jonghttp://www.wye.com
  • Roelof
    Roelof Member Posts: 377
    Never mind. I have figured it out. The table wasn't reset in the code properly.
    Roelof de Jonghttp://www.wye.com

Categories