Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005073Openbravo ERP03. Procurement managementpublic2008-09-16 16:362009-03-05 10:28
Reporterpsarobe 
Assigned ToHennadzi 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target Version2.40Fixed in Version2.40MP3 
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
Summary0005073: 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
TagsNo tags attached.
Relationships
related to backport 0008412 closed gmauleon Requisition not getting displayed in Requisition to Order screen when the user creates a requisition without BP. 
blocks defect 00050262.40 closed Hennadzi Requition to order does not check whether the Business partner has configured a paymentterm or not 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-16 16:36cromeroNew Issue
2008-09-16 16:36cromeroAssigned To => gorkaion
2008-09-16 16:36cromeroStatusnew => scheduled
2008-11-13 23:09rafarodaAssigned Togorkaion => Hennadzi
2008-11-25 12:25svnbotCheckin
2008-11-25 12:25svnbotNote Added: 0010626
2008-11-25 12:25svnbotStatusscheduled => resolved
2008-11-25 12:25svnbotResolutionopen => fixed
2008-11-25 12:25svnbotsvn_revision => 10529
2008-11-26 17:22svnbotCheckin
2008-11-26 17:22svnbotNote Added: 0010728
2008-11-26 17:22svnbotsvn_revision10529 => 10627
2009-02-02 16:21rafarodaNote Deleted: 0010728
2009-02-23 18:05rafarodaNote Added: 0013969
2009-02-23 18:05rafarodaStatusresolved => new
2009-02-23 18:05rafarodaResolutionfixed => open
2009-02-23 18:05rafarodasvn_revision10627 =>
2009-02-23 18:05rafarodaDescription Updated
2009-02-23 18:05rafarodaProposed Solution updated
2009-02-23 18:06rafarodaStatusnew => scheduled
2009-03-02 16:04hgbotCheckin
2009-03-02 16:04hgbotNote Added: 0014230
2009-03-02 16:04hgbotStatusscheduled => resolved
2009-03-02 16:04hgbotResolutionopen => fixed
2009-03-02 16:04hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/f918df1628276c6e221453850d84d0c20058e6b7 [^]
2009-03-03 17:31psarobeFixed in Version => 2.40MP3
2009-03-05 10:28sureshbabuRegression testing => No
2009-03-05 10:28sureshbabuStatusresolved => closed
2009-03-05 10:28sureshbabuNote Added: 0014425
2009-04-03 09:57rafarodaRelationship addedrelated to 0008412

Notes
(0010626)
svnbot   
2008-11-25 12:25   
Repository: openbravo
Revision: 10529
Author: hennadzi
Date: 2008-11-25 12:24:57 +0100 (Tue, 25 Nov 2008)

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

---
U branches/r2.40/src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=10529&sc=1 [^]
(0013969)
rafaroda   
2009-02-23 18:05   
Re-opened issue since it was not properly fixed.
(0014230)
hgbot   
2009-03-02 16:04   
Repository: erp/stable/2.40
Changeset: f918df1628276c6e221453850d84d0c20058e6b7
Author: Hennadzi Mackevich <hennadzi.mackevich <at> opensuite.com>
Date: Mon Mar 02 17:02:33 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/f918df1628276c6e221453850d84d0c20058e6b7 [^]

Fixed bug 0005073: 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
---
(0014425)
sureshbabu   
2009-03-05 10:28   
Retested working fine.

Tested in context http://79.125.57.19/openbravo240mp3psg [^]