Customer address Update

(0) Share

Report

Posted on by Community Member

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.

custtable10 =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;

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Hi mahiims18,

Could you please try updating addresses using this code and see if it works for you?

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;

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Gunjan Bhattacharyya,

your code is working,

Thanks for the quick reply.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi mahiims18,

Great! Please do mark the answer as Verified.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

ok Gunjan Bhattacharyya,

Thanks!

Was this reply helpful? Yes No

Join the conversation

Community site session details

Customer address Update

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Customer address Update

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates