Vendor and DirParty Table

(0) Share

Report

Posted on by Community Member

Hi ...I need to extract a list of contacts for all vendors in the system. Found the DirParty Table but could not find a way to link it with the VendTable. What tables should I be using if these are the wrong ones? what piece of info links them together? I have checked recid but they are different....

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

nunomaia 25 Moderator on at

Like (0)

Report

You can join on DirPartyTable .RecId == VendTable.Party

Was this reply helpful? Yes No
Suggested answer

5400 7,162 on at

Like (0)

Report

See, if You want to find the contact information from AX you need multiple join.

Dirparty table having relation with vendtable with party field.

DirPartyTable .RecId == VendTable.Party

Now dirparty table having relation dirpartylocation and dirpartylocation having relation with logistics location table from where you can join logisticelectronicaddress table to fetch the contact info.

Was this reply helpful? Yes No
Keshav Kumar 220 on at

Like (0)

Report

First of all you need to link vendtable with dirpartytable using the relation:

Dirpartytable.Recid==Vendtable.party.

Was this reply helpful? Yes No
ScorpioDax 333 on at

Like (0)

Report

I am having trouble writing the query for this in the AOT. Does anyone have the x++ code that can help me with this?

Was this reply helpful? Yes No
Suggested answer

startax 1,845 on at

Like (0)

Report

Hi ,

You can try the below code for one vendor.

LogisticsElectronicAddress logisticsElectronicAddress;

DirPartyTable dirPartyTable;

select firstOnly logisticsElectronicAddress where logisticsElectronicAddress.RecId == DirPartyTable::findRec(VendTable::find(‘vendorAccount′).Party).PrimaryContactPhone;

info(strFmt(“%1″,logisticsElectronicAddress.Description));

For more details you can check the below link

community.dynamics.com/.../how-to-get-contact-39-s-email-addresses-from-a-customer-or-vendor

Was this reply helpful? Yes No
ScorpioDax 333 on at

Like (0)

Report

Thanks for the help...i am getting this error though. I also tried the code from the page you linked but how can i return and view the results?

public container getRemittanceContacts()
{
container remittanceEmailAddresses;
DirPartyTable dirParty;
LogisticsElectronicAddress electronicAddress;
DirPartyLocation dirPartyLoc;
ContactPerson contactPerson;

//find all of the vendor contact email addresses that are currently active
while select * from contactPerson
where contactPerson.ContactForParty == contactPerson.Party &&
contactPerson.Inactive == NoYes::No
join RecId from dirParty
where dirParty.RecId == contactPerson.Party
join Location, Type, Locator FROM electronicAddress
EXISTS JOIN Location, Party FROM dirPartyLoc
WHERE electronicAddress.Location == dirPartyLoc.Location && dirParty.RecId==dirPartyLoc.Party
&& electronicAddress.Type == LogisticsElectronicAddressMethodType::Email
{
remittanceEmailAddresses += electronicAddress.Locator;
}
return remittanceEmailAddresses;

}

Was this reply helpful? Yes No
ScorpioDax 333 on at

Like (0)

Report

what is the relation for the dirpartylocation and logisticslocation i cannot find the join?

Was this reply helpful? Yes No
axk 925 on at

Like (0)

Report

DirPartyLocation.Location == LogisticsLocation.RecId

Was this reply helpful? Yes No
ScorpioDax 333 on at

Like (0)

Report

perfect thank you!

Was this reply helpful? Yes No