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....
perfect thank you!
what is the relation for the dirpartylocation and logisticslocation i cannot find the join?
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;
}
Hi ,
You can try the below code for one vendor.
Share
Report
All responses (
Answers (
LogisticsElectronicAddress logisticsElectronicAddress;DirPartyTable dirPartyTable;select firstOnly logisticsElectronicAddress where logisticsElectronicAddress.RecId == DirPartyTable::findRec(VendTable::find(‘vendorAccount′).Party).PrimaryContactPhone;info(strFmt(“%1″,logisticsElectronicAddress.Description));
I am having trouble writing the query for this in the AOT. Does anyone have the x++ code that can help me with this?
First of all you need to link vendtable with dirpartytable using the relation:
Dirpartytable.Recid==Vendtable.party.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,263
Super User 2024 Season 2
#2
Martin Dráb
228,112
Most Valuable Professional
#3
nmaenpaa
101,148