static void getCustomerAddress(Args _args)
{
CustTable custTable;
VendTable vendTable;
DirPartyTable dirPartyTable;
DirPartyLocation dirPartyLocation;
DirPartyLocationRole dirPartyLocationRole;
LogisticsLocation logisticsLocation;
LogisticsLocationRole logisticsLocationRole;
LogisticsPostalAddress logisticsPostalAddress;
while select * from custTable where custTable.AccountNum == "BRIG" // if you want vendor specify vendor here
join dirPartyTable
where dirPartyTable.RecId == custTable.Party
join dirPartyLocation
where dirPartyLocation.Party == custTable.Party
//If you need fetch based on role use below commented code
/*join dirPartyLocationRole
//where dirPartyLocationRole.PartyLocation == dirPartyLocation.RecId
//join logisticsLocationRole
//where logisticsLocationRole.RecId == dirPartyLocationRole.LocationRole
// && logisticsLocationRole.Type == LogisticsLocationRoleType::Delivery*/
join logisticsLocation
where logisticsLocation.RecId == dirPartyLocation.Location
join logisticsPostalAddress
where logisticsPostalAddress.Location == logisticsLocation.RecId
{
info(strFmt("%1", logisticsPostalAddress.Address));
}
}
Subscribe to:
Post Comments (Atom)
Create number sequence in D365 FO
Create the data type. Add code in the loadModule method of the appropriate NumberSeqModule subclass. Add a method to the module’s paramet...
-
Dialogbutton dialogButtonConfirm; ; dialogButtonConfirm = Box::yesNo("continue ", dialogButton::Yes, ...
-
Breakpoints Command Shortcut key Remove all breakpoints. CTRL+SHIFT+F9 I...
-
Just use the below code to remove the special character from the string. strRem('String','*'); You can replace * with...
No comments:
Post a Comment