Share
ReportHi There,
I am trying to join two tables (via Atlas) but can't find a link between the two?
Can anyone help?
Thanks
*This post is locked for comments
You’re offline. This is a read only version of the page.
Hi There,
I am trying to join two tables (via Atlas) but can't find a link between the two?
Can anyone help?
Thanks
*This post is locked for comments
Thats great, many thanks
Because there is no link. custinvoiceline is a line of a free text invoice. If it is not posted there is no CustTrans record in the system. When you post an invoice AX creates CustInvoiceJour that is a header of invoice with multiple lines(custInvoiceTrans). CustInvoiceJour has invoiceId field you can use to find custTrans.
Relation between custTrans and custInvoiceJour:
custTrans.Invoice == custInvoiceJour.invoiceId
relation between custInvoiceJour and custInvoiceTable:
custInvoiceJour.InvoiceId == custInvoiceTable.InvoiceId && custInvoiceJour.InvoiceDate == custInvoiceTable.InvoiceDate && custInvoiceJour.NumberSequenceGroup == custInvoiceTable.NumberSequenceGroup
relation between custInvoiceTable and custInvoiceLine
custInvoiceTable.RecId == custInvoiceLine.ParentRecId
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (