Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009866Openbravo ERP06. Material requirement planning (MRP)public2009-07-13 18:202012-05-25 12:12
Reporterjtarbal 
Assigned ToSandrahuguet 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP2 
Target VersionFixed in Version3.0MP12 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009866: Error when creating purchase orders from an MRP purchasing plan
DescriptionWhen creating the purchase orders from the "Purchasing Plan" window in MRP, if no warehouse is selected, the following error appears: "Error: null value in column "m_warehouse_id" violates not-null constraint".
Steps To ReproduceIn order to reproduce this error, please, follow the next steps:
1) Parametrize the Purchasing MRP planner
2) Go to "Material Requirement (MRP) || Transactions || Purchasing Plan" and create a new document
3) Specify a "Time horizon" that implies a new purchase as there will be not enough stocked products.
4) Press the "Process purchase plan" button.
5) Go in the "Lines" tab and make sure there is at least one record of type "suggested purchase order"
6) Go in the "Header" tab and press the button "Create purchase orders". Do not select any warehouse.
7) See the error "Error: null value in column "m_warehouse_id" violates not-null constraint".
Proposed SolutionIn my opinion, it should not be necessary to select the warehouse when creating the purchase orders from an MRP purchasing plan. Thus, no parameters should be selected when doing this action.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-13 18:20jtarbalNew Issue
2009-07-13 18:20jtarbalAssigned To => rafaroda
2009-07-20 23:22psarobeAssigned Torafaroda => gorkaion
2009-07-20 23:22psarobeStatusnew => scheduled
2012-05-09 12:24SandrahuguetAssigned Togorkaion => Sandrahuguet
2012-05-09 13:45SandrahuguetNote Added: 0048506
2012-05-09 13:45SandrahuguetNote Added: 0048507
2012-05-18 14:45hgbotCheckin
2012-05-18 14:45hgbotNote Added: 0048770
2012-05-18 14:45hgbotStatusscheduled => resolved
2012-05-18 14:45hgbotResolutionopen => fixed
2012-05-18 14:45hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/df2d72114d5fc1a156d7e97116b9dab4d4d29f25 [^]
2012-05-18 14:46hgbotCheckin
2012-05-18 14:46hgbotNote Added: 0048772
2012-05-18 14:52miruritaNote Added: 0048774
2012-05-18 14:52miruritaStatusresolved => closed
2012-05-18 14:52miruritaFixed in Version => 3.0MP12
2012-05-25 12:12hudsonbotCheckin
2012-05-25 12:12hudsonbotNote Added: 0049165
2012-05-25 12:12hudsonbotCheckin
2012-05-25 12:12hudsonbotNote Added: 0049167

Notes
(0048506)
Sandrahuguet   
2012-05-09 13:45   
Warehouse is mandatory in purchase order, as a result warehouse parameter in create purchase orders process in purchasing plan window should be mandatory.
To fix this issue we modify warehouse parameter as mandatory and the default value in warehouse is the warehouse in session.
(0048507)
Sandrahuguet   
2012-05-09 13:45   
Test Plan:
Go to Purchasing Plan, and create one:
 -Organization: F&B España - Región Norte
 -Name: test
Navigate to lines, and create one:
 -Planned date: 09-05-2012
 -Quantity: 100
 -Required quantity: 100
 -Transaction Type: Suggested Purchase Order
 -Product: Agua sin Gas 1L
 -Business partner: Refrescos Naturales, S.A.
 -Planned order date: 09-05-2012
Press the button "Create purchase orders"
Notice that warehouse parameter is mandatory
(0048770)
hgbot   
2012-05-18 14:45   
Repository: erp/devel/pi
Changeset: df2d72114d5fc1a156d7e97116b9dab4d4d29f25
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Wed May 09 13:16:59 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/df2d72114d5fc1a156d7e97116b9dab4d4d29f25 [^]

Fixed bug 9866 Warehouse mandatory in Create Purchase Orders in Purchasing Plan

---
M src-db/database/sourcedata/AD_PROCESS_PARA.xml
---
(0048772)
hgbot   
2012-05-18 14:46   
Repository: erp/devel/pi
Changeset: 20df7cdc3147d4ca200b4fdeb32073fab9380c4c
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Fri May 18 14:45:01 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/20df7cdc3147d4ca200b4fdeb32073fab9380c4c [^]

Related to issue 9866: use # for parameter default value

---
M src-db/database/sourcedata/AD_PROCESS_PARA.xml
---
(0048774)
mirurita   
2012-05-18 14:52   
code review + testing OK
(0049165)
hudsonbot   
2012-05-25 12:12   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/5401e185a8b0 [^]

Maturity status: Test
(0049167)
hudsonbot   
2012-05-25 12:12   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/5401e185a8b0 [^]

Maturity status: Test