# How can we relate between ProjInvoiceJour and VendTrans tables?

**URL:** <https://www.dynamicsuser.net/t/how-can-we-relate-between-projinvoicejour-and-vendtrans-tables/64932>\
**Category:** Developer Forum\
**Created:** [January 26, 2018, 6:57pm UTC](https://www.dynamicsuser.net/t/how-can-we-relate-between-projinvoicejour-and-vendtrans-tables/64932 "2018-01-26T18:57:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![DotNet](https://avatars.discourse-cdn.com/v4/letter/d/e47774/32.png) [@DotNet](https://www.dynamicsuser.net/u/DotNet)\
**Post date:** [January 26, 2018, 6:57pm UTC](https://www.dynamicsuser.net/t/how-can-we-relate-between-projinvoicejour-and-vendtrans-tables/64932/1 "2018-01-26T18:57:00Z")

</div>

Hi,

I am trying to retrieve the VendTrans.DocumentDate based on the ProjInvoiceJour.ProjInvoiceId. Any clue?

Version: AX 2012 CU3.

Thanks,

Dave

---

<div class="post-metadata">

**Author:** ![kranthi](https://avatars.discourse-cdn.com/v4/letter/k/e480ec/32.png) [@kranthi](https://www.dynamicsuser.net/u/kranthi)\
**Post date:** [January 27, 2018, 5:31am UTC](https://www.dynamicsuser.net/t/how-can-we-relate-between-projinvoicejour-and-vendtrans-tables/64932/2 "2018-01-27T05:31:20Z")

</div>

Have a look at \Data Dictionary\Maps\CustVendInvoiceJour\Methods\custVendTrans.