Fixes issue 0009104 Removed ^M at the end of the lines.
authorRafa Roda Palacios <rafael.roda@openbravo.com>
Tue, 02 Jun 2009 10:56:32 +0200
changeset 3943 7eecddf0cf81
parent 3942 ec6df6099183
child 3944 497df2a505ef
child 4516 3ed7ddf0f789
Fixes issue 0009104 Removed ^M at the end of the lines.
src-db/database/sourcedata/AD_VAL_RULE.xml
--- a/src-db/database/sourcedata/AD_VAL_RULE.xml	Tue Jun 02 14:29:19 2009 +1000
+++ b/src-db/database/sourcedata/AD_VAL_RULE.xml	Tue Jun 02 10:56:32 2009 +0200
@@ -288,13 +288,13 @@
 <!--134-->  <NAME><![CDATA[C_Order SO to be invoiced]]></NAME>
 <!--134-->  <DESCRIPTION><![CDATA[Ordered <> Invoiced]]></DESCRIPTION>
 <!--134-->  <TYPE><![CDATA[S]]></TYPE>
-<!--134-->  <CODE><![CDATA[IsSOTrx='Y' AND DocStatus NOT IN ('DR','IP') 
-AND ((InvoiceRule = 'O'
-AND NOT EXISTS (SELECT 1 FROM C_OrderLine WHERE C_Order.C_Order_ID=C_OrderLine.C_Order_ID AND QtyOrdered <> QtyDelivered)
-AND EXISTS (SELECT 1 FROM C_OrderLine WHERE C_Order.C_Order_ID=C_OrderLine.C_Order_ID AND QtyOrdered <> QtyInvoiced))
-OR (InvoiceRule = 'D'
-AND EXISTS (SELECT 1 FROM C_OrderLine WHERE C_Order.C_Order_ID=C_OrderLine.C_Order_ID AND QtyOrdered <> QtyInvoiced AND QtyDelivered <> QtyInvoiced))
-OR (InvoiceRule = 'I'
+<!--134-->  <CODE><![CDATA[IsSOTrx='Y' AND DocStatus NOT IN ('DR','IP') 
+AND ((InvoiceRule = 'O'
+AND NOT EXISTS (SELECT 1 FROM C_OrderLine WHERE C_Order.C_Order_ID=C_OrderLine.C_Order_ID AND QtyOrdered <> QtyDelivered)
+AND EXISTS (SELECT 1 FROM C_OrderLine WHERE C_Order.C_Order_ID=C_OrderLine.C_Order_ID AND QtyOrdered <> QtyInvoiced))
+OR (InvoiceRule = 'D'
+AND EXISTS (SELECT 1 FROM C_OrderLine WHERE C_Order.C_Order_ID=C_OrderLine.C_Order_ID AND QtyOrdered <> QtyInvoiced AND QtyDelivered <> QtyInvoiced))
+OR (InvoiceRule = 'I'
 AND EXISTS (SELECT 1 FROM C_OrderLine WHERE C_Order.C_Order_ID=C_OrderLine.C_Order_ID AND QtyOrdered <> QtyInvoiced)))]]></CODE>
 <!--134-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--134--></AD_VAL_RULE>
@@ -307,17 +307,17 @@
 <!--135-->  <NAME><![CDATA[C_BPartner w SO to invoice]]></NAME>
 <!--135-->  <DESCRIPTION><![CDATA[BPartners with invoices to be invoiced]]></DESCRIPTION>
 <!--135-->  <TYPE><![CDATA[S]]></TYPE>
-<!--135-->  <CODE><![CDATA[C_BPartner_ID IN (
-SELECT DISTINCT C_BPartner_ID
-FROM c_order
-WHERE IsSOTrx='Y'
-AND DocStatus NOT IN ('DR','IP') 
-AND ((InvoiceRule = 'O'
-AND NOT EXISTS (SELECT 1 FROM C_OrderLine WHERE C_Order.C_Order_ID=C_OrderLine.C_Order_ID AND QtyOrdered <> QtyDelivered)
-AND EXISTS (SELECT 1 FROM C_OrderLine WHERE C_Order.C_Order_ID=C_OrderLine.C_Order_ID AND QtyOrdered <> QtyInvoiced))
-OR (InvoiceRule = 'D'
-AND EXISTS (SELECT 1 FROM C_OrderLine WHERE C_Order.C_Order_ID=C_OrderLine.C_Order_ID AND QtyOrdered <> QtyInvoiced AND QtyDelivered <> QtyInvoiced))
-OR (InvoiceRule = 'I'
+<!--135-->  <CODE><![CDATA[C_BPartner_ID IN (
+SELECT DISTINCT C_BPartner_ID
+FROM c_order
+WHERE IsSOTrx='Y'
+AND DocStatus NOT IN ('DR','IP') 
+AND ((InvoiceRule = 'O'
+AND NOT EXISTS (SELECT 1 FROM C_OrderLine WHERE C_Order.C_Order_ID=C_OrderLine.C_Order_ID AND QtyOrdered <> QtyDelivered)
+AND EXISTS (SELECT 1 FROM C_OrderLine WHERE C_Order.C_Order_ID=C_OrderLine.C_Order_ID AND QtyOrdered <> QtyInvoiced))
+OR (InvoiceRule = 'D'
+AND EXISTS (SELECT 1 FROM C_OrderLine WHERE C_Order.C_Order_ID=C_OrderLine.C_Order_ID AND QtyOrdered <> QtyInvoiced AND QtyDelivered <> QtyInvoiced))
+OR (InvoiceRule = 'I'
 AND EXISTS (SELECT 1 FROM C_OrderLine WHERE C_Order.C_Order_ID=C_OrderLine.C_Order_ID AND QtyOrdered <> QtyInvoiced))))]]></CODE>
 <!--135-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--135--></AD_VAL_RULE>