Share via

How to find the relation using SQL queries?

Anonymous
2021-12-23T05:59:06+00:00

Hi there,

This is Guganath. I need a help in D365, using SQL queries?

This is confirmPO query:

select VENDPURCHORDERJOUR.PURCHID,VENDPURCHORDERJOUR.PURCHORDERDATE ,VENDPURCHORDERJOUR.CONFIRMINGPO, PURCHTABLE.PURCHNAME from VENDPURCHORDERJOUR inner join PURCHTABLE on PURCHTABLE.PURCHID = VENDPURCHORDERJOUR.PURCHIDinner join PURCHLINE on PURCHLINE.PURCHID = PURCHTABLE.PURCHIDinner join INVENTTRANSORIGIN on INVENTTRANSORIGIN.INVENTTRANSID = PURCHLINE.INVENTTRANSIDinner join INVENTTRANS on INVENTTRANS.INVENTTRANSORIGIN = INVENTTRANS.RECID

QUESTION: Can anyone knows how to find the relation

(VENDINVOICEJOUR) & (VOUCHER TRANSACTION}.......

i need a queries

PLZ let me know.

Thanks and Regards

Guganath

Microsoft 365 and Office | Word | For education | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Doug Robbins - MVP - Office Apps and Services 323K Reputation points MVP Volunteer Moderator
    2021-12-23T09:08:27+00:00

    At least to me, it is NOT clear exactly what it is that you are after. Is there some more information that you can provide?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2021-12-23T08:40:58+00:00

    Hello, Guganath

    From your description, I understand you need help with Dynamics 365 and SQL queries.

    To make sure you get expert help, we suggest you post in Microsoft Dynamics Community 365 Forums, This is a specific and dedicated channel for the issues related to Dynamics 365. The members and engineers in this community have more resources and test environment to find the related answer to your concern.

    Appreciate your understanding.

    Best regards,

    Igor

    Was this answer helpful?

    0 comments