14.09.2017, 13:11 | #1 |
Участник
|
shashidotnet: [AX2012] Get Email for Customer / Vendor (with specific roles)
Источник: https://shashidotnet.wordpress.com/2...pecific-roles/
============== To get an email address for a Customer or vendor, you can use the following statement static void DEL_SS_emailStmtjob(Args _args) { CustTable cust; //Replace with vendTable for Vendors DirPartyLocation dirPartyLocation; LogisticsElectronicAddress elecAddress; LogisticsElectronicAddressRole elecAddressRole; LogisticsLocationRole locRole; select firstOnly cust where cust.AccountNum == 'Cust-001'; while select DirPartyLocation where dirPartyLocation.party == cust.Party { while select elecAddress where elecAddress.Location == dirPartyLocation.Location && elecAddress.Type == LogisticsElectronicAddressMethodType::Email { while select elecAddressRole where elecAddressRole.ElectronicAddress == elecAddress.RecId join locRole where locRole.RecId == elecAddressRole.LocationRole { info(strFmt("%1 - %2", elecAddress.Locator, locRole.Name)); } } } } Filed under: Dynamics Ax Источник: https://shashidotnet.wordpress.com/2...pecific-roles/
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору. |
|
|
|