details: /erp/devel/main/rev/d1918edfe47e
changeset: 8446:d1918edfe47e
user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
date: Tue Sep 21 11:06:11 2010 +0200
summary: Fixes bug 0014629: G/L Item: Tax field is inactive and has to be
active
details: /erp/devel/main/rev/023f3e0221ac
changeset: 8447:023f3e0221ac
user: Adrián Romero <adrianromero <at> openbravo.com>
date: Tue Sep 21 13:22:49 2010 +0200
summary: Fixes issue 0014634: Cannot unprocess a bank statement with more
than one business partner
It has been reverted the fix created in issue 13958 and applied a proper fix
that consist in only removing the condition C_Settlement_Cancel_ID IS NULL when
selecting business partners to update
details: /erp/devel/main/rev/87617bcebd82
changeset: 8448:87617bcebd82
user: Adrián Romero <adrianromero <at> openbravo.com>
date: Wed Sep 22 13:13:54 2010 +0200
summary: Fixes issue 0014634: Cannot unprocess a bank statement with more
than one business partner
It has been fixed the sentence that gets the business partners to update
diffstat:
src-db/database/model/functions/C_BANKSTATEMENT_POST.xml | 9 ++++-----
src-db/database/sourcedata/AD_FIELD.xml | 2 +-
2 files changed, 5 insertions(+), 6 deletions(-)
diffs (38 lines):
diff -r d7c675d41460 -r 87617bcebd82
src-db/database/model/functions/C_BANKSTATEMENT_POST.xml
--- a/src-db/database/model/functions/C_BANKSTATEMENT_POST.xml Mon Sep 20
20:08:30 2010 +0000
+++ b/src-db/database/model/functions/C_BANKSTATEMENT_POST.xml Wed Sep 22
13:13:54 2010 +0200
@@ -145,7 +145,7 @@
v_ResultStr := 'Reversed';
--Unpost Settlement
- FOR Cur_AutomaticSettlementCancel IN (SELECT DISTINCT S.C_SETTLEMENT_ID,
DP.C_BPartner_ID
+ FOR Cur_AutomaticSettlementCancel IN (SELECT DISTINCT S.C_SETTLEMENT_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
@@ -169,10 +169,9 @@
BEGIN
FOR Cur_Debts IN
(SELECT DISTINCT C_BPartner_ID
- FROM C_DEBT_PAYMENT
- WHERE
- C_BPartner_ID = Cur_AutomaticSettlementCancel.C_BPartner_ID
- OR
C_Settlement_Generate_ID=Cur_AutomaticSettlementCancel.C_SETTLEMENT_ID AND
ISRECEIPT = 'Y'
+ FROM C_DEBT_PAYMENT, C_BANKSTATEMENTLINE
+ WHERE C_DEBT_PAYMENT.C_DEBT_PAYMENT_ID =
C_BANKSTATEMENTLINE.C_DEBT_PAYMENT_ID
+ AND C_BANKSTATEMENTLINE.C_BANKSTATEMENT_ID = v_Record_ID
)
LOOP
C_BP_SOCREDITUSED_REFRESH(Cur_Debts.C_BPartner_ID) ;
diff -r d7c675d41460 -r 87617bcebd82 src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/sourcedata/AD_FIELD.xml Mon Sep 20 20:08:30 2010 +0000
+++ b/src-db/database/sourcedata/AD_FIELD.xml Wed Sep 22 13:13:54 2010 +0200
@@ -203772,7 +203772,7 @@
<!--C92612B656AC11DEBB69837DC96AB39A-->
<AD_FIELD_ID><![CDATA[C92612B656AC11DEBB69837DC96AB39A]]></AD_FIELD_ID>
<!--C92612B656AC11DEBB69837DC96AB39A-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
<!--C92612B656AC11DEBB69837DC96AB39A--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--C92612B656AC11DEBB69837DC96AB39A--> <ISACTIVE><![CDATA[N]]></ISACTIVE>
+<!--C92612B656AC11DEBB69837DC96AB39A--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--C92612B656AC11DEBB69837DC96AB39A--> <NAME><![CDATA[Tax]]></NAME>
<!--C92612B656AC11DEBB69837DC96AB39A--> <DESCRIPTION><![CDATA[The percentage
of money requested by the government for this specified product or
transaction.]]></DESCRIPTION>
<!--C92612B656AC11DEBB69837DC96AB39A--> <HELP><![CDATA[The Tax indicates the
type of tax for this document line.]]></HELP>
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
