Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementmajorhave not tried2017-03-07 13:512017-03-15 20:22
ReporteraferrazView Statuspublic 
Assigned Tomcobas 
PriorityimmediateResolutionfixedFixed in Version3.0PR17Q2
StatusclosedFix in branchFixed in SCM revision123bf7a64512
ProjectionnoneETAnoneTarget Version3.0PR17Q2
OSLinux 64 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionProfessional ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Review Assigned Tomarkmm82
Web browser
Regression levelPackaging and release
Regression date2016-12-02
Regression introduced in releasemain
Regression introduced by commit [^]
Triggers an Emergency PackNo

0035447: Not possible to create an Order from a Requisition using Requisition To Order

DescriptionNot possible to create an Order from a Requisition using Requisition To Order
Steps To ReproduceUsing F&B Admin:

- Create a Requisition for Bebidas Alegres partner
- Add a line for Agua sin Gas product and set a net unit price of 3
- Complete the requisition
- Create an order from the requisition using Requisition To Order window
- Check you get the following error: You have filled in Quantity order without selecting a corresponding UOM order , or viceversa. Fill in both fields, or leave them empty

TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 00354913.0PR17Q1 closedmcobas Not possible to create an Order from a Requisition using Requisition To Order 

-  Notes
hgbot (developer)
2017-03-13 01:11

Repository: erp/devel/pi
Changeset: 123bf7a64512b73324040553df9dab7831f54c2b
Author: Miguel <martencobasmiguel <at>>
Date: Fri Mar 10 11:11:58 2017 -0500
URL: [^]

Fixes issue 35447:Error creating an Order from a Requisition To Order.

In AUM project the Constraint c_orderline_check1 was modified, to only allow creation
of order lines whith QUANTITYORDER and M_PRODUCT_UOM_ID values null or not null at same time.
When they were created from the Requisition to Order process, the Order line's QUANTITYORDER
was created with 0 in the case it had a NULL value, instead of maintain the value as NULL.
Because of it the constraint was failing because a QUANTITYORDER=0 and a M_PRODUCT_UOM_ID=NULL.

To solve this problem was modified the linesToOrder query in RequisitionToOrder_data.xsql, to
retrieve the correct value of QUANTITYORDER, including NULL if there are no qty in the second

M src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql
markmm82 (developer)
2017-03-13 01:13

Code review + Testing OK
hudsonbot (developer)
2017-03-15 20:22

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2017-03-07 13:51 aferraz New Issue
2017-03-07 13:51 aferraz Assigned To => Triage Finance
2017-03-07 13:51 aferraz Modules => Core
2017-03-07 13:51 aferraz Regression level => Packaging and release
2017-03-07 13:51 aferraz Triggers an Emergency Pack => No
2017-03-07 13:52 aferraz Regression introduced in release => main
2017-03-07 14:23 markmm82 Assigned To Triage Finance => mcobas
2017-03-12 17:12 markmm82 Regression date => 2016-12-02
2017-03-12 17:12 markmm82 Regression introduced by commit => [^]
2017-03-12 17:14 markmm82 Status new => scheduled
2017-03-13 01:11 hgbot Checkin
2017-03-13 01:11 hgbot Note Added: 0094964
2017-03-13 01:11 hgbot Status scheduled => resolved
2017-03-13 01:11 hgbot Resolution open => fixed
2017-03-13 01:11 hgbot Fixed in SCM revision => [^]
2017-03-13 01:13 markmm82 Review Assigned To => markmm82
2017-03-13 01:13 markmm82 Note Added: 0094967
2017-03-13 01:13 markmm82 Status resolved => closed
2017-03-13 01:13 markmm82 Fixed in Version => 3.0PR17Q2
2017-03-15 20:22 hudsonbot Checkin
2017-03-15 20:22 hudsonbot Note Added: 0095292

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker