You’re offline. This is a read only version of the page.
Announcements
Hi all,
I have a requirement of bulk update of customer addresses in ax2012 i.e. importing customer addresses from Excel and then Updating with new addresses.
When I tried to update customer addresses first record is getting updated correctly and from the second record onwards they are getting appended to first record in advanced view.
Share
Reportcusttable10 =CustTable::find(iAccountNum);
ttsBegin;
dirParty = DirParty::constructFromCommon(custtable10);
dirPartyPostalAddressView.LocationName = oName;
dirPartyPostalAddressView.City = ocity;
dirPartyPostalAddressView.Street = ostreet;
dirPartyPostalAddressView.State = oState;
dirPartyPostalAddressView.ZipCode = ozipcode;
dirPartyPostalAddressView.CountryRegionId = 'USA';
dirPartyPostalAddressView.IsPrimary= NoYes::Yes;
roles = [LogisticsLocationRole::findBytype(LogisticsLocationRoleType::Delivery).RecId
,LogisticsLocationRole::findBytype(LogisticsLocationRoleType::Invoice).RecId];
dirParty.createOrUpdatePostalAddress(dirPartyPostalAddressView,roles);
ttsCommit;
ok Gunjan Bhattacharyya,
Thanks!
Hi mahiims18,
Great! Please do mark the answer as Verified.
Hi Gunjan Bhattacharyya,
your code is working,
Thanks for the quick reply.
Hi mahiims18,
Could you please try updating addresses using this code and see if it works for you?
All responses (
Answers (
custtable10 =CustTable::find(iAccountNum);
dirParty = null;
dirPartyPostalAddressView.clear();
ttsBegin;
dirParty = DirParty::constructFromCommon(custtable10);
dirPartyPostalAddressView.LocationName = oName;
dirPartyPostalAddressView.City = ocity;
dirPartyPostalAddressView.Street = ostreet;
dirPartyPostalAddressView.State = oState;
dirPartyPostalAddressView.ZipCode = ozipcode;
dirPartyPostalAddressView.CountryRegionId = 'USA';
dirPartyPostalAddressView.IsPrimary= NoYes::Yes;
if (roles == conNull())
{
roles = [LogisticsLocationRole::findBytype(LogisticsLocationRoleType::Delivery).RecId
,LogisticsLocationRole::findBytype(LogisticsLocationRoleType::Invoice).RecId];
}
dirParty.createOrUpdatePostalAddress(dirPartyPostalAddressView,roles);
ttsCommit;
#1
André Arnaud de Cal...
294,208
Super User 2025 Season 1
#2
Martin Dráb
232,970
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
