Relation between Vendor details and Vendor Purpose

(0) Share

Report

Posted on by Akbarpasha

Hi All,

We are trying to get the details for Vendor having "Purpose" defined in "Contact Information" - from More settings.

but we did not find any relation from VendTable to "Purpose" field. It is just a string controller in the form.

All the Purpose values are defined in the table "LogisticsLocationRole" , but unbale to find the relation from VendTable to LogisticsLocationRole table.

Please advice us how we can have the relation and get the Purpose for all vendors from x++ code.

Regards,

Akbar

All responses (3)

Answers (1)

Akbarpasha on at

Like (0)

Report

RE: Relation between Vendor details and Vendor Purpose - AX 2012

Thank you very much Girish, second option helped me to get the required data.

Thanks again.
Verified answer

GirishS 27,825 Moderator on at

Like (0)

Report

RE: Relation between Vendor details and Vendor Purpose - AX 2012

If the Above doesn't work, use VendTable - DirPartContactInfoView (In that view you have ElectronicAddress RecId). - You can Join ElectronicAddress field with LogisticsElectronicAddress RecId - LogisticsElectronicAddressRole - LogisticsLocationRole.

Also check for other table relations.

Thanks,

Girish S.
Suggested answer

GirishS 27,825 Moderator on at

Like (0)

Report

RE: Relation between Vendor details and Vendor Purpose - AX 2012

Hi,

You need to join LogisticsElectronicAddress - LogisticsElectronicAddressRole - LogisticsLocationRole.

See above table relations under relation node.

Thanks,

Girish S.