Share
Report
8Hello,
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
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 (
Answers (
