CODEWITHSUNDEEP
sql-servermicrosoft-dynamicsdynamics-ax-2012
Bernardo Morales
Bernardo Morales

Reputation: 142

Where can I find the Invoice lines/details in DynamicsAX database?

This is what I already know: Tables for open invoices: "CustTransOpen" - "CustInvoiceJour"

Now, I need some way to find all the lines that make up every single invoice. I've been researching and found that the tables custInvoiceLine and custInvoiceBackorderLine seem to hold this kind of information, but it's not exactly what I need.

Am I heading in the right direction?

Upvotes: 1

Views: 791

Answers (1)

Pradeep Muttikulangara Vasu
Pradeep Muttikulangara Vasu

Reputation: 426

The easy way to find is go to form and see its data sources in AOT. In this case CustInvoiceJournal where you can see CustInvoiceJour and CustInvoiceTrans(Lines table) and related tables.

Upvotes: 1

Related Questions