Tag Archives: Dynamics AX reporting tutorial

Techno-functional Dynamics 365 F&S Data Model Explanations for Reporting, Part 2 of 25 – Item Receipts & Inventory Registration

In this post we will continue with our purchase order in the previous article. We will review the process of registering and reserving a purchase order line item, and dig deeper into the purchasing/receipt list data model.

Techno-Functional Dynamics 365 F&S Data Model Explanations for Reporting, Part 1 of 25 – Purchase Order Creation Tables

Introducing The Dynamics 365 Techno-Functional Data Model Series Things have changed a lot since I started blogging over a decade ago.  There are so many wonderful topics to blog and learn on today; it seems like one doesn’t even know where to start.  To make the process more friendly, I’ve introduced a new sort of […]

3 Part Series: How to extract financial data in Dynamics AX with SQL

Wouldn’t it be great if you could just figure out the SQL that would allow you to pull Dynamics AX data from that complicated financial table setup. Recently, I had a client give me a challenge where they wanted me to come up with a way that they could utilize their existing staff who had […]

SQL for General ledger data by Dimension for building Non-AX Reports with AX data Part 3 (final)

In the final part of our series, our hard work has paid off. You will be able to generate a general ledger report that is fast, and that will allow for our users to query dimensions however they like. We want our users to really see the power of AX and nothing does that like […]

SQL for General ledger data by Dimension for building Non-AX Reports with AX data Part 2

Now, in my continuing mission to ensure that my blog devalues my skills as an AX Technical Architect/Consultant, I’m going to give away more of my precious secrets. If you understand this post, you will have learned a very, very strong tactic for extracting data with SQL – and not just financial data. The other […]

SQL for General ledger data by Dimension for building Non-AX Reports with AX data Part 1

It’s a request that I’ve heard a million times in my AX implementation experience. Wouldn’t it be great if you just had the SQL for being able to extract Dynamics AX data so that you could use whatever reporting tool that you like for viewing Dynamics AX reports? You could use SSRS Report Builder, Crystal […]