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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0009866
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 06. Material requirement planning (MRP)minoralways2009-07-13 18:202012-05-25 12:12
ReporterjtarbalView Statuspublic 
Assigned ToSandrahuguet 
PrioritynormalResolutionfixedFixed in Version3.0MP12
StatusclosedFix in branchFixed in SCM revisiondf2d72114d5f
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP2SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009866: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0048506)
Sandrahuguet (viewer)
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 (viewer)
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 (developer)
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 (developer)
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 (viewer)
2012-05-18 14:52

 code review + testing OK
(0049165)
hudsonbot (viewer)
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 (viewer)
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

- Issue History
Date Modified Username Field Change
2009-07-13 18:20 jtarbal New Issue
2009-07-13 18:20 jtarbal Assigned To => rafaroda
2009-07-20 23:22 psarobe OBNetwork customer => No
2009-07-20 23:22 psarobe Assigned To rafaroda => gorkaion
2009-07-20 23:22 psarobe Status new => scheduled
2012-05-09 12:24 Sandrahuguet Assigned To gorkaion => Sandrahuguet
2012-05-09 13:45 Sandrahuguet Note Added: 0048506
2012-05-09 13:45 Sandrahuguet Note Added: 0048507
2012-05-18 14:45 hgbot Checkin
2012-05-18 14:45 hgbot Note Added: 0048770
2012-05-18 14:45 hgbot Status scheduled => resolved
2012-05-18 14:45 hgbot Resolution open => fixed
2012-05-18 14:45 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/df2d72114d5fc1a156d7e97116b9dab4d4d29f25 [^]
2012-05-18 14:46 hgbot Checkin
2012-05-18 14:46 hgbot Note Added: 0048772
2012-05-18 14:52 mirurita Note Added: 0048774
2012-05-18 14:52 mirurita Status resolved => closed
2012-05-18 14:52 mirurita Fixed in Version => 3.0MP12
2012-05-25 12:12 hudsonbot Checkin
2012-05-25 12:12 hudsonbot Note Added: 0049165
2012-05-25 12:12 hudsonbot Checkin
2012-05-25 12:12 hudsonbot Note Added: 0049167

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker