details: /erp/devel/pi/rev/d42db16889e8
changeset: 8008:d42db16889e8
user: Sathiyan Sivaprakasam <sathiyan.sivaprakasam <at> openbravo.com>
date: Tue Aug 03 17:08:58 2010 +0530
summary: Fixes Issue 13958: cursor incorrect in process c_bankstatement_post
diffstat:
src-db/database/model/functions/C_BANKSTATEMENT_POST.xml | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diffs (23 lines):
diff -r 44967d45c991 -r d42db16889e8
src-db/database/model/functions/C_BANKSTATEMENT_POST.xml
--- a/src-db/database/model/functions/C_BANKSTATEMENT_POST.xml Tue Aug 03
14:41:26 2010 +0530
+++ b/src-db/database/model/functions/C_BANKSTATEMENT_POST.xml Tue Aug 03
17:08:58 2010 +0530
@@ -145,7 +145,7 @@
v_ResultStr := 'Reversed';
--Unpost Settlement
- FOR Cur_AutomaticSettlementCancel IN (SELECT DISTINCT S.C_SETTLEMENT_ID
+ FOR Cur_AutomaticSettlementCancel IN (SELECT DISTINCT S.C_SETTLEMENT_ID,
DP.C_BPartner_ID
FROM C_DEBT_PAYMENT DP, C_SETTLEMENT S
WHERE DP.C_SETTLEMENT_CANCEL_ID = S.C_SETTLEMENT_ID
AND DP.C_BANKSTATEMENTLINE_ID IN
@@ -170,8 +170,8 @@
FOR Cur_Debts IN
(SELECT DISTINCT C_BPartner_ID
FROM C_DEBT_PAYMENT
- WHERE
C_Settlement_Cancel_ID=Cur_AutomaticSettlementCancel.C_SETTLEMENT_ID
- OR C_Settlement_Cancel_ID IS NULL
+ WHERE
+ C_BPartner_ID = Cur_AutomaticSettlementCancel.C_BPartner_ID
OR
C_Settlement_Generate_ID=Cur_AutomaticSettlementCancel.C_SETTLEMENT_ID AND
ISRECEIPT = 'Y'
)
LOOP
------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
