web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Choosing the correct integration method

(1) ShareShare
ReportReport
Posted on by 398
Hi,
 
When an external system creates a vendor, we want to create it in FO as well
 
When the vendor is created in the external system, we want to create it in the 8 different legal entities in FO (same number sequence)
 
We also need to create the same VAT num in 8 different legal entities ( we need to create this first before creating the vendor)
 
We also need to create postal addresses for those 8 vendors
 
We also need to create contacts for those 8 vendors
 
We also need to create bank accounts for those 8 vendors, then update the 8 vendors with those bank accounts
 
 
I think we are expecting maybe 10 vendors per day max (so each vendor of those 10, needs to be created in 8 different legal entities) so we might end up with 80 vendors in FO
 
Would odata be good option?
 
So when the first vendor gets created in the external system
 
We can use /data/$batch to create the vat num in 8 different legal entities
 
Then also use odata batch to create the vendor in 8 different legal entities
 
And create the postal address, contacts, bank accounts as well in 8 different legal entities
 
Then update the vendors with the bank account
 
1. Would it affect performance to use odata or what would be a better option to use? 
 
2. And if it's just 10 vendors per day (but still we need to do lots of calls for each vendor) would odata be an option even if data is not required in real time?
 
3.What integration method will u use if the data is required in real time?
 
4. And what integration method will u choose if it's ok to create all of those 10 vendors data at the end of each day (Not real time)
 
5. If we are expecting 5 vendors per day instead of 10, would your answers for the 4 questions above change?
Categories:
I have the same question (0)
  • DELDYN Profile Picture
    398 on at
    Choosing the correct integration method
    Hi neeraj,
     
    Thank you. I think i need to investigate the links you sent me to see how it will help me and if it meets my requirement.
     
    But two quick questions about the solution you suggested:
     
    How can i only enable this feature only if it's coming from a certain thing.
    So i mean manually when i create a vendor, i don't want to create it in different legal entities
    Or if another external system wants to create a vendor, then also i don't want to duplicate.
    It's only if that specific external system does the integration, then i want to duplicate records. Can we do that?
     
     
    The 2nd question is, the data sharing has limitation for 2 millions.
    So if let's say after 20 years we ended up with 2 million vendors created by that external system. Does that mean we can't use this feature anymore to duplicate records in different legal entities?
  • Suggested answer
    CA Neeraj Kumar Profile Picture
    1,341 on at
    Choosing the correct integration method
    Hi @DELDYN,
     
    Not from Integration perspective but from functional aspect, i would like to share my thoughts, 
     
    as you need same vendor  (including address, VAT num, contacts, bank accounts etc) to be created parallely in 8 legal entities. Please use the standard functionality of Cross Company Data sharing in D365 FO:
    Some video/articles for your reference:
     
     
     
     

    So, if you are able to sucessfully use this functionality, then through integration, you need to create vendor in only 1 legal entity and it will be automatically shared in all the other entities (based on configuration).
     
    Now, you need to create only 10 vendors a day in one legal entity, so you can utilize OData also in this case. It shouldn't create any issue related to performance.
     
    If this answer helps you, please consider marking this as "Verified".
     
    Regards,
    Neeraj Kumar

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 878 User Group Leader

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 855 Super User 2025 Season 2

#3
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 765

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans