How to get the vendors list which Partyid is not available in Dirpartyloaction Table

(0) Share

Report

Posted on by Community Member

Hi All,

I want to get all vendors list which doesn't any address..so I have checked that if vendor party id is not available in Dirpartylocation table then it doesnt have any address.

Please let me know how to get vendors list which party id is not vailable in DirpartyLocation table.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Chaitanya Golla 17,225 on at

Like (1)

Report
Copy link

Link copied!
Hi,

Please use the following job/code to get the list of vendors with no postal address.

static void AXC_VendorNoAddress(Args _args) { LogisticsPostalAddressView postalAddressView; DirPartyTable dirPartyTable; VendTable vendTable; DirPartyLocation dirPartyLocation; while select vendTable join dirPartyTable where dirPartyTable.RecId == vendTable.Party notexists join dirPartyLocation where dirPartyLocation.Party == dirPartyTable.RecId && dirPartyLocation.IsPostalAddress == NoYes::Yes { info(strFmt("Vend Account: %1, Name: %2", vendTable.AccountNum, vendTable.name())); } }

Was this reply helpful? Yes No
Suggested answer

Srini Ramidi 2 on at

Like (0)

Report
Copy link

Link copied!

In case if you want to check in SQL:

SELECT * FROM VENDTABLE

LEFT JOIN DIRPARTYLOCATION ON VENDTABLE.PARTY=DIRPARTYLOCATION.PARTY

WHERE DIRPARTYLOCATION.PARTY IS NULL

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank you Chaitanya..it gives me required records

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks Srinivas..

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Could you please mark the helpful answers as verified.

Was this reply helpful? Yes No