Get intercompany details of sales order in a single view

(1) Share

Report

Posted on by Jason0810M

Hello,

I need to get the intercompany details of a sales order in a single view.

I have created a cross company query for sales line of type sales and status backorder and the related purchase order line needs to be of drop ship delivery type:

However, the view is not returning any records.

I have made a T SQL statement in msssql and there are records:
select * from salestable a1, salesline a2, purchline a3
where a1.SALESID=a2.SALESID and
a2.INVENTTRANSID=a3.INTERCOMPANYINVENTTRANSID and
a3.DATAAREAID = a1.INTERCOMPANYCOMPANYID and
a1.INTERCOMPANYDIRECTDELIVERY=1 and
a2.SALESSTATUS=1
and a2.SALESTYPE=3 and
a3.DELIVERYTYPE=1

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Waed Ayyad 9,023 Super User 2025 Season 2 on at

Like (0)

Report

Get intercompany details of sales order in a single view

Hi @Jason0810M,

Please refer to MS Document:

"In the Application Object Tree (AOT), you can build a view by dragging a query node onto the Data Sources node of your view. The query could have the AllowCrossCompany property set to Yes. However, this will not return cross-company results from the view.
To return cross-company results from a view, you need to use the crossCompany keyword on the select statement that reads from the view. The AllowCrossCompany setting on the view's data source query is ignored in X++ select statements that read from a view."

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

Thanks,

Waed Ayyad

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No