Functional Location

(0) Share

Report

Posted on by crham

390

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.

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Community Member on at

Like (2)

Report

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

Was this reply helpful? Yes No
crham 390 on at

Like (0)

Report

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.

Was this reply helpful? Yes No