Dynamics Community Forum Thread Details

find warehouse address taking into account address purpose

Hello,

I have a requirement to find warehouse address with purpose "Invoice" if it's marked as primary, if not then fetch the firstonly purpose "Invoice" one if there are several of them. For instance on the screenshot below I have purpose invoice as primaty one. That's what I need BUt if it's not primary then I need to fetch the firstonly purpose invoice address form the list below. Is there any standard method I can use or I need to write my own?

I tried to use standard method

LogisticsPostalAddress address = LogisticsLocationEntity::findPostalAddress(
    this,
    LogisticsLocationRoleType::Invoice,
    DateTimeUtil::utcNow(),
    false);

but it returns me not Invoice address, but delivery one. however I passed this as argument LogisticsLocationRoleType::Invoice. this happens because under the hood it calls this. so just returns me delivery address.

if to use custom method as an option I see I can use such code

InventLocation inventLocation;
LogisticsEntityPostalAddressView postalAddressView;

inventLocation = inventLocation::find(inventlocation.InventLocationId);
if (inventLocation)
{
select firstonly postalAddressView
where postalAddressView.Entity == inventLocation.RecId
&& postalAddressView.EntityType == LogisticsLocationEntityType::Warehouse
&& postalAddressView.isPrimary == NoYes::Yes;
}

theres is a display method on the LogisticsEntityPostalAddressView called locationRoles() which returns purpose for the address. I can traverse through all addresses for the warehouse in LogisticsEntityPostalAddressView, then check if it's primary and of purpose invoice and return, otherwise proceed looking further firstonly of purpose invoice not primary. but i don;t think it's elegant solution.

maybe i can use some standard method?

Thanks.

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

public LogisticsPostalAddress getAddressByType(LogisticsLocationRoleType _roleType, TransDateTime _transDateTime = DateTimeUtil::utcNow()) { LogisticsLocationEntity location; LogisticsLocationRecId logisticsLocationRecId; logisticsLocationRecId = InventLocation::getLocationFromRole(this.recid, _roleType, _transDateTime); location = LogisticsLocationEntity::constructFromLocationRecId(logisticsLocationRecId, false, _transDateTime); return location ? location.getPostalAddress() : null; }

Quick Links

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