details: /erp/devel/pi/rev/6aa65b673861
changeset: 8574:6aa65b673861
user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
date: Tue Oct 19 17:18:06 2010 +0200
summary: Fixed bug 14717: the accounting generated in a bank statement, with
currency
distinct to schema currency, is not correct
The generated payment is created with the same date as the bank line accounting
date
diffstat:
src-db/database/model/functions/C_DEBT_PAYMENT_CREATE.xml | 11 +++++++----
1 files changed, 7 insertions(+), 4 deletions(-)
diffs (44 lines):
diff -r f3745deedbc0 -r 6aa65b673861
src-db/database/model/functions/C_DEBT_PAYMENT_CREATE.xml
--- a/src-db/database/model/functions/C_DEBT_PAYMENT_CREATE.xml Tue Oct 19
16:40:45 2010 +0200
+++ b/src-db/database/model/functions/C_DEBT_PAYMENT_CREATE.xml Tue Oct 19
17:18:06 2010 +0200
@@ -16,7 +16,7 @@
* under the License.
* The Original Code is Openbravo ERP.
* The Initial Developer of the Original Code is Openbravo SLU
-* All portions are Copyright (C) 2001-2006 Openbravo SLU
+* All portions are Copyright (C) 2001-2010 Openbravo SLU
* All Rights Reserved.
* Contributor(s): ______________________________________.
************************************************************************/
@@ -51,6 +51,7 @@
v_c_withholding_id C_DEBT_PAYMENT.C_Withholding_ID%TYPE;
v_withholdingamount C_DEBT_PAYMENT.withholdingamount%TYPE;
v_count NUMBER;
+ v_dateacct C_BankStatementLine.DateAcct%TYPE;
BEGIN
-- Update AD_PInstance
DBMS_OUTPUT.PUT_LINE('Updating PInstance - Processing ' || p_PInstance_ID)
;
@@ -113,10 +114,12 @@
v_ResultStr:='ReadingBankStatementLine '||v_record_Id;
SELECT L.AD_Client_ID,
L.AD_Org_ID,
- B.C_BankAccount_ID
+ B.C_BankAccount_ID,
+ L.DateAcct
INTO v_Client_ID,
v_AD_Org_ID,
- v_CBankAccount_ID
+ v_CBankAccount_ID,
+ v_dateacct
FROM C_BankStatementLine L,
C_BankStatement B
WHERE L.C_BankStatementLine_ID=v_Record_ID
@@ -155,7 +158,7 @@
(
v_SettlementID, v_Client_ID, v_AD_Org_ID, 'Y',
now(), v_AD_User_ID, now(), v_AD_User_ID,
- '*DPC*'||v_SDocumentNo, trunc(now()), trunc(now()), 'C',
+ '*DPC*'||v_SDocumentNo, v_dateacct, v_dateacct, 'C',
v_SettlementDocType_ID, 'N', 'N', 'N',
v_C_Currency_ID, v_Description, 'Y'
)
------------------------------------------------------------------------------
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
