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

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 03. Procurement managementmajorhave not tried2017-03-07 13:512017-03-13 01:13
ReporteraferrazView Statuspublic 
Assigned Tomcobas 
PriorityimmediateResolutionfixedFixed in Version3.0PR17Q1
StatusclosedFix in branchFixed in SCM revisiond45ceafdfe19
ProjectionnoneETAnoneTarget Version3.0PR17Q1
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

0035491: 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 ]
blocks defect 00354473.0PR17Q2 closedmcobas Not possible to create an Order from a Requisition using Requisition To Order 

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

Repository: erp/backports/3.0PR17Q1
Changeset: d45ceafdfe198779adcf2557550af0ef1c280e24
Author: Miguel <martencobasmiguel <at>>
Date: Fri Mar 10 11:11:58 2017 -0500
URL: [^]

Fixes issue 35491: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

- Issue History
Date Modified Username Field Change
2017-03-12 17:14 markmm82 Type defect => backport
2017-03-12 17:14 markmm82 Target Version 3.0PR17Q2 => 3.0PR17Q1
2017-03-13 01:11 hgbot Checkin
2017-03-13 01:11 hgbot Note Added: 0094965
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: 0094966
2017-03-13 01:13 markmm82 Status resolved => closed
2017-03-13 01:13 markmm82 Fixed in Version => 3.0PR17Q1

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker