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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0035491
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 
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
Summary

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
(0094965)
hgbot (developer)
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 (viewer)
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 => http://code.openbravo.com/erp/backports/3.0PR17Q1/rev/d45ceafdfe198779adcf2557550af0ef1c280e24 [^]
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