Hi all
Running AX 2012 R3 CU9
I have a query, which is based on multiple views. The views themselves are summaries of tables. My problem is as follows:
I've set the query to "allowCrossCompany" in properties, and it doesn't seem to respond to it as it does in the usual way. I'm assuming it's because the views aren't crossCompany.
However, when I change the equivalent view property under the Metadata node of the view, it still only returns the current company. All the documentation for cross-company views seems to assume I'm doing so from X++, which is unfeasible in this instance.
As there are a few of these views, I'd rather not invite any performance or maintenance overhead by rebuilding them all as individual queries feeding individual views. Can you pls advise if there's some way to tell a view in the AOT to display crossCompany? Also, what is that View Metadata node for, "allowCrossCompany", if it doesn't enable this?
Thanks for your help in advance
Luke
*This post is locked for comments