Link MarkUpTrans to CustInvoiceJour table

(0) Share

Report

Posted on by Oush Mi Ta

190

Hello,

I have inserted charges values (markUpTrans.values) for sales order '000711' (custInvoiceJour.SalesId) and want to retrieve this value.

I have then linked these two tables in my x++ code as below:

select markupTrans where markupTrans.TransRecId == custInvoiceJour.RecId;

(In the relations for MarkUpTrans there is also " markupTrans.TransTableId == custInvoiceJour.TableId; " but I can't find any field named tableId in custInvoiceJour so I used on TransRecId to link the tables.)

However, I am not obtaining the right value and when I checked in sql it is returning the markuptrans.value for salesOrder '000014' which means that this relation is not working. How do I link these tables?

And also, is there any way to link MarkUpTable to custInvoiceJour?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (1)

Report

Hi Oush,

The TableID field is a special one which is not visible at the table design, but can be used in coding. So, add this in your where clause, and your issue should be solved. You can also use "tablenum(CustInvoiceJour)" to get the tableId. The TransRecId is not unique when querying it without the correct table ID.

Was this reply helpful? Yes No
Verified answer

Ali Zaidi 4,657 on at

Like (1)

Report

Oush Mi Ta, there is direct relationship between MarkupTrans and CustinoviceTrans. You can query on CustInvoiceTrans, Which is child table of CustInvoiceJour. For your reference I also add the screenshot of table relation.

Hope this helps :)

Was this reply helpful? Yes No
Oush Mi Ta 190 on at

Like (0)

Report

Thanks it works

Was this reply helpful? Yes No
RomanBI 10 on at

Like (0)

Report

you need the TableId with CustInvoiceTrans as well, right?

how to get the TableId in Power BI ?

- Roman

Was this reply helpful? Yes No