While importing data into FS365 I've come across a quandary.
For all of my customer accounts I want to import the account address as a functional location.
HOWEVER, I don't see how what table that relationship is stored.
I can create the Functional Location records (and of course the Account records)...but I don't see where to store the Functional Location connected to the Account.
Hi crham,
Account and Functional Location have a N:N Relationship. Their relationship table name is msdyn_msdyn_functionallocation_accountset(Relationship Name + 'set'):
Relationship table is invisible and you could use Manage NN relationships tool in the XrmToolBox to add their relationship.
Please refer to this thread, there are steps on how to import N:N relationships.
community.dynamics.com/.../1198651
Worked perfectly.
NOTE: The referenced thread mentioned using semicolon for the delimiter but I got errors so switched back to comma and it worked like a charm.
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.
MVP-Daniyal Khaleel 67
Tom_Gioielli 24 Super User 2025 Season 2
mk1329 16
