TrvPartyEmployeeRelationship with the vendTable in AX2012

Dynamics 365 for Finance and Operations/AX Technical Forum
1

Dear all,

I had to write a procedure in SQL where to populate the records based on the relationship between vendTable and TrvPartyEmployeeRelationship .In AX2009 I could get the records by joining the vendtable with TrvPartyEmployeeRelationship with the field Accountnum. But in AX2012 there is no accountnum field in the TrvPartyEmployeeRelationship table. Please let me know the link between the above 2 tables

Thanks in Advance,

Sindhu

2

Dear all,

Is there any solution for the above query? Please let me know if there is any link between 2 tables.

Thanks

3

Dear All,

There is a solution for the above issue. LedgerDimension field can be taken as a link between TrvPartyEmployeeRelationship and
DimesnionAttributeValueCombination tables. In the DimesnionAttributeValueCombination , DisplayValue field can be taken as a field of vendor id.

Thanks