select crossCompany not working properly

(0) Share

Report

Posted on by CU22120935-0

100

I have two customers that share the same party but in different legal entities

in each legal entity, i created one contact for this customer

So:

Customer1 partyNumber1 USMF

has

contactPersonX partyNumberX USMF

And

Customer2 partyNumber1 USRT

has

contactPersonY partyNumberY USRT

Why this while select below is returning both customers (1 and 2), even though only customer1 has contactPersonX?
i know "1234" is the same for both, but contactPersonId is not shared between them, so shouldn't it only enter the while loop once instead of twice?

while select crosscompany custTable
where custTable.Party == 1234
join contactPerson where contactPerson.ContactPersonId == "contactPersonX"

{

}

Categories:

Dynamics 365 Finance

I have the same question (0)