details: /erp/devel/pi/rev/90d6e572d0cb
changeset: 7322:90d6e572d0cb
user: David Alsasua <david.alsasua <at> openbravo.com>
date: Fri May 14 16:01:50 2010 +0530
summary: Fixes issue 13317
When modifying quantity of goods receipt line,
matched inoices related document is updated
details: /erp/devel/pi/rev/fd94cff939bd
changeset: 7323:fd94cff939bd
user: David Alsasua <david.alsasua <at> openbravo.com>
date: Fri May 14 16:15:57 2010 +0530
summary: Fixes issue 13234: Uncorrect Account Schema
diffstat:
src-db/database/model/triggers/M_INOUTLINE_TRG.xml | 11 +++++++++++
src/org/openbravo/erpCommon/info/Account.java | 6 +++---
2 files changed, 14 insertions(+), 3 deletions(-)
diffs (45 lines):
diff -r 0e9c7d0e8d23 -r fd94cff939bd
src-db/database/model/triggers/M_INOUTLINE_TRG.xml
--- a/src-db/database/model/triggers/M_INOUTLINE_TRG.xml Fri May 14
11:52:07 2010 +0200
+++ b/src-db/database/model/triggers/M_INOUTLINE_TRG.xml Fri May 14
16:15:57 2010 +0530
@@ -13,6 +13,7 @@
v_qtyorder NUMBER;
v_qtyold NUMBER;
v_qtyorderold NUMBER;
+ v_MatchInvCount NUMBER;
v_STOCKED NUMBER;
v_UOM_ID varchar2(32);
v_AttrSetValueType M_Product.AttrSetValueType%TYPE;
@@ -107,6 +108,16 @@
v_qtyorder := :NEW.QUANTITYORDER;
END IF;
+ SELECT COUNT(*) INTO v_MatchInvCount
+ FROM M_MATCHINV MI
+ WHERE MI.QTY = :OLD.MOVEMENTQTY
+ AND MI.M_INOUTLINE_ID = :NEW.M_INOUTLINE_ID;
+ IF (:OLD.MOVEMENTQTY <> :NEW.MOVEMENTQTY AND v_MatchInvCount=1) THEN
+ UPDATE M_MATCHINV SET QTY=:NEW.MOVEMENTQTY
+ WHERE QTY = :OLD.MOVEMENTQTY
+ AND M_INOUTLINE_ID = :NEW.M_INOUTLINE_ID;
+ END IF;
+
END IF;
diff -r 0e9c7d0e8d23 -r fd94cff939bd
src/org/openbravo/erpCommon/info/Account.java
--- a/src/org/openbravo/erpCommon/info/Account.java Fri May 14 11:52:07
2010 +0200
+++ b/src/org/openbravo/erpCommon/info/Account.java Fri May 14 16:15:57
2010 +0530
@@ -110,10 +110,10 @@
strPageSize, strNewFilter, strAcctSchema);
} else if (vars.commandIn("KEY")) {
String strKeyValue = vars.getRequestGlobalVariable("inpNameValue",
"Account.alias");
- String strAcctSchema = vars
- .getRequestGlobalVariable("inpAcctSchema", "Account.cAcctschemaId");
+ String strAcctSchema =
vars.getSessionValue(vars.getStringParameter("WindowID")
+ + "|C_AcctSchema_ID");
if (strAcctSchema.equals("")) {
- strAcctSchema = Utility.getContext(this, vars, "$C_AcctSchema_ID",
"Account");
+ strAcctSchema = vars.getRequestGlobalVariable("inpAcctSchema",
"Account.cAcctschemaId");
vars.setSessionValue("Account.cAcctschemaId", strAcctSchema);
}
vars.removeSessionValue("Account.combination");
------------------------------------------------------------------------------
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
