Joining Tables

Finance and Operations/AX Developer Forum
1

hi,

I am trying to make a report, i want CustVendExternalItem.ExternalItemId field to be in the report. to make this i must write a method in CustInvoiceTrans.

So, how can i get CustVendExternalItem.ExternalItemId field by joining CustVendExternalItem, CustInvoiceTrans and CustInvoiceJour

Regards.

2

Hi,

Firstly just wanted to cross check that you are talking about NAV and about Ax or other product, because the terms you are using are not applicable for NAV but you have posted in NAV thread…

3

Are you trying it in NAV?

4

i am sorry i did not pay attention, i am trying in ax.

So, all thread moved to Axapta forum. Moderator.

5

Hi Amin,

Welcome to Dynamics User Group.

I suggest you post your question in the following forum, which will get you better response.

http://dynamicsuser.net/forums/11.aspx

And as you are a new to this forum, suggest you to go through following post to understand this community better.

http://dynamicsuser.net/forums/p/27184/145684.aspx#145684

6

Hi,

You can write a display method in the report. Please look in developers guide for more info.