Index: AXimpl/Admin/STAT/Invoice/LineIterator.cls.xml
===================================================================
diff -u -r55834 -r58808
--- AXimpl/Admin/STAT/Invoice/LineIterator.cls.xml	(.../LineIterator.cls.xml)	(revision 55834)
+++ AXimpl/Admin/STAT/Invoice/LineIterator.cls.xml	(.../LineIterator.cls.xml)	(revision 58808)
@@ -49,17 +49,18 @@
 		_" 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, 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"
+		_"   (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"
 		_" JOIN CustInvoiceJour ON CustInvoiceJour.InvoiceId = CustInvoiceTrans.InvoiceId AND CustInvoiceJour.InvoiceDate = CustInvoiceTrans.InvoiceDate"
 		_"   AND CustInvoiceJour.DataAreaId = CustInvoiceTrans.DataAreaId AND CustInvoiceJour.Partition = CustInvoiceTrans.Partition"
 		_" LEFT OUTER JOIN AduEcoresAttributeCombinatiON COM ON com.ItemId = CustInvoiceTrans.ItemId AND com.ConfigId = InventDim.ConfigId  AND InventDim.ConfigId <> ''"
 		_"   AND com.PARTITION = CUSTINVOICETRANS.PARTITION"
 		_" WHERE CustInvoiceTrans.InvoiceDate >= '"_FirstDate_"' AND CustInvoiceTrans.InvoiceDate <= '"_LastDate_"' AND CustInvoiceTrans.ItemId <> ''"
+		_"   AND (custinvoicetrans.invoiceid like 'VF%' or custinvoicetrans.invoiceid like 'VC%' )"
 		_"   AND custinvoicetrans.DATAAREAID = 'vhbe' AND CUSTINVOICETRANS.PARTITION = '5637144576'"
 		_" ORDER BY CustInvoiceJour.InvoiceAccount, CustInvoiceTrans.ItemId"