SBX - Search With Button

SBX - Forum Post Title

Relation Between VendPackingSlipJour,vendtrans and VendInvoiceJour

Microsoft Dynamics AX Forum

Scotly asked a question on 12 Apr 2017 6:57 AM

Question Status

Suggested Answer

Hi Every One,

I am new to this community ,

I have requirement that I need pull data from VendPackingSlipJour,vendtrans and VendInvoiceJour

I am struggle to join three tables  

Please Help

Reply
Suggested Answer

Hi Scotly,

The most common relation on these tables is the Voucher (or Invoice) and Transaction date (or Invoice date). The relations are also visible in the table designs.

Reply
Scotly responded on 12 Apr 2017 7:12 AM

Can you please elaborate more about Primary key and foreign key relationship between these tables ?

Reply

Hi Scotly,

What is your exact question? Did you have a look at the tables and the defined relations in the Application Object Tree (AOT)?

Reply
Suggested Answer

Hi Scotly,

The most common relation on these tables is the Voucher (or Invoice) and Transaction date (or Invoice date). The relations are also visible in the table designs.

Reply

SBX - Two Col Forum

SBX - Migrated JS