Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014864Openbravo ERPZ. Otherspublic2010-10-13 13:122011-05-17 15:53
Reporternetworkb 
Assigned Tomirurita 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesAdvanced Payables and Receivables Mngmt
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0014864: Error when trying to "Create Purchase Orders" from MRP Purchasing Plan window
DescriptionAPR module replaces "Form of Payment" field by "Payment Method". But when you press "Create Purchase Orders" in Material Requirement (MRP) || Transactions || Purchasing Plan window, the process tries to obtain "Payment Method" field of BP to insert it in the order so following message is obtained:

null value in column "paymentrule" violates not-null constraint
Steps To Reproduce1. Master Data Management || Business Partner || Business Partner : create new record.
2. Master Data Management || Business Partner || Business Partner >> Vendor/Creditor : check it as Vendor and set Purchase Pricelist
3. Material Requirement (MRP) || Transactions || Purchasing Plan || Header : create new record with:
   DocumentDate= today
   Time Horizon=60
4. Material Requirement (MRP) || Transactions || Purchasing Plan || Header >> Lines: add line with:
   Product=Hat
   Planned date=today
   TransactionType= Suggested Purchase Order
   BP= new BP created
5. Come back to header and press "Create Purchase Order" button. You will obtain the error

Problem is that mrp_purchaseorder function selects PAYMENTRULEPO field when filling Cur_workproposal and it is null
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-10-13 13:12networkbNew Issue
2010-10-13 13:12networkbAssigned To => mirurita
2010-10-13 13:12networkbOBNetwork customer => Yes
2010-10-13 16:27miruritaStatusnew => scheduled
2010-10-13 16:27miruritafix_in_branch => pi
2010-10-13 17:01hgbotCheckin
2010-10-13 17:01hgbotNote Added: 0031818
2010-10-13 17:01hgbotStatusscheduled => resolved
2010-10-13 17:01hgbotResolutionopen => fixed
2010-10-13 17:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d5490dea50d5b715e82f9d4defbc65a6717a742a [^]
2010-10-14 18:29hgbotCheckin
2010-10-14 18:29hgbotNote Added: 0031857
2010-10-14 22:29hudsonbotCheckin
2010-10-14 22:29hudsonbotNote Added: 0031863
2010-10-18 17:39hudsonbotCheckin
2010-10-18 17:39hudsonbotNote Added: 0031927
2011-05-17 15:53gorkaionStatusresolved => closed

Notes
(0031818)
hgbot   
2010-10-13 17:01   
Repository: erp/devel/pi
Changeset: d5490dea50d5b715e82f9d4defbc65a6717a742a
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Wed Oct 13 17:00:04 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d5490dea50d5b715e82f9d4defbc65a6717a742a [^]

Fixes issue 14864: Error Create Purchase Orders from MRP Purchasing Plan

---
M src-db/database/model/functions/MRP_PURCHASEORDER.xml
---
(0031857)
hgbot   
2010-10-14 18:29   
Repository: erp/devel/pi
Changeset: 661f42233527ac6eb9f40bb0e989c6902ef79374
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Thu Oct 14 18:28:57 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/661f42233527ac6eb9f40bb0e989c6902ef79374 [^]

Related to issue 14864: verify if alternative financial flow is implemented

---
M src-db/database/model/functions/MRP_PURCHASEORDER.xml
---
(0031863)
hudsonbot   
2010-10-14 22:29   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/d5490dea50d5 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/d7ad2f964c30 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18536.obx [^]
(0031927)
hudsonbot   
2010-10-18 17:39   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/661f42233527 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/e1c7df1ae349 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18559.obx [^]