Options

Fields moved from table 15 after SQL upgrade ?

westerwester Member Posts: 33
edited 2007-05-17 in SQL General
I've just runtime-upgraded a Navision 3.60 Native database to Navision 4.02 SQL. Looking in table 15 in Navision everything seems ok, but when I look in exact the same table in the Enterprise Manager i miss the fields: "Net Change" and "Balance at Date". These fields are both flow fields, but I don't know if it has anything to do with this?! Where are these fields located in the SQL tables, and why are they not placed in table 15 where they belong?

Comments

  • Options
    DenSterDenSter Member Posts: 8,304
    They're not fields, they're flowfields, they are calculated values. As such, they don't belong in table 15, they are calculated along the way inside the NAV process.

    Please consider going to SP3 executables, MSFT has addressed some security issues and enhanced some database options.
  • Options
    krikikriki Member, Moderator Posts: 9,090
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.