Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / How to get the Vendor ...
Finance forum
Answered

How to get the Vendor ID using LogisticsPostalAddress Table

(0) ShareShare
ReportReport
Posted on by MSTonyax 15

Hi All,

 How to get vendor ID using LogisticsPostalAddress Table in D365Fo

Categories:
Development / Customization / SDK
  • Ranjeet_Kr Profile Picture
    Ranjeet_Kr on at
    RE: How to get the Vendor ID using LogisticsPostalAddress Table

    Question has been answered.

  • MSTonyax Profile Picture
    MSTonyax 15 on at
    RE: How to get the Vendor ID using LogisticsPostalAddress Table

    Hi will

    Thanks for reply, Its working

  • Verified answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,419 on at
    RE: How to get the Vendor ID using LogisticsPostalAddress Table

    Hi Tony,

    You can use this query -

    LogisticsPostalAddress  postalAddress;
DirPartyLocation 		partyLocation;
VendTable				vendTable;

select firstonly vendTable
	join partyLocation
		join postalAddress
			where postalAddress.Location == partyLocation.Location
			   && partyLocation.Party    == vendTable.Party 
			   && postalAddress.recId    == XXXX;

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Community Spotlight for September 2024

Kudos to Mohana Yadav!

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,339 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,177 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans