660
Hi,
I have 51 companies in Navision 2018.
I need to change Swift codes BIC for all companies. I think the fastest and efficient way is to update it in SQL.
Kindly advise which table can I do that as I don't find the vendor table in SQL.
Thank you.
Hi Suresh,
I'm doing that change companies to update the swift code in the Vendor Bank account table.. However, I have 51 companies, and I have 6 bank accounts who will update their swift codes at different time of the year.
This is a tedious process in the long run.
In my other ERP systems, I can simply run an update SQL script to do this.
Please advise if you know how.
You could also do in NAV using a Report or codeunit, you just need to loop through all the companies and use the CHANGECOMPANY to update data in all the companies.
The swift code resides in the "Vendor Bank Account" table, I don't believe there is a table 1210 in NAV 2018. The Swift Code does not have any table relationships.
Josh,
Vendors SWIFT Codes are located in Table 1210 (SWIFT Code) and access off the Vendor Bank Account Card in Table 288.
Hope this helps.
Thanks,
Steve
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,564
Super User 2024 Season 2
#2
Martin Dráb
228,651
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (