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

Description

Requisition 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 Reproduce

1) 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

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

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	0005026	2.40	closed	Hennadzi	Requition to order does not check whether the Business partner has configured a paymentterm or not

Notes
(0010626) svnbot (reporter) 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 (developer) 2009-02-23 18:05	Re-opened issue since it was not properly fixed.

(0014230) hgbot (developer) 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 (reporter) 2009-03-05 10:28	Retested working fine. Tested in context http://79.125.57.19/openbravo240mp3psg [^]

Issue History
Date Modified	Username	Field	Change
2008-09-16 16:36	cromero	New Issue
2008-09-16 16:36	cromero	Assigned To	=> gorkaion
2008-09-16 16:36	cromero	Status	new => scheduled
2008-11-13 23:09	rafaroda	Assigned To	gorkaion => Hennadzi
2008-11-25 12:25	svnbot	Checkin
2008-11-25 12:25	svnbot	Note Added: 0010626
2008-11-25 12:25	svnbot	Status	scheduled => resolved
2008-11-25 12:25	svnbot	Resolution	open => fixed
2008-11-25 12:25	svnbot	svn_revision	=> 10529
2008-11-26 17:22	svnbot	Checkin
2008-11-26 17:22	svnbot	Note Added: 0010728
2008-11-26 17:22	svnbot	svn_revision	10529 => 10627
2009-02-02 16:21	rafaroda	Note Deleted: 0010728
2009-02-23 18:05	rafaroda	Note Added: 0013969
2009-02-23 18:05	rafaroda	Status	resolved => new
2009-02-23 18:05	rafaroda	Resolution	fixed => open
2009-02-23 18:05	rafaroda	svn_revision	10627 =>
2009-02-23 18:05	rafaroda	Description Updated
2009-02-23 18:05	rafaroda	Proposed Solution updated
2009-02-23 18:06	rafaroda	Status	new => scheduled
2009-03-02 16:04	hgbot	Checkin
2009-03-02 16:04	hgbot	Note Added: 0014230
2009-03-02 16:04	hgbot	Status	scheduled => resolved
2009-03-02 16:04	hgbot	Resolution	open => fixed
2009-03-02 16:04	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/stable/2.40/rev/f918df1628276c6e221453850d84d0c20058e6b7 [^]
2009-03-03 17:31	psarobe	Fixed in Version	=> 2.40MP3
2009-03-05 10:28	sureshbabu	Regression testing	=> No
2009-03-05 10:28	sureshbabu	Status	resolved => closed
2009-03-05 10:28	sureshbabu	Note Added: 0014425
2009-04-03 09:57	rafaroda	Relationship added	related to 0008412