partyNumber in DirPartyTable

(1) Share

Report

Posted on by ..

1,919

Hi,

could the partyNumber in DirParyTable, be linked to more than one?

i mean could two contactPersons have the same partyNumber?

or could one contactPerson and one Customer have the same partyNumber?

in DirPartyContactV3Entity, is it enough to filter on partyNumber to get contactPerson contact info? or do i need to also join the entity to contactPerson table?

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (0)

Martin Dráb 236,879 Most Valuable Professional on at

Like (0)

Report

partyNumber in DirPartyTable

A party (a person or an organization) being two contact persons at the same time doesn't make sense to me. But a single person can have several roles, such as being a customer and contact person.

What is the information that you want to get from DirPartyContactV3Entity and you failed to find it there?

Was this reply helpful? Yes No
.. 1,919 on at

Like (0)

Report

partyNumber in DirPartyTable

Hi @Martin Dráb,

When you say "a single person can have several roles, such as being a customer and contact person"

Does that mean this person will have one PartyNumber or two party numbers?
how can i create a person and make it both customer and contactPerson in the UI?

Regarding your question "What is the information that you want to get from DirPartyContactV3Entity and you failed to find it there?"
It didn't fail, and i'm looking for electronic address information, but i was thinking if
select *From dirPartyContactV3Entity where dirPartyContactV3Entity.PartyNumber = _partyNumber; is enough?
or do i need to add a join for ContactPerson table?

the answer to this question depends on the answer for the first one, so if u will say that the same person can be customer and contact, and if in this case they will have same party number, then i think it's good to add a join to contactPerson in my select
or will they always have the same electronic address, since they share same party so it doesn't matter?

Was this reply helpful? Yes No
Sohaib Cheema 49,053 User Group Leader on at

Like (0)

Report

partyNumber in DirPartyTable

Hi,

If a party has multiple roles, the base party number remains the same (which comes from the global address book).

For your second question where you asked about the use of DirPartyContactV3Entity; Do you need to join with the otehr table (ContactPerson), the answer depends upon what result do you want. For example if you want to see the name pf the party/contact you need to join to ContactPerson table, as it never saves the name there. Within the entity you can see joined tables like DirParty and DirPerson that can provide you the party name.

Was this reply helpful? Yes No

Join the conversation

Community site session details

partyNumber in DirPartyTable

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

partyNumber in DirPartyTable

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates