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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Cross company Query View

(0) ShareShare
ReportReport
Posted on by 260

Hi guys,

I have one big object query that I use in a view which works fine.
However, the client requested to see all these information on all legal entities. 
I enabled the allow cross company on the query, but it seems it doesn't work I can see the records only on the main legal entity.

I also, created a simple query with only one data source enabled the property Allow Cross Company, assigned this query to a view, and it didn't work either.
Am I missing something or it doesn't work?

pastedimage1669912997984v1.png
pastedimage1669913011982v2.png
pastedimage1669913033935v3.png

Thanks, 

I have the same question (0)
  • Bharani Preetham Peraka Profile Picture
    3,634 Moderator on at

    Hi,

    In the view also for the metadata, you have the property called allow crosscompany. Make that also yes. Then try opening that view from table browser. Make sure all the ds in the query/view should have allow crosscompany to yes/true.

    If these doesn't work, then you can write in the query init method like, this.query.allowcrosscompany(true);

    Thanks,

    Bharani Preetham

  • Verified answer
    GirishS Profile Picture
    27,827 Moderator on at

    Hi bois,

    How you are checking that cross company data is not showing?

    Because i think if you open the view in table browser with cross company query it will not show cross company data.

    Also you need to add the cross company keyword in code to get cross company data.

    Refer to the below documentation.

    https://learn.microsoft.com/en-us/dynamicsax-2012/developer/cross-company-queries-for-views

    Thanks 

    Girish S.

  • bois0155 Profile Picture
    260 on at

    Thanks, I was opening the view in the table browser. It is working now.

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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 592 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 478 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 305 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans