Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0005073
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 03. Procurement managementminoralways2008-09-16 16:362009-03-05 10:28
ReporterpsarobeView Statuspublic 
Assigned ToHennadzi 
PrioritynormalResolutionfixedFixed in Version2.40MP3
StatusclosedFix in branch2.40Fixed in SCM revisionf918df162827
ProjectionnoneETAnoneTarget Version2.40
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005073: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to backport 0008412 closedgmauleon Requisition not getting displayed in Requisition to Order screen when the user creates a requisition without BP. 
blocks defect 00050262.40 closedHennadzi 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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker