Index: AXimpl/Admin/STAT/Invoice/LineIterator.cls.xml =================================================================== diff -u -r55822 -r55834 --- AXimpl/Admin/STAT/Invoice/LineIterator.cls.xml (.../LineIterator.cls.xml) (revision 55822) +++ AXimpl/Admin/STAT/Invoice/LineIterator.cls.xml (.../LineIterator.cls.xml) (revision 55834) @@ -49,8 +49,9 @@ _" LEFT OUTER JOIN INVENTTRANSORIGIN ito ON CustInvoiceTrans.inventTransId = ito.INVENTTRANSID AND ito.DATAAREAID = CustInvoiceTrans.DATAAREAID" _" AND CustInvoiceTrans.PARTITION = ito.PARTITION" _" LEFT OUTER JOIN" - _" (SELECT SUM(Qty) Qty, SUM(REVENUEAMOUNTPHYSICAL) REVENUEAMOUNTPHYSICAL, SUM(COSTAMOUNTOPERATIONS) COSTAMOUNTOPERATIONS, dataareaid, partition, inventtransorigin, invoiceid" - _" FROM inventtrans it1 GROUP BY dataareaid, inventtransorigin, invoiceid, PARTITION) it ON it.INVENTTRANSORIGIN = ito.recid AND it.DATAAREAID = ito.DATAAREAID" + _" (SELECT SUM(Qty) Qty, SUM(REVENUEAMOUNTPHYSICAL) REVENUEAMOUNTPHYSICAL, SUM(COSTAMOUNTOPERATIONS) COSTAMOUNTOPERATIONS, SUM(ADUSOPRCOSTAMOUNTPOSTED) AS ADUSOPRCOSTAMOUNTPOSTED," + _" dataareaid, partition, inventtransorigin, invoiceid FROM inventtrans it1" + _" GROUP BY dataareaid, inventtransorigin, invoiceid, PARTITION) it ON it.INVENTTRANSORIGIN = ito.recid AND it.DATAAREAID = ito.DATAAREAID" _" AND it.INVOICEID = CustInvoiceTrans.INVOICEID AND it.PARTITION = CustInvoiceTrans.PARTITION" _" JOIN InventDim ON InventDim.InventDimId = CustInvoiceTrans.InventDimId AND InventDim.DataAreaId = CustInvoiceTrans.DataAreaId" _" AND inventdim.PARTITION = custinvoicetrans.PARTITION"