Index: AXimpl/Controle/Order/OrderLijn.cls.xml =================================================================== diff -u -r43042 -r44118 --- AXimpl/Controle/Order/OrderLijn.cls.xml (.../OrderLijn.cls.xml) (revision 43042) +++ AXimpl/Controle/Order/OrderLijn.cls.xml (.../OrderLijn.cls.xml) (revision 44118) @@ -7,18 +7,50 @@ AXimpl.Controle.Order.Admin.OrderLijn + +%String + + + +%String + + %String + +%String + + %String + +%String + + + +%String + + %String + +%String + + + +%String + + + +%String + + %String Index: AXimpl/Controle/Order/Ax/AxOrderLijnConverter.cls.xml =================================================================== diff -u -r43052 -r44118 --- AXimpl/Controle/Order/Ax/AxOrderLijnConverter.cls.xml (.../AxOrderLijnConverter.cls.xml) (revision 43052) +++ AXimpl/Controle/Order/Ax/AxOrderLijnConverter.cls.xml (.../AxOrderLijnConverter.cls.xml) (revision 44118) @@ -9,13 +9,24 @@ Index: AXimpl/Controle/Order/Ax/AxOrderLijnIterator.cls.xml =================================================================== diff -u -r44104 -r44118 --- AXimpl/Controle/Order/Ax/AxOrderLijnIterator.cls.xml (.../AxOrderLijnIterator.cls.xml) (revision 44104) +++ AXimpl/Controle/Order/Ax/AxOrderLijnIterator.cls.xml (.../AxOrderLijnIterator.cls.xml) (revision 44118) @@ -37,31 +37,38 @@ 1 = 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 " + Set SqlStatement = "select salesLine.SalesId,salesLine.CustAccount,salesline.inventtransid,salesline.itemid,salesline.CONFIRMEDDLV,salesline.QtyOrdered" + // Toevoeging velden iteratie 2... + _",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,'') as CountryRegionId" + _",isnull(LogisticsPostalAddress.City,'') as City" + _",isnull(LogisticsPostalAddress.Street,'') as Street" + _",isnull(LogisticsPostalAddress.Zipcode,'') as Zipcode" + // Einde toevoeging velden iteratie 2, rest van iteratie 1... + _" 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) ]]> Index: AXimpl/Controle/Order/Admin/AdminOrderLijnConverter.cls.xml =================================================================== diff -u -r43664 -r44118 --- AXimpl/Controle/Order/Admin/AdminOrderLijnConverter.cls.xml (.../AdminOrderLijnConverter.cls.xml) (revision 43664) +++ AXimpl/Controle/Order/Admin/AdminOrderLijnConverter.cls.xml (.../AdminOrderLijnConverter.cls.xml) (revision 44118) @@ -39,13 +39,24 @@ Index: vhUnitTest/AXimpl/Controle/Order/Admin/AdminOrderLijnConverter/Test.cls.xml =================================================================== diff -u -r43664 -r44118 --- vhUnitTest/AXimpl/Controle/Order/Admin/AdminOrderLijnConverter/Test.cls.xml (.../Test.cls.xml) (revision 43664) +++ vhUnitTest/AXimpl/Controle/Order/Admin/AdminOrderLijnConverter/Test.cls.xml (.../Test.cls.xml) (revision 44118) @@ -54,6 +54,13 @@ ]]> + + + + + + + + 1 DOM.PM.impl.ProductImpl Index: AXimpl/Controle/Order/OrderLijnControleGenerator.cls.xml =================================================================== diff -u -r43699 -r44118 --- AXimpl/Controle/Order/OrderLijnControleGenerator.cls.xml (.../OrderLijnControleGenerator.cls.xml) (revision 43699) +++ AXimpl/Controle/Order/OrderLijnControleGenerator.cls.xml (.../OrderLijnControleGenerator.cls.xml) (revision 44118) @@ -70,13 +70,25 @@