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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0005026
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementminoralways2008-09-11 20:302009-04-21 10:54
ReporterpsarobeView Statuspublic 
Assigned ToHennadzi 
PrioritynormalResolutionfixedFixed in Version2.50
StatusclosedFix in branchFixed in SCM revision84d234ec2d88
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

0005026: 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
Tagscomsup_sprint7
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 00050732.40 closedHennadzi Requition to order does not check whether the Business partner has configured a paymentterm or not 
related to defect 0008375 closedgmauleon Requisition not getting displayed in Requisition to Order screen when the user creates a requisition without BP. 

-  Notes
(0010648)
svnbot (reporter)
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 (reporter)
2009-02-18 09:26

 Working fine retested in context 79.125.56.185/openbravotrunk
(0013966)
rafaroda (developer)
2009-02-23 18:03

 Re-opened issue since it was not properly fixed.
(0014161)
hgbot (developer)
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
---

- Issue History
Date Modified Username Field Change
2008-09-11 20:30 psarobe New Issue
2008-09-11 20:30 psarobe Assigned To => gorkaion
2008-09-11 20:30 psarobe sf_bug_id 0 => 2106171
2008-09-11 20:30 psarobe Regression testing => No
2008-09-16 16:36 cromero Status new => scheduled
2008-09-16 16:36 cromero fix_in_branch => trunk
2008-11-13 23:09 rafaroda Assigned To gorkaion => Hennadzi
2008-11-25 15:32 svnbot Checkin
2008-11-25 15:32 svnbot Note Added: 0010648
2008-11-25 15:32 svnbot Status scheduled => resolved
2008-11-25 15:32 svnbot Resolution open => fixed
2008-11-25 15:32 svnbot svn_revision => 10553
2009-02-18 09:26 sureshbabu Status resolved => closed
2009-02-18 09:26 sureshbabu Note Added: 0013622
2009-02-18 09:26 sureshbabu Fixed in Version => trunk
2009-02-23 18:03 rafaroda Note Added: 0013966
2009-02-23 18:03 rafaroda Status closed => new
2009-02-23 18:03 rafaroda fix_in_branch trunk =>
2009-02-23 18:03 rafaroda Description Updated
2009-02-23 18:03 rafaroda Proposed Solution updated
2009-02-23 18:04 rafaroda Status new => scheduled
2009-02-23 18:04 rafaroda Resolution fixed => open
2009-02-23 18:04 rafaroda svn_revision 10553 =>
2009-02-27 14:21 Hennadzi Tag Attached: commsup_sprint7
2009-02-27 14:21 Hennadzi Tag Detached: commsup_sprint7
2009-02-27 14:22 Hennadzi Tag Attached: comsup_sprint7
2009-02-27 15:24 hgbot Checkin
2009-02-27 15:24 hgbot Note Added: 0014161
2009-02-27 15:24 hgbot Status scheduled => resolved
2009-02-27 15:24 hgbot Resolution open => fixed
2009-02-27 15:24 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/84d234ec2d884e8057d2ec01352dba112d8b5e8a [^]
2009-04-03 09:57 rafaroda Relationship added related to 0008375
2009-04-21 10:54 psarobe Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker