Project:
View Revisions: Issue #15363 | [ All Revisions ] [ Back to Issue ] | ||
Summary | 0015363: Error in message obtained when processing Bank Statement | ||
Revision | 2010-12-23 18:24 by dalsasua | ||
Steps To Reproduce | 1. Sales Management || Transactions || Sales Invoice || Header : create invoice with date 02/12/2010, document type "AR Invoice" and any line and COMPLETE it 2. Financial Management || Receivables & Payables || Transactions || Remittance || Header : create remittance for date 02/12/2010 and pressing "create lines from" choose payment associated to previous invoice. Process remittance 3. Financial Management || Receivables & Payables || Transactions || Bank Statement || Header : create bank statement with date 01/12/2010 and "pressing create lines from" choose negative payment associated to the remmitance 4. Try to process Bank Statement and you will obtain: error "In line the debt payment has a change status later than the selected Account Date" without indicating line number Error is located in C_DP_MANAGEMENT_POST in query IF(NOT FINISH_PROCESS) THEN SELECT count(*), MAX(ml.line) INTO v_Aux, v_line FROM C_DP_ManagementLine ml, C_DP_Management m WHERE ml.C_DP_Management_ID=m.C_DP_Management_ID AND m.C_DP_Management_ID=v_Record_ID AND exists (SELECT 1 FROM C_DP_ManagementLine ml1, C_DP_Management m1 WHERE m1.C_DP_Management_ID=ml1.C_DP_Management_ID AND ml1.C_Debt_Payment_ID=ml.C_Debt_Payment_ID AND m1.processed='Y' AND m1.DateAcct>m.DateAcct ) ; if v_Aux!=0 then RAISE_APPLICATION_ERROR(-20000, '@Inline@'||v_line||' '||'@LaterChangeStatus@') ; end if; END IF;--FINISH_PROCESS |
||
Revision | 2010-12-02 19:45 by dalsasua | ||
Steps To Reproduce | 1. Sales Management || Transactions || Sales Invoice || Header : create invoice with date 02/12/2010 and any line and COMPLETE it 2. Financial Management || Receivables & Payables || Transactions || Remittance || Header : create remittance for date 02/12/2010 and pressing "create lines from" choose payment associated to previous invoice. Process remittance 3. Financial Management || Receivables & Payables || Transactions || Bank Statement || Header : create bank statement with date 01/12/2010 and "pressing create lines from" choose negative payment associated to the remmitance 4. Try to process Bank Statement and you will obtain: error "In line the debt payment has a change status later than the selected Account Date" without indicating line number Error is located in C_DP_MANAGEMENT_POST in query IF(NOT FINISH_PROCESS) THEN SELECT count(*), MAX(ml.line) INTO v_Aux, v_line FROM C_DP_ManagementLine ml, C_DP_Management m WHERE ml.C_DP_Management_ID=m.C_DP_Management_ID AND m.C_DP_Management_ID=v_Record_ID AND exists (SELECT 1 FROM C_DP_ManagementLine ml1, C_DP_Management m1 WHERE m1.C_DP_Management_ID=ml1.C_DP_Management_ID AND ml1.C_Debt_Payment_ID=ml.C_Debt_Payment_ID AND m1.processed='Y' AND m1.DateAcct>m.DateAcct ) ; if v_Aux!=0 then RAISE_APPLICATION_ERROR(-20000, '@Inline@'||v_line||' '||'@LaterChangeStatus@') ; end if; END IF;--FINISH_PROCESS |
Copyright © 2000 - 2009 MantisBT Group |