Table relation between free text invoice and tax

(0) Share

Report

Posted on by Community Member

Hello, i try to find the link between the free text invoice line and tax SQL tables. I only find hard link between the TaxTrans and CustInvoiceJour tables. I try to get each line with the tax.

Sorry for my rust english.

Thx!

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

RE: Dynamics AX 2012 R3 - Table relation

Hello, Free Text Invoice is using the same Table: CustInvoiceJour, but the parmId is empty for this transactions, that is the way you can recognize.

I hope this help you!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Dynamics AX 2012 R3 - Table relation

i want to know how to join the TaxTrans Table witht CustInvoiceTrans or CustInvoiceLine so i get each line with the tax

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,284 on at

Like (1)

Report

RE: Dynamics AX 2012 R3 - Table relation

Hi Andre Richard,

You can try to join by these fields:

taxTrans.SourceRecId == custInvoiceTrans.RecId

&& taxTrans.SourceTableId == custInvoiceTrans.TableId

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Dynamics AX 2012 R3 - Table relation

Show me where do you see that taxes lines. I can help you search, but I need to see where are you trying to get, I only can see the taxes in the journals and no in the lines.

Thanks!

Was this reply helpful? Yes No