Customer Address Roles Update

(0) Share

Report

Posted on by Sathish Sivakumar

3,732

Hi,

I'm working on the customer address update on the X++. Able to update the address details, but I cannot update the roles in that address. I had mentioned the code which I'm trying.

Code:

LogisticsPostalAddress address;
Custtable custtable;
DirPartyPostalAddressView addressView;
DirParty DirParty;
container roles;

custtable = Custtable::find("902536");
address.Location = 22565428539;
address.CountryRegionId = "USA";
address.State = "NY";
address.Street = "34";
address.ZipCode = "10119";
address.City = "new york";

addressView.Party = CustTable.Party;
addressview.initFromPostalAddress(address);
addressView.locationRoles();

DirParty = DirParty::constructFromPartyRecId(CustTable.Party);
roles = [LogisticsLocationRole::findBytype(LogisticsLocationRoleType::Home).RecId];
DirParty.createOrUpdatePostalAddress(addressView, roles);

If I add the "address.Location = 22565428539;" means it update the address but it didn't update role detail. Can you give me the solution for it!!!

*This post is locked for comments

I have the same question (0)

All responses (25)

Answers (0)

André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi Sathish,

I'm not quite sure what is working or not. You are using a hardcoded value for the address.location field.

Perhaps you can have a look in the class DMFLogisticsAddressHelper for some guidance. This class is used for several Data Import/Export Framework entities to create or update addresses also with roles.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

The relation between customer locations and location roles is stored in DirPartyLocationRole table.

Was this reply helpful? Yes No
Sathish Sivakumar 3,732 on at

Like (0)

Report

Hi Guys,

Have you ever worked on updating the customer address with roles (Delivery, invoice, business, etc,.) on X++. If you, please share some code please.

Was this reply helpful? Yes No
Andrew Xu 3,877 on at

Like (0)

Report

Are you going to update the role of an address or update the address of a specifice role of a customer?

Was this reply helpful? Yes No
Sathish Sivakumar 3,732 on at

Like (0)

Report

Hi,

I am going to update the roles in the address.

Was this reply helpful? Yes No
Suggested answer

Andrew Xu 3,877 on at

Like (0)

Report

Hi Sathish,

Try this,

static void ChangeCustAddressRole(Args _args)
{
CustTable custTable;
DirPartyLocation dirPartyLocation;
DirPartyLocationRole dirPartyLocationRole;
LogisticsLocationRoleType oldRoleType, newRoleType;
LogisticsLocationRole logisticsLocationRole;
;

custTable = CustTable::find(Your Customer Account);

select forUpdate firstonly dirPartyLocationRole
exists join dirPartyLocation join logisticsLocationRole
where dirPartyLocation.Party == custTable.Party &&
dirPartyLocation.IsPostalAddress == NoYes::Yes &&
dirPartyLocationRole.PartyLocation == dirPartyLocation.RecId &&
dirPartyLocationRole.LocationRole == logisticsLocationRole.RecId &&
logisticsLocationRole.Name == enum2Value(Existing LogisticsLocationRoleType);

ttsBegin;
dirPartyLocationRole.LocationRole = LogisticsLocationRole::findBytype(New LogisticsLocationRoleType).RecId;
dirPartyLocationRole.update();
ttsCommit;

info('change is done');
}

Was this reply helpful? Yes No
Sathish Sivakumar 3,732 on at

Like (0)

Report

Hi Andrew Xu,

Your code works perfectly, but I need to update multiple roles means what should I do?

Was this reply helpful? Yes No
Suggested answer

Andrew Xu 3,877 on at

Like (0)

Report

You have 2 options,

1. Manually execute the code with your customers/roles.

2. Write a loop to execte the change. Refer to http://msdn.microsoft.com/EN-US/library/aa892768.aspx, see how to write a loop in X++.

Was this reply helpful? Yes No
Suggested answer

Umer Ejaz 230 on at

Like (1)

Report

Try updating roles using addEntityLocation method from DirPartyLocation table. in roles you could potentially send multiple roles RecIds and force the roles replacement.

roles = [LogisticsLocationRole::findBytype(LogisticsLocationRoleType::Invoice).RecId,

LogisticsLocationRole::findBytype(LogisticsLocationRoleType::Delivery).RecId];

dirPartyLocation.addEntityLocation(roles, true);

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Select * From LogisticsLocationRole

--Delievery Address (5637144577)

update dirpartylocationrole

set LOCATIONROLE = 5637144577

Was this reply helpful? Yes No