details: https://code.openbravo.com/erp/devel/pi/rev/7a398be57eab
changeset: 25154:7a398be57eab
user: Reinaldo Guerra <reinaldo.guerra <at> peoplewalking.com>
date: Tue Oct 28 00:38:28 2014 -0500
summary: Fixed bug 27110: It is not possible to delete Invoice header due to
linked items
On delete action rule was changed in table m_inout for foreing key named:
m_inout_c_invoice, to set null c_invoice record when deleting sales invoices
related in goods shipment window.
Now is possible to delete a sales invoice although appears related in goods
shipment window.
diffstat:
src-db/database/model/tables/M_INOUT.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 205fdc530e40 -r 7a398be57eab src-db/database/model/tables/M_INOUT.xml
--- a/src-db/database/model/tables/M_INOUT.xml Tue Oct 28 16:14:40 2014 +0100
+++ b/src-db/database/model/tables/M_INOUT.xml Tue Oct 28 00:38:28 2014 -0500
@@ -299,7 +299,7 @@
<foreign-key foreignTable="C_DOCTYPE" name="M_INOUT_C_DOCTYPE">
<reference local="C_DOCTYPE_ID" foreign="C_DOCTYPE_ID"/>
</foreign-key>
- <foreign-key foreignTable="C_INVOICE" name="M_INOUT_C_INVOICE">
+ <foreign-key foreignTable="C_INVOICE" name="M_INOUT_C_INVOICE"
onDelete="setnull">
<reference local="C_INVOICE_ID" foreign="C_INVOICE_ID"/>
</foreign-key>
<foreign-key foreignTable="C_ORDER" name="M_INOUT_C_ORDER">
------------------------------------------------------------------------------
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
