Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035491Openbravo ERP03. Procurement managementpublic2017-03-07 13:512017-03-13 01:13
Reporteraferraz 
Assigned Tomcobas 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS30OS VersionProfessional Appliance
Product Version 
Target Version3.0PR17Q1Fixed in Version3.0PR17Q1 
Merge Request Status
Review Assigned Tomarkmm82
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression levelPackaging and release
Regression date2016-12-02
Regression introduced in releasemain
Regression introduced by commithttp://code.openbravo.com/erp/devel/pi/rev/5c95279a6932 [^]
Triggers an Emergency PackNo
Summary0035491: 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

Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 00354473.0PR17Q2 closed mcobas Not possible to create an Order from a Requisition using Requisition To Order 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-03-12 17:14markmm82Typedefect => backport
2017-03-12 17:14markmm82Target Version3.0PR17Q2 => 3.0PR17Q1
2017-03-13 01:11hgbotCheckin
2017-03-13 01:11hgbotNote Added: 0094965
2017-03-13 01:11hgbotStatusscheduled => resolved
2017-03-13 01:11hgbotResolutionopen => fixed
2017-03-13 01:11hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR17Q1/rev/d45ceafdfe198779adcf2557550af0ef1c280e24 [^]
2017-03-13 01:13markmm82Review Assigned To => markmm82
2017-03-13 01:13markmm82Note Added: 0094966
2017-03-13 01:13markmm82Statusresolved => closed
2017-03-13 01:13markmm82Fixed in Version => 3.0PR17Q1

Notes
(0094965)
hgbot   
2017-03-13 01:11   
Repository: erp/backports/3.0PR17Q1
Changeset: d45ceafdfe198779adcf2557550af0ef1c280e24
Author: Miguel <martencobasmiguel <at> gmail.com>
Date: Fri Mar 10 11:11:58 2017 -0500
URL: http://code.openbravo.com/erp/backports/3.0PR17Q1/rev/d45ceafdfe198779adcf2557550af0ef1c280e24 [^]

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
UOM.

---
M src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql
---
(0094966)
markmm82   
2017-03-13 01:13   
Code review + Testing OK