Data showing in sql is not same in NAV table


Actually I am deleting one row of data from Item Cross Reference table(NAV 2013r2), but when I close and reopen it data is showing again.

So I checked in database from sql server (sql 2014 standard), I noticed it was deleted, But in Nav table it is showing.

Can anybody suggest any solution regarding this

Thanks in advance.

I guess that you have two databases - one that you have deleted data in and one used by your NAV…?

Check any customization done for populating data in the table