Hi All,
We are integrating D365 with another Supply Chain software (ISV). The vendor name is the same in both systems. The vendor accounts, however, are different in both systems. Let say my vendor in both systems is Iron Mountain.
In D365, the vendor account is 12345.
In the ISV, the vendor account is 19191919.
So, they are different digits and different numbers. Any suggestion on how I can link these two vendor accounts; because ultimately, they are the same vendor. The goal is, when I paid this vendor in D365, it integrates/updates this payment to the right vendor account in the ISV.
Thanks so much for your feedback.
There are many way to address such requirements for data integration -
1. You can maintain custom field/alternate out of the box field (ex. YourAccountNum)/custom table to store the account number mapped from other system and let integration translate the mapping during the integration.
2. There is also External code feature out of the box for many of such master data such as vendor, customer , product to define external code and that can be further utilized for integration and other processes.
Thanks, JJYadav, for your response. Could you tell me more about the External Code? Yes, it is for integrate D365 with another ISV. Same vendor name and address, but vendor code/vendor number in bother systems are different.
There are many way to address such requirements for data integration -
1. You can maintain custom field/alternate out of the box field (ex. YourAccountNum)/custom table to store the account number mapped from other system and let integration translate the mapping during the integration.
2. There is also External code feature out of the box for many of such master data such as vendor, customer , product to define external code and that can be further utilized for integration and other processes.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,963 Most Valuable Professional
nmaenpaa 101,156