details: https://code.openbravo.com/erp/devel/pi/rev/89ab64d75b34
changeset: 14024:89ab64d75b34
user: Jon AlegrÃa <jon.alegria <at> openbravo.com>
date: Wed Oct 19 10:13:56 2011 +0200
summary: Fixes issue 0018687: Matched invoice transaction date not updated
when
associated invoice is reactivated and accounting date is modified
diffstat:
src-db/database/model/triggers/C_INVOICE_TRG.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 0234c059f533 -r 89ab64d75b34
src-db/database/model/triggers/C_INVOICE_TRG.xml
--- a/src-db/database/model/triggers/C_INVOICE_TRG.xml Wed Oct 19 08:27:44
2011 +0200
+++ b/src-db/database/model/triggers/C_INVOICE_TRG.xml Wed Oct 19 10:13:56
2011 +0200
@@ -81,7 +81,7 @@
END IF;
END IF;
- IF ((COALESCE(:OLD.DATEACCT, TO_DATE('31-12-9999', 'DD-MM-YYYY')) <>
COALESCE(:NEW.DATEACCT, TO_DATE('31-12-9999', 'DD-MM-YYYY'))) AND
:new.DOCSTATUS NOT IN ('DR', 'RE')) THEN
+ IF ((COALESCE(:OLD.DATEACCT, TO_DATE('31-12-9999', 'DD-MM-YYYY')) <>
COALESCE(:NEW.DATEACCT, TO_DATE('31-12-9999', 'DD-MM-YYYY'))) AND
:new.DOCSTATUS NOT IN ('RE')) THEN
SELECT COUNT(*) INTO V_COUNT FROM M_MATCHINV M WHERE
M.C_INVOICELINE_ID IN (SELECT C.C_INVOICELINE_ID FROM C_INVOICELINE C WHERE
C.C_INVOICE_ID = :old.C_INVOICE_ID)
AND M.M_INOUTLINE_ID IN
(SELECT C.M_INOUTLINE_ID FROM C_INVOICELINE C WHERE C.C_INVOICE_ID =
:old.C_INVOICE_ID)
AND M.POSTED = 'Y';
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2d-oct
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
