Vendor No. in Vendor Master Table become NULL

verdiyau
verdiyau Member Posts: 2
edited 2008-09-01 in NAV/Navision Classic Client
Hi All,

I got a strange problem that the No. field of Vendor Master Table (which is the primary key) became NULL. We are using NAV4.0SP2 with MS SQL 2003 DB server.

It is really weird... As I guess it would be some crash to the DB server when modifying the record... Because the Vendor No. initially having a value... That the only thing i guess would be some crash of the system..

Would anyone help to fix such a problem? Because simply RENAME the record would returns error.... But the Vendor record have corresponding Vendor Ledger Entry.... Otherwise it would be a nightmare to fixed manually one every relative tables...

Thanks very much~

Comments

  • ara3n
    ara3n Member Posts: 9,258
    By NULL, you are probably saying it's blank. Empty value.

    I suggest to call you NSC who will delete the vendor without running the ondelete trigger.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Stardust77
    Stardust77 Member Posts: 95
    Verdiyau, did you mean that all the Vendors in the Table 23 are having a blank No., or is there only one specific vendor that has this issue? :?

Categories