News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) InventSite + Logistics...

Microsoft Dynamics AX (Archived)

InventSite + LogisticsEntityPostalAddressView = how to get LocationName based on SiteId

(0) Share

Report

Report

Posted on by DaveCline

85

DAX Tribe,

I've been tasked with doing some Invoice report processing (email). I've got the SalesTable.InventSiteId (which links to the InventSite table), and now I need the LocationName as can be found in the InventSite form (COMPANY/Inventory management/Setup/Inventory breakdown/Sites).

Somehow the below InventSite.SiteId needs to be linked to something in the LogisticsEntityPostalAddressView view.

Any clues from you very helpful people?

Thanks,

Dave Cline

SELECT *

FROM [AOS_DB].[dbo].[INVENTSITE]

JOINED SOMEHOW ??? TO

SELECT [LOCATIONNAME]
FROM [AOS_DB].[dbo].[LOGISTICSENTITYPOSTALADDRESSVIEW]

WHERE INVENTSITE.SITEID = '100'

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

DaveCline 85 on at

Like (0)

Report

RE: InventSite + LogisticsEntityPostalAddressView = how to get LocationName based on SiteId

SELECT * FROM LogisticsEntityPostalAddressView A

JOIN INVENTSITE B

ON B.RECID = A.Entity

WHERE A.EntityType = 1 AND B.SITEID = '100'

ORDER BY A.IsPrimary DESC

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans