Fields moved from table 15 after SQL upgrade ?

wester
wester 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

  • DenSter
    DenSter Member Posts: 8,307
    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.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • kriki
    kriki Member, Moderator Posts: 9,121
    [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!

Categories