Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005026Openbravo ERP03. Procurement managementpublic2008-09-11 20:302009-04-21 10:54
Reporterpsarobe 
Assigned ToHennadzi 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target Version2.40Fixed in Version2.50 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005026: Requition to order does not check whether the Business partner has configured a paymentterm or not
DescriptionRequisition to order does not check whether the Business partner has configured a paymentterm or not. It checks other things and it should this one
Steps To Reproduce1) Create a new requisition for a certain business partner: Procurement Management || Transactions || Requisition
2) Add some lines.
3) Go back to header and complete it
4) Go to Master Data Management || Business Partner and select the business partner of the requisition
5) Go to Vendor/Creditor tab, leave Payment Terms blank and save.
6) Go to Procurement Management || Transactions || Requisition To Order
7) Select the previous business partner and add the lines
8) Then click on Create button.

'Process failed during Execution' error message displays.

In the logs: ERROR: null value in column "paymentrule" violates not-null constraint

SQL error in query: INSERT INTO C_ORDER (C_ORDER_ID, AD_CLIENT_ID, AD_ORG_ID, CREATED, CREATEDBY, UPDATED, UPDATEDBY, DOCUMENTNO, DOCSTATUS, DOCACTION, C_DOCTYPE_ID, C_DOCTYPETARGET_ID, DATEORDERED, DATEPROMISED, DATEACCT, C_BPARTNER_ID, C_BPARTNER_LOCATION_ID, BILLTO_ID, C_CURRENCY_ID, PAYMENTRULE, C_PAYMENTTERM_ID, INVOICERULE, DELIVERYRULE, FREIGHTCOSTRULE, DELIVERYVIARULE, M_WAREHOUSE_ID, M_PRICELIST_ID, C_PROJECT_ID, C_ACTIVITY_ID, C_CAMPAIGN_ID, PRIORITYRULE, ISSOTRX) VALUES (TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),now(),TO_NUMBER(?),now(),TO_NUMBER(?),?,?,?,TO_NUMBER(?),TO_NUMBER(?),TO_DATE(?),TO_DATE(?),TO_DATE(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),?,TO_NUMBER(?),?,?,?,?,TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),'5', 'N')Exception:org.postgresql.util.PSQLException: ERROR: null value in column "paymentrule" violates not-null constraint
javax.servlet.ServletException: @CODE=0@ERROR: null value in column "paymentrule" violates not-null constraint
    at org.openbravo.erpCommon.ad_forms.RequisitionToOrderData.insertCOrder(RequisitionToOrderData.java:2337)
    at org.openbravo.erpCommon.ad_forms.RequisitionToOrder.processPurchaseOrder(RequisitionToOrder.java:361)
    at org.openbravo.erpCommon.ad_forms.RequisitionToOrder.doPost(RequisitionToOrder.java:110)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
    at org.openbravo.base.HttpBaseServlet.serviceInitialized(Unknown Source)
    at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:257)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.openbravo.utils.SessionExpirationFilter.doFilter(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.openbravo.utils.CharsetFilter.doFilter(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
    at java.lang.Thread.run(Thread.java:595)
- Rollback in transaction
Proposed Solution
Additional Information
Tagscomsup_sprint7
Relationships
depends on backport 00050732.40 closed Hennadzi Requition to order does not check whether the Business partner has configured a paymentterm or not 
related to defect 0008375 closed gmauleon Requisition not getting displayed in Requisition to Order screen when the user creates a requisition without BP. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-11 20:30psarobeNew Issue
2008-09-11 20:30psarobeAssigned To => gorkaion
2008-09-11 20:30psarobesf_bug_id0 => 2106171
2008-09-11 20:30psarobeRegression testing => No
2008-09-16 16:36cromeroStatusnew => scheduled
2008-09-16 16:36cromerofix_in_branch => trunk
2008-11-13 23:09rafarodaAssigned Togorkaion => Hennadzi
2008-11-25 15:32svnbotCheckin
2008-11-25 15:32svnbotNote Added: 0010648
2008-11-25 15:32svnbotStatusscheduled => resolved
2008-11-25 15:32svnbotResolutionopen => fixed
2008-11-25 15:32svnbotsvn_revision => 10553
2009-02-18 09:26sureshbabuStatusresolved => closed
2009-02-18 09:26sureshbabuNote Added: 0013622
2009-02-18 09:26sureshbabuFixed in Version => trunk
2009-02-23 18:03rafarodaNote Added: 0013966
2009-02-23 18:03rafarodaStatusclosed => new
2009-02-23 18:03rafarodafix_in_branchtrunk =>
2009-02-23 18:03rafarodaDescription Updated
2009-02-23 18:03rafarodaProposed Solution updated
2009-02-23 18:04rafarodaStatusnew => scheduled
2009-02-23 18:04rafarodaResolutionfixed => open
2009-02-23 18:04rafarodasvn_revision10553 =>
2009-02-27 14:21HennadziTag Attached: commsup_sprint7
2009-02-27 14:21HennadziTag Detached: commsup_sprint7
2009-02-27 14:22HennadziTag Attached: comsup_sprint7
2009-02-27 15:24hgbotCheckin
2009-02-27 15:24hgbotNote Added: 0014161
2009-02-27 15:24hgbotStatusscheduled => resolved
2009-02-27 15:24hgbotResolutionopen => fixed
2009-02-27 15:24hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/84d234ec2d884e8057d2ec01352dba112d8b5e8a [^]
2009-04-03 09:57rafarodaRelationship addedrelated to 0008375
2009-04-21 10:54psarobeStatusresolved => closed

Notes
(0010648)
svnbot   
2008-11-25 15:32   
Repository: openbravo
Revision: 10553
Author: hennadzi
Date: 2008-11-25 15:32:28 +0100 (Tue, 25 Nov 2008)

Fixed bug 0005026: Requition to order does not check whether the Business partner has configured a paymentterm or not

---
U trunk/src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=10553&sc=1 [^]
(0013622)
sureshbabu   
2009-02-18 09:26   
Working fine retested in context 79.125.56.185/openbravotrunk
(0013966)
rafaroda   
2009-02-23 18:03   
Re-opened issue since it was not properly fixed.
(0014161)
hgbot   
2009-02-27 15:24   
Repository: erp/devel/pi
Changeset: 84d234ec2d884e8057d2ec01352dba112d8b5e8a
Author: Hennadzi Mackevich <hennadzi.mackevich <at> opensuite.com>
Date: Fri Feb 27 16:22:09 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/84d234ec2d884e8057d2ec01352dba112d8b5e8a [^]

Fixed bug 0005026: Requition to order does not check whether the Business partner has configured a paymentterm or not

---
M src-db/database/sourcedata/AD_MESSAGE.xml
M src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder.java
M src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql
---