Index: AXimpl/Controle/Order/Ax/AxOrderLijnIterator.cls.xml
===================================================================
diff -u -r43780 -r44104
--- AXimpl/Controle/Order/Ax/AxOrderLijnIterator.cls.xml	(.../AxOrderLijnIterator.cls.xml)	(revision 43780)
+++ AXimpl/Controle/Order/Ax/AxOrderLijnIterator.cls.xml	(.../AxOrderLijnIterator.cls.xml)	(revision 44104)
@@ -38,13 +38,29 @@
 <Implementation><![CDATA[
 	#Dim SqlStatement as %String
 	
+	// Iteratie 1:
 	Set SqlStatement = "select salesLine.SalesId,salesLine.CustAccount,salesline.inventtransid,salesline.itemid,salesline.CONFIRMEDDLV,salesline.QtyOrdered "
 	_"from SALESLINE join inventdim on inventdim.INVENTDIMID = salesline.INVENTDIMID and inventdim.DATAAREAID = SALESLINE.DATAAREAID and inventdim.PARTITION = salesline.PARTITION "
 	_"join SALESTABLE on SALESTABLE.SALESID = salesline.SALESID and SALESTABLE.DATAAREAID = salesline.DATAAREAID and salestable.PARTITION = salesline.PARTITION "
 	_"left outer join LOGISTICSPOSTALADDRESS on LOGISTICSPOSTALADDRESS.RECID = salesline.DELIVERYPOSTALADDRESS and LOGISTICSPOSTALADDRESS.PARTITION = salesline.PARTITION "
 	_"join INVENTTRANSORIGIN on INVENTTRANSORIGIN.INVENTTRANSID = salesline.INVENTTRANSID and INVENTTRANSORIGIN.DATAAREAID = salesline.DATAAREAID and INVENTTRANSORIGIN.PARTITION = salesline.PARTITION "
-	_"where salestable.SALESSTATUS = 1  -- Backorder and salestable.DOCUMENTSTATUS >= 1  --- minstens Bevestigd and salesline.SALESQTY >= 0  --- geen retour-lijnen (terugnames) "
+	_"where salestable.SALESSTATUS = 1 and salestable.DOCUMENTSTATUS >= 1 and salesline.SALESQTY >= 0 "
 	_"and salesLine.DATAAREAID = 'VHBE' and salesline.PARTITION = '5637144576'"
+
+	/*
+	// Iteratie 2:
+	Set SqlStatement = "select salesLine.SalesId,salesLine.CustAccount,salesline.inventtransid,salesline.itemid,salesline.CONFIRMEDDLV,salesline.QtyOrdered,"
+	_"isnull(( select -sum(qty) from inventtrans where INVENTTRANSORIGIN.RECID = inventtrans.INVENTTRANSORIGIN and INVENTTRANS.STATUSISSUE = 3 and "
+	_"inventtrans.STATUSRECEIPT = 0 and inventtrans.DATAAREAID = INVENTTRANSORIGIN.DATAAREAID and inventtrans.PARTITION = INVENTTRANSORIGIN.PARTITION),0) as gepickteHoeveelheid,"
+	_"salesline.REMAINSALESPHYSICAL as openstaandeHoeveelheid,CONFIGID,inventtransorigin.ADUSOPRContractId,isnull(LogisticsPostalAddress.CountryRegionId,''),"
+	_"isnull(LogisticsPostalAddress.City,''),isnull(LogisticsPostalAddress.Street,''),isnull(LogisticsPostalAddress.Zipcode,'') from SALESLINE "
+	_"join inventdim on inventdim.INVENTDIMID = salesline.INVENTDIMID and inventdim.DATAAREAID = SALESLINE.DATAAREAID and inventdim.PARTITION = salesline.PARTITION "
+	_"join SALESTABLE on SALESTABLE.SALESID = salesline.SALESID and SALESTABLE.DATAAREAID = salesline.DATAAREAID and salestable.PARTITION = salesline.PARTITION "
+	_"left outer join LOGISTICSPOSTALADDRESS on LOGISTICSPOSTALADDRESS.RECID = salesline.DELIVERYPOSTALADDRESS and LOGISTICSPOSTALADDRESS.PARTITION = salesline.PARTITION "
+	_"join INVENTTRANSORIGIN on INVENTTRANSORIGIN.INVENTTRANSID = salesline.INVENTTRANSID and INVENTTRANSORIGIN.DATAAREAID = salesline.DATAAREAID and "
+	_"INVENTTRANSORIGIN.PARTITION = salesline.PARTITION where salestable.SALESSTATUS = 1 and salestable.DOCUMENTSTATUS >= 1 and salesline.SALESQTY >= 0 "
+	_"and salesLine.DATAAREAID = 'VHBE' and salesline.PARTITION = '5637144576'"
+	*/
 	
 	Set ..ResultSet = ..SqlQueryConnection.GetResultSet(SqlStatement)
 ]]></Implementation>