Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015606Openbravo ERP08. Project and service managementpublic2011-01-11 12:482011-05-24 10:57
Reporteradrianromero 
Assigned Toadrianromero 
PriorityhighSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP23 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015606: Error in 'Create Sales Orders from Expenses'
DescriptionWhen you try to create an order from expenses this error appears:

"ERROR: null value in column "paymentrule" violates not-null constraint".

It is necessary create a new BP, because the olds BP have a payment rule value.

Steps To Reproduce- As Openbravo Admin go to Master Data Management || Business Partner
- Create a new Business Partner and go to Customer
    - Price List: Generale Sales
    - Select a payment method.
    - Select a Payment Term.
- Create a Location
- Go to Project & Service Management || Transactions || Multiphase Project
- Create a new record:
    - BP: the BP created
- Go to Project & Service Management || Transactions || Expense Sheet
- Create a new record:
    Report Date: 15-02-2010
- Go to lines:
    - Check reinvoicing
    - Product: electricity
    - Project: select the project created
    - Business Partner: It will appear the BP associated to the project (the BO created)
- Go back to the header and process
- Go to Project & Service Management || Transactions || Create Sales Orders from Expenses || Create Sales Orders from Expenses
- Date Ordered: 15-02-2010
- Process

- Realize that the error appears
Proposed Solution
Additional Information
TagsclosingMay2011
Relationships
depends on defect 00154473.0RC4 closed adrianromero Error in 'Create Sales Orders from Expenses' 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-01-11 12:48adrianromeroNew Issue
2011-01-11 12:48adrianromeroAssigned To => adrianromero
2011-01-11 12:48adrianromeroModules => Core
2011-01-11 12:48adrianromeroOBNetwork customer => Yes
2011-01-11 12:48adrianromeroIssue generated from0015447
2011-01-11 12:48adrianromeroRelationship addeddepends on 0015447
2011-01-11 12:49adrianromeroStatusnew => scheduled
2011-01-11 12:49adrianromerofix_in_branch => pi
2011-01-11 18:23hgbotCheckin
2011-01-11 18:23hgbotNote Added: 0033589
2011-01-11 18:23hgbotStatusscheduled => resolved
2011-01-11 18:23hgbotResolutionopen => fixed
2011-01-11 18:23hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/528c120ad84eff0ef5e9657ff033c6e8c49acaf6 [^]
2011-01-11 18:27adrianromeroNote Added: 0033590
2011-05-24 10:03dalsasuaTag Attached: closingMay2011
2011-05-24 10:57dalsasuaStatusresolved => closed

Notes
(0033589)
hgbot   
2011-01-11 18:23   
Repository: erp/stable/2.50
Changeset: 528c120ad84eff0ef5e9657ff033c6e8c49acaf6
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Tue Jan 11 18:18:08 2011 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/528c120ad84eff0ef5e9657ff033c6e8c49acaf6 [^]

Fixes issue 0015606: Error in Create Sales Orders from Expenses
It has been added a payment rule default value when using the new payment flow.

---
M src/org/openbravo/erpCommon/ad_actionButton/ExpenseSOrder.java
---
(0033590)
adrianromero   
2011-01-11 18:27   
* Testing the issue

Just follow the steps to reproduce and notice that now the order can be created. There has been only modified the case when the payment rule is null and there is active the new payables flow. In this case a default payment rule is assigned in the order generated.

* Other areas affected

Only the process of creating Orders from expenses has been modified. No other areas affected.