Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) SQL Relationship for D...

SQL Relationship for Dynamics AX SQLServer

(0) Share

Report

Posted on by Community Member

what is the SQL Relationship/join between CUSTINVOICETRANS, GENERALJOURNALENTRY & GENERALJOURNALACCOUNTENTRY in SQLQuery i need for sql query for sales revenue in powerbi for reporting

*This post is locked for comments

All responses (2)

Answers (0)

Rustem Galiamov 8,072 on at

Like (0)

Report

RE: SQL Relationship for Dynamics AX SQLServer

You can mark question as answered if it's done.
Suggested answer

Rustem Galiamov 8,072 on at

Like (1)

Report

RE: SQL Relationship for Dynamics AX SQLServer

Hi!

GeneralJournalEntry relate to CustInvoiceJour, not to CustInvoiceTrans.

Relations are:

1. GeneralJournalEntry.SubledgerVoucher == CustInvoiceJour.LedgerVoucher

2. GeneralJournalAccountEntry.GeneralJournalEntry == GeneralJournalEntry.RecId