Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020213Openbravo ERP03. Procurement managementpublic2012-04-05 06:342012-05-12 03:49
Reporterthirumalaik 
Assigned Tothirumalaik 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionduplicate 
PlatformOS30OS VersionProfessional Appliance
Product Version 
Target VersionFixed in Version3.0MP10.1 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browserApple Safari, Google Chrome, Internet Explorer, Mozilla Firefox
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020213: Invoicerule issue in Purchase order
DescriptionPurchase Order:

Create a purchase order and try to save record.You may face this error "Error
Saving failed. ERROR: null value in column "invoicerule" violates not-null constraint".
There is no choice for selecting Invoicerule because the field is hidden.

Sales Order:

Create a sales order and try to save record.You may face an issue like,no invoice rule is listed(mandatory field).
Steps To Reproduce1.Create a new client and make sure no sales representative is exist.
2.Now try to create record in Purchase order and try to save record.You may face this error "Error
Saving failed. ERROR: null value in column "invoicerule" violates not-null constraint".


Proposed SolutionIn SE_Order_BPartner.java callout,Sales representative is validated for displaying invoice rules.I'm not sure about the functional purpose of this validation.If so,please display corresponding message to overcome this error.

   162 // Sales Representative

   163

   164 FieldProvider[] tld = null;




   205 if (tld != null && tld.length > 0) {
   206 info.addSelect("inpinvoicerule");

Additional Information
TagsVMA-Reviewed
Relationships
depends on defect 00202513.0MP11 closed guilleaer Under special conditions the business partner callout in orders windows, fails 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-04-05 06:34thirumalaikNew Issue
2012-04-05 06:34thirumalaikAssigned To => vmromanos
2012-04-05 06:34thirumalaikWeb browser => Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox
2012-04-05 06:34thirumalaikModules => Core
2012-04-05 06:34thirumalaikOBNetwork customer => Yes
2012-04-05 06:34thirumalaikIssue Monitored: thirumalaik
2012-04-05 22:43kcelebiIssue Monitored: kcelebi
2012-04-10 13:19vmromanosTag Attached: VMA-Reviewed
2012-04-10 13:25jonalegriaesarteAssigned Tovmromanos => jonalegriaesarte
2012-04-30 09:52jonalegriaesarteNote Added: 0048183
2012-04-30 09:52jonalegriaesarteAssigned Tojonalegriaesarte => thirumalaik
2012-04-30 09:52jonalegriaesarteStatusnew => acknowledged
2012-04-30 09:54jonalegriaesarteRelationship addeddepends on 0020251
2012-04-30 17:26jonalegriaesarteStatusacknowledged => scheduled
2012-04-30 17:26jonalegriaesartefix_in_branch => pi
2012-04-30 17:27jonalegriaesarteStatusscheduled => feedback
2012-05-08 10:50jonalegriaesarteNote Added: 0048437
2012-05-08 10:50jonalegriaesarteStatusfeedback => closed
2012-05-08 10:50jonalegriaesarteResolutionopen => duplicate
2012-05-08 10:50jonalegriaesarteFixed in Version => 3.0MP10.1
2012-05-12 03:49rmallaNote Added: 0048590

Notes
(0048183)
jonalegriaesarte   
2012-04-30 09:52   
Seems to be solved in this changeset https://code.openbravo.com/erp/devel/pi/rev/83facabed792547fd4f549cf40ab5c79f9c9ef14 [^]
published in MP10.1
Could you please confirm?
(0048437)
jonalegriaesarte   
2012-05-08 10:50   
Solved in changeset https://code.openbravo.com/erp/devel/pi/rev/83facabed792547fd4f549cf40ab5c79f9c9ef14 [^]
(0048590)
rmalla   
2012-05-12 03:49   
Hello, I have changed the if (tld != null && tld.length > 0) on the SE_Order_BPartner.java as specified below, but still getting the folowing error:

Error
Saving failed. ERROR: null value in column "invoicerule" violates not-null constraint

Please advise because I think there may be another bug.