Index: AXimpl/Controle/OrdDiff/AX/AxOrderLijnIterator.cls.xml =================================================================== diff -u -r73979 -r73982 --- AXimpl/Controle/OrdDiff/AX/AxOrderLijnIterator.cls.xml (.../AxOrderLijnIterator.cls.xml) (revision 73979) +++ AXimpl/Controle/OrdDiff/AX/AxOrderLijnIterator.cls.xml (.../AxOrderLijnIterator.cls.xml) (revision 73982) @@ -48,8 +48,8 @@ _" ,isnull(LogisticsPostalAddress.City,'') as CITY " _" ,isnull(LogisticsPostalAddress.Street,'') as STREET " _" ,isnull(LogisticsPostalAddress.Zipcode,'') as ZIPCODE " - _" ,isnull(LogisticsPostalAddress.ProductHash,'') as PRODUCTHASH " - _" ,isnull(LogisticsPostalAddress.CID,'') as CID " + _" ,ADUConfiguredProductLog.ProductHash as PRODUCTHASH " + _" ,ADUConfiguredProductLog.CID as CID " _" ,(select top 1 r.LOG from VHVALENTITYRUN r where r.PARTITION = SALESTABLE.PARTITION and r.DATAAREAID = SALESTABLE.DATAAREAID and r.ENTITY = 2 and r.REFRECID = SALESTABLE.recid and r.STATUS in (2,3) and SALESTABLE.DOCUMENTSTATUS=0 ) as VALIDATIECODE " _" from SALESLINE " _" join inventdim on inventdim.INVENTDIMID = salesline.INVENTDIMID and inventdim.DATAAREAID = SALESLINE.DATAAREAID and inventdim.PARTITION = salesline.PARTITION " @@ -68,10 +68,8 @@ _" left outer join ECORESPRODUCTTRANSLATION transNL " _" on transNL.PRODUCT = Resproduct.RECID and transNL.LANGUAGEID='nl-be' and inventdim.partition=transNL.PARTITION " _" left outer join LOGISTICSPOSTALADDRESS on LOGISTICSPOSTALADDRESS.RECID = salesline.DELIVERYPOSTALADDRESS and LOGISTICSPOSTALADDRESS.PARTITION = salesline.PARTITION " - _" left outer join ADUCONFIGUREDPRODUCTLOG ADUConfiguredProductLog " - _" on idc.DISTINCTPRODUCTVARIANT= ADUConfiguredProductLog.EcoResDistinctProductVariant and ADUConfiguredProductLog.PARTITION = SALESLINE.PARTITION and ADUConfiguredProductLog.DATAAREAID = salesline.DATAAREAID where ADUConfiguredProductLog.Active = 1" - + _" on Idc.DISTINCTPRODUCTVARIANT = ADUConfiguredProductLog.EcoResDistinctProductVariant and ADUConfiguredProductLog.PARTITION = SALESLINE.PARTITION and ADUConfiguredProductLog.DATAAREAID = salesline.DATAAREAID and ADUConfiguredProductLog.Active = 1 " _" join INVENTTRANSORIGIN on INVENTTRANSORIGIN.INVENTTRANSID = salesline.INVENTTRANSID and INVENTTRANSORIGIN.DATAAREAID = salesline.DATAAREAID and " _" INVENTTRANSORIGIN.PARTITION = salesline.PARTITION " _" Left outer join (select ito.INVENTTRANSID, -sum(qty) as QtyOpBon "