Announcements
No record found.
In case i change vendor no in vendor card it will change in all tables automaticlly or i have to change it manually in each table
*This post is locked for comments
It will change. it uses the table relations to find the other tables.
Good afternoon. Yes, as long as you are changing the vendor name when you are directly in NAV client...it will update the vendor card along with any associated tables storing the information(i.e. Vendor Ledger Entry, Detailed Vendor Ledg. Entry etc...). This would be the same for any other master card such as Customer or Item.
Just to verify, when you state "in case I change the vendor no in the vendor card" are you doing this within the NAV client or are you doing this in say the SQL Server? Reason I ask is that through the SQL Server if you are just updating the vendor card table, that is not going to update any other tables for this as there are not any triggers for this through SQL. Also another concern is that you would run SQL Profiler or code coverage in NAV to see what all is updated if you update it through NAV directly, but there may be companion tables that are not showing in the profiler(such as a setting of some sort)...so you would have to be careful if you are doing any changes outside of the NAV client itself...mainly best is to do it directly in NAV client.
thanks,
Jill
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
