details: https://code.openbravo.com/erp/devel/pi/rev/d5a54ef8d574
changeset: 18201:d5a54ef8d574
user: David Miguelez <david.miguelez <at> openbravo.com>
date: Thu Oct 11 13:33:05 2012 +0200
summary: Fixes issue 21915. Fixes database consistency.
diffstat:
src-db/database/model/functions/C_INVOICE_CREATE.xml | 4 ++--
src-db/database/model/tables/C_INVOICELINE.xml | 2 +-
src-db/database/model/tables/C_ORDERLINE.xml | 2 +-
3 files changed, 4 insertions(+), 4 deletions(-)
diffs (45 lines):
diff -r 9b0c261d48cb -r d5a54ef8d574
src-db/database/model/functions/C_INVOICE_CREATE.xml
--- a/src-db/database/model/functions/C_INVOICE_CREATE.xml Thu Oct 11
13:11:56 2012 +0200
+++ b/src-db/database/model/functions/C_INVOICE_CREATE.xml Thu Oct 11
13:33:05 2012 +0200
@@ -580,7 +580,7 @@
ptr_sl.QuantityOrder, ptr_sl.M_Product_Uom_ID,
ptr_sl.PriceStd,
ptr_sl.m_attributesetinstance_id, ptr_sl.taxbaseamt,
ptr_sl.gross_unit_price,
C_Currency_Round(ptr_sl.MovementQty*ptr_sl.gross_unit_price,
Cur_Order.C_Currency_ID, NULL),
- COALESCE(ptr_ol.grosspricestd,0),
COALESCE(ptr_ol.grosspricelist,0)
+ COALESCE(ptr_sl.grosspricestd,0),
COALESCE(ptr_sl.grosspricelist,0)
)
;
END IF;--Next_S_Line
@@ -1077,7 +1077,7 @@
Cur_InvoiceSchedule.QuantityOrder,
Cur_InvoiceSchedule.M_Product_Uom_ID, Cur_InvoiceSchedule.PriceStd,
Cur_InvoiceSchedule.m_attributesetinstance_id,
Cur_InvoiceSchedule.taxbaseamt,
Cur_InvoiceSchedule.gross_unit_price,
C_Currency_Round(Cur_InvoiceSchedule.MovementQty*Cur_InvoiceSchedule.gross_unit_price,
Cur_InvoiceSchedule.C_Currency_ID, NULL),
- COALESCE(ptr_ol.grosspricestd,0),
COALESCE(ptr_ol.grosspricelist,0)
+ COALESCE(Cur_InvoiceSchedule.grosspricestd,0),
COALESCE(Cur_InvoiceSchedule.grosspricelist,0)
)
;
v_DateOrdered:=COALESCE(Cur_InvoiceSchedule.movementDate,
COALESCE(Cur_InvoiceSchedule.DateOrdered, now())) ;
diff -r 9b0c261d48cb -r d5a54ef8d574
src-db/database/model/tables/C_INVOICELINE.xml
--- a/src-db/database/model/tables/C_INVOICELINE.xml Thu Oct 11 13:11:56
2012 +0200
+++ b/src-db/database/model/tables/C_INVOICELINE.xml Thu Oct 11 13:33:05
2012 +0200
@@ -161,7 +161,7 @@
<default><![CDATA[0]]></default>
<onCreateDefault/>
</column>
- <column name="grosspricestd" primaryKey="false" required="true"
type="DECIMAL" autoIncrement="false">
+ <column name="GROSSPRICESTD" primaryKey="false" required="true"
type="DECIMAL" autoIncrement="false">
<default><![CDATA[0]]></default>
<onCreateDefault/>
</column>
diff -r 9b0c261d48cb -r d5a54ef8d574
src-db/database/model/tables/C_ORDERLINE.xml
--- a/src-db/database/model/tables/C_ORDERLINE.xml Thu Oct 11 13:11:56
2012 +0200
+++ b/src-db/database/model/tables/C_ORDERLINE.xml Thu Oct 11 13:33:05
2012 +0200
@@ -213,7 +213,7 @@
<default/>
<onCreateDefault/>
</column>
- <column name="grosspricestd" primaryKey="false" required="true"
type="DECIMAL" autoIncrement="false">
+ <column name="GROSSPRICESTD" primaryKey="false" required="true"
type="DECIMAL" autoIncrement="false">
<default><![CDATA[0]]></default>
<onCreateDefault/>
</column>
------------------------------------------------------------------------------
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
