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

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) / SQL Query
Microsoft Dynamics AX (Archived)

SQL Query

(0) ShareShare
ReportReport
Posted on by Community Member

Hello! I would like to run a query in Excel to get data about outstanding invoices (at an historical date).  

Of course I have a report in AX which does this in pdf. Can I somehow use the SQL query from the AX report in excel?

*This post is locked for comments

  • Suggested answer
    Fx Profile Picture
    Fx 425 on at

    Hi Johan, 

    Can you tell us which version of AX did you use ?

    Considering you are using AX2012 version, you can take a look to the Office Add-ins, especially the Excel one.

    Here you have a good blog on it: Using the Dynamics AX Excel Add-In

    Regards

    FX

  • Community Member Profile Picture
    Community Member on at

    Too bad - we are still on 2009 !

  • Suggested answer
    Amir Nazim Profile Picture
    Amir Nazim 5,994 on at

    you can not use the sql queries but yes through excel addin you can use AOT queries to fetch AX data in excel.

    for your specific task you can use VendOpenInvoicesListPage AOT query, this will give you outstanding invoice list

    on use of excel addin, link below will help you.

    community.dynamics.com/.../working-with-microsoft-dynamics-ax-2012-s-excel-add-in-tools.aspx

  • Suggested answer
    Fx Profile Picture
    Fx 425 on at

    Hi

    ,

    I will avoid to play lottery today ...

    Maybe you can use the key shortcut "Ctrl +E". It will export your current form grid content to Excel.

    Keyboard Shortcuts for AX 2009

    Regards

    FX

  • Community Member Profile Picture
    Community Member on at

    Thanks but not a grid. Its a report. Any other suggestions?

  • Community Member Profile Picture
    Community Member on at

    To bad we still run 2009 !

  • Suggested answer
    Amir Nazim Profile Picture
    Amir Nazim 5,994 on at

    Open AOT > form > open VendTrans form

    make filter on balance field to exclude 0 values

    make filter on invoice field to exclude empty records.

    then Ctrl +E to export data to excel :)

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 307,166 Super User 2026 Season 2 on at

    Hi Johan,

    Using AX2009 you can also save the report in HTML format and then open it using Excel. You have the option to save the report as one single large page from within AX, so you don't get the headers for each page.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans