web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to create queries ...
Microsoft Dynamics AX (Archived)

How to create queries with multiple tables?

(1) ShareShare
ReportReport
Posted on by Community Member

Good morning guys,

I want to create a query based on the following table: CustGroup, CustTable, CustLedger, MainAccount and Currency. But I do not know how to link relationship the tables together. The requirement is that I have to make a report to retrieve Cash and Cash Debt There's a company in any one month. If you can help me. Please do it because I needed. thank you so much. 

My English is very bad. So if you don't understand my question. Please tell me, I will explain to you. Help me

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    Check the Relations node in the AOT for every table. Also relations could be defined on the Extended Data Types behind the fields on each table, which could also define the link between them.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    I understand you. But I just get 3 relationships on it. So I don't know how to create queries. If you can, Please do it to me.  

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    The financials postings tables are quite complex, without knowing more on your requirements it is very hard to give an exact answer (also financials module is not my strength neither). The best we could do is to steer you in the right direction by checking the Relations on Tables and EDTs.

    If that does not help, try checking other Views, Queries and x++ code in the AOT which are using those tables. It is easy to find them if you build cross-references (xRef) for your environment, which takes a couple of hours the first time.

    https://msdn.microsoft.com/en-us/library/aa626961.aspx

    Updating it in a batch, that takes less time:

    static void WIK_updateXrefs(Args _args)
{
    xRefUpdate::truncateXrefTables();
    xRefUpdateIL::updateAllXref(true, false, true);
}


  • Community Member Profile Picture
    Community Member on at

    Hi!

    msdn.microsoft.com/.../aa638454.aspx

    msdn.microsoft.com/.../bb314753.aspx

    ?

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Crispin John Augustine,

    I don't understand you, Please explan your idea to me. thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans