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.
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
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.
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.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Rishabh Kanaskar 4,255
Sumit Singh 2,665
Nimsara Jayathilaka. 2,401
