Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0013474 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | always | 2010-05-30 21:23 | 2010-06-10 13:02 | |||
| Reporter | FTS | View Status | public | |||||
| Assigned To | vmromanos | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 0a2a03157bd5 | |||
| Projection | none | ETA | none | Target Version | 2.50MP19 | |||
| OS | FreeBSD | Database | PostgreSQL | Java version | 1.6.0_07 | |||
| OS Version | 8.0 | Database version | 8.4.4 | Ant version | 1.7.1 | |||
| Product Version | 2.50MP18 | SCM revision | 7429:62153b977ebe | |||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0013474: Create payment fails while creating on bank statements | |||||||
| Description | When you try to create a payment from the bank statement application gives error: Error: The selected Withholding is not associated to the payment's Business Partner. Where is no withholding configured for Business Partner. | |||||||
| Steps To Reproduce | 1- Go to Financial Management || Receivables & Payables || Transactions || Bank Statement 2- Create a new bank statement and save it 3- Go to Lines tab, create a new record and save it. Example: Line No: 10 Effective Date: 31.01.2009 Accounting Date:31.01.2009 Statement Amount: 5.0 4- Press Create Payment button, fill data and press "OK" button. Example: Business Partner : Any Amount: 5.0 Form of Payment: Bank deposit Due Date: 31.01.2009 Status: any | |||||||
| Tags | Regression | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0027942) jonalegriaesarte (reporter) 2010-06-04 09:51 |
We think that the problem is in the validation (PostgreSQL): SELECT COUNT(*) INTO v_count FROM C_BP_Withholding WHERE C_Withholding_ID=v_c_withholding_id AND C_BPartner_ID=v_C_BPartner_ID; IF (v_count=0) THEN RAISE EXCEPTION '%', '@NOT_BP_WITHHOLDING@'; --OBTG:-20000-- END IF; Maybe it should check that the user has selected a withholding, so the code should be: IF (v_c_withholding_id IS NOT NULL) THEN SELECT COUNT(*) INTO v_count FROM C_BP_Withholding WHERE C_Withholding_ID=v_c_withholding_id AND C_BPartner_ID=v_C_BPartner_ID; IF (v_count=0) THEN RAISE EXCEPTION '%', '@NOT_BP_WITHHOLDING@'; --OBTG:-20000-- END IF; END IF; What do you think? Thanks. |
|
(0027943) vmromanos (manager) 2010-06-04 11:26 |
Hi John, Yes, totally agree with you. I will fix it right now. |
|
(0027947) FTS (reporter) 2010-06-04 12:34 |
Just an information that issue 13475 is related to withholding as well. In theory it could affect possibility to select needed withholding in bank statement payments. |
|
(0027996) hgbot (developer) 2010-06-04 15:38 |
Repository: erp/devel/pi Changeset: 0a2a03157bd5f77362bc802a7651db92ade0682a Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> Date: Fri Jun 04 15:38:46 2010 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/0a2a03157bd5f77362bc802a7651db92ade0682a [^] Fixed bug 13474: Create payment fails while creating on bank statements It only checks if a withholding has been selected by the user --- M src-db/database/model/functions/C_DEBT_PAYMENT_CREATE.xml --- |
|
(0028024) sureshbabu (reporter) 2010-06-07 08:58 |
Hi, I have tried to verify this issue in Live qa builds, after i enter details in create payment window, system throws an empty error message. |
|
(0028040) vmromanos (manager) 2010-06-07 10:18 |
Hi Suresh, I can reproduce this "empty red message" in live builds, however it seems to be an issue that affects all the database processes. Try for example to complete an invoice and you will get the same error. Here is the log: 10:15:19 [ajp-8009-4] ERROR org.openbravo.scheduling.ProcessRunner - java.lang.InstantiationException at sun.reflect.InstantiationExceptionConstructorAccessorImpl.newInstance(InstantiationExceptionConstructorAccessorImpl.java:30) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at java.lang.Class.newInstance0(Class.java:355) at java.lang.Class.newInstance(Class.java:308) at org.openbravo.scheduling.ProcessRunner.execute(ProcessRunner.java:58) at org.openbravo.erpWindows.PurchaseInvoice.Header.doPost(Header.java:452) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225) at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:415) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:101) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:427) at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:384) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555) at java.lang.Thread.run(Thread.java:619) |
|
(0028044) vmromanos (manager) 2010-06-07 11:27 |
Hi Suresh, I can confirm you the bug 0013518 is the responsible of this behaviour. I have just asked Ivan to reopen it and fix it properly. Once it's properly fixed, it should work fine. I set it again as fixed. |
|
(0028115) hudsonbot (developer) 2010-06-07 21:21 |
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated: Changeset: http://code.openbravo.com/erp/devel/main/rev/0a2a03157bd5 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/8b43a1f2fff4 [^] Tests: http://builds.openbravo.com/view/int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17563.obx [^] |
|
(0028157) hudsonbot (developer) 2010-06-07 23:44 |
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated: Changeset: http://code.openbravo.com/erp/devel/main/rev/0a2a03157bd5 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/8b43a1f2fff4 [^] Tests: http://builds.openbravo.com/view/int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17563.obx [^] |
|
(0028184) sureshbabu (reporter) 2010-06-08 14:04 |
verified (live qa postgres context) working fine, Now user able to create Payments using bank statement |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-05-30 21:23 | FTS | New Issue | |
| 2010-05-30 21:23 | FTS | Assigned To | => dalsasua |
| 2010-06-03 18:03 | iatienza | Issue Monitored: iatienza | |
| 2010-06-03 18:44 | jonalegriaesarte | Priority | normal => immediate |
| 2010-06-03 18:51 | psarobe | version | main => 2.50MP18 |
| 2010-06-03 18:58 | jonalegriaesarte | Target Version | => 2.50MP19 |
| 2010-06-04 09:51 | jonalegriaesarte | Note Added: 0027942 | |
| 2010-06-04 11:25 | vmromanos | Assigned To | dalsasua => vmromanos |
| 2010-06-04 11:25 | vmromanos | Status | new => scheduled |
| 2010-06-04 11:25 | vmromanos | fix_in_branch | => pi |
| 2010-06-04 11:26 | vmromanos | Note Added: 0027943 | |
| 2010-06-04 11:57 | vmromanos | Issue cloned | 0013523 |
| 2010-06-04 11:57 | vmromanos | Relationship added | related to 0013523 |
| 2010-06-04 12:34 | FTS | Note Added: 0027947 | |
| 2010-06-04 15:38 | hgbot | Checkin | |
| 2010-06-04 15:38 | hgbot | Note Added: 0027996 | |
| 2010-06-04 15:38 | hgbot | Status | scheduled => resolved |
| 2010-06-04 15:38 | hgbot | Resolution | open => fixed |
| 2010-06-04 15:38 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/0a2a03157bd5f77362bc802a7651db92ade0682a [^] |
| 2010-06-07 08:58 | sureshbabu | Note Added: 0028024 | |
| 2010-06-07 08:58 | sureshbabu | Status | resolved => new |
| 2010-06-07 08:58 | sureshbabu | Resolution | fixed => open |
| 2010-06-07 10:18 | vmromanos | Note Added: 0028040 | |
| 2010-06-07 11:27 | vmromanos | Status | new => scheduled |
| 2010-06-07 11:27 | vmromanos | Note Added: 0028044 | |
| 2010-06-07 11:27 | vmromanos | Status | scheduled => resolved |
| 2010-06-07 11:27 | vmromanos | Resolution | open => fixed |
| 2010-06-07 21:21 | hudsonbot | Checkin | |
| 2010-06-07 21:21 | hudsonbot | Note Added: 0028115 | |
| 2010-06-07 23:44 | hudsonbot | Checkin | |
| 2010-06-07 23:44 | hudsonbot | Note Added: 0028157 | |
| 2010-06-08 14:04 | sureshbabu | Note Added: 0028184 | |
| 2010-06-08 14:04 | sureshbabu | Status | resolved => closed |
| 2010-06-09 00:00 | anonymous | sf_bug_id | 0 => 3013458 |
| 2010-06-10 13:02 | psarobe | Tag Attached: Regression | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |