温馨提示:本文翻译自stackoverflow.com,查看原文请点击:axapta - How to get Address using inventsiteid x++
axapta microsoft-dynamics x++

axapta - 如何使用Inventsiteid X ++获取地址

发布于 2020-05-16 11:58:47

就像在线程标题上。如何或通过什么方式可以获取具有inventsiteid的LocationAddress信息?太多的表和视图令人困惑。我需要选择当前站点ID的站点地址。

查看更多

提问者
Radosław Mierzejewski
被浏览
28
Alex Kwitny 2020-02-28 00:19

创建此作业并将替换为inventSiteId您的网站。

static void Job107(Args _args)
{
    InventSiteId                        inventSiteId    = 'MySite'; // PUT YOUR SITE HERE
    InventSite                          inventSite      = InventSite::find(inventSiteId);
    InventSiteLogisticsLocation         siteLocation;
    InventSiteLogisticsLocationRole     siteLocationRole;
    LogisticsLocationRole               locationRole;
    LogisticsPostalAddress              logisticsPostalAddress;

    // Method 1 - List all addresses. Refine query as needed.
    while select logisticsPostalAddress
    join siteLocation
        order by IsPrimary desc
        where logisticsPostalAddress.Location           == siteLocation.Location    &&
              siteLocation.Site                         == inventSite.RecId
    join siteLocationRole
        where siteLocationRole.SiteLogisticsLocation    == siteLocation.RecId
    join locationRole
        where locationRole.RecId                        == siteLocationRole.LocationRole
    {
        info(strFmt("Role: %1; Address: %2", locationRole.Type, logisticsPostalAddress.Address));
    }

    // Method 2; 1-liner for single address, good for just getting primary. Change role type for different addresses
    info(LogisticsPostalAddress::findByLocation(InventSite::getLocationFromRole(InventSite::find(inventSiteId).RecId, LogisticsLocationRoleType::Delivery)).Address);
}