InventSite + LogisticsEntityPostalAddressView = how to get LocationName based on SiteId

(0) Share

Report

Posted on by DaveCline

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

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

DaveCline 93 on at

Like (0)

Report

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

Was this reply helpful? Yes No