web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to Select Vendor M...
Finance | Project Operations, Human Resources, ...
Answered

How to Select Vendor Master Record (VendTable) from VendVendorRequest?

(1) ShareShare
ReportReport
Posted on by ShahzaibAhmed52 142

Hi Experts,

I have a requirement where I need to retrieve a vendor master record (from VendTable) based on a vendor request record (from VendVendorRequest). I checked for a direct relation between these two tables, but it seems there isn’t one defined. Is there any recommended approach to select or map the corresponding VendTable record from VendVendorRequest?

Thanks in advance!


 
Categories:
Dynamics 365 Finance
Microsoft Dynamics AX
I have the same question (0)
  • ShahzaibAhmed52 Profile Picture
    ShahzaibAhmed52 142 on at
    How to Select Vendor Master Record (VendTable) from VendVendorRequest?
    @Sohaib Cheema Thank you It worked for me. 
  • Verified answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 47,980 User Group Leader on at
    How to Select Vendor Master Record (VendTable) from VendVendorRequest?
     
    Here is what I can suggest, Please test it as I have not tested it and suggesting you based on a quick look in the system.
     
     
    VendVendorRequest >> VendVendorRequestNewVendor (both are the same, as VendVendorRequestNewVendor extends the table VendVendorRequest, therefore both table will have same RecId
     
    get the field named ProspectiveVendorRegistration from table VendVendorRequestNewVendor using RecId of VendVendorRequest
     
    Up next, using the int64 data of ProspectiveVendorRegistration(field) >> go to table VendProspectiveVendorRegistration and find the associated record(of table VendProspectiveVendorRegistration) using VendProspectiveVendorRegistration.RecID == VendVendorRequestNewVendor.ProspectiveVendorRegistration
     
    Once you have the record of VendProspectiveVendorRegistration, find teh DirParty record using VendProspectiveVendorRegistration.VendorParty == DirPartyTable.RecId
     
    Finally VendTable.Party == DirPartyTable.RecId
     
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 814 User Group Leader

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 798 Super User 2025 Season 2

#3
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 622

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans