Dynamics AX Enterprice and cross-company queries

One of the things I’m missing in the Dynamics Ax, is the ability to do advanced cross-company queries. Many of my customers are international and they like to do reporting across companies. I was at the convergence 2007, and had the chance to talk to some of the developers regarding this. They are currently developing a "Site"-possibility in the inventory dimensions, but this is not the same. My suggestion is to extend the "Common-Table" with a new field called "Site", and then you actually could have different datasets per site. You could then enable to have different parameters on items, prices etc per site. I suggested this to Microsoft, but the change was too big to be supported in the current upgrade schema. The other thing, that would be useful, is a cross-company/site query. To extend the query object to fetch data from several companies simultaneous. A lot of modification have been made to do this, and to implement this in the core would really help.



I appreciate that I can be a part of this worldwide blog community—as a consultant working from Norway, the blog lets me share more than 20 years of experience with Microsoft Dynamics 365. Along the way, I participated in developing retail, PDA/RF, barcoding, master data, kitting and WMS-solutions for Dynamics. My blog focuses on my deepest interests and expertise: along with a 360 degree view of digital transformation topics, I welcome opportunities to dive into retail and intercompany supply chain automation, logistics, and production—everything that is moving around in a truly connected enterprise. As Enterprise Architect on Dynamics 365, I specialize in strategic development and planning for corporate vertical solutions and works to build international networks that increase knowledge and understanding for Dynamics 365. As an advocate for both providers and customers, I'm committed to ensure that customers constantly changing needs are meet, and I see community as key for increasing expertise. I welcome you to connect with me.

0 comments on “Dynamics AX Enterprice and cross-company queries

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: