Vendor No. in Vendor Master Table become NULL

verdiyau

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~

ara3n

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.

Stardust77

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? :?