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.
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…
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…
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…
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…