Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007536Openbravo ERP03. Procurement managementpublic2009-02-12 13:452009-03-04 05:54
Reporternetworkb 
Assigned ToAinhoaPagola 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version2.40MP3 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007536: Requisition to Order process fails if product price is 0
DescriptionIf a requisition is created, and contains a line within a price 0, Requisition to Order process fails. This is the log showed:

SELECT M_REQUISITIONLINE.M_PRODUCT_ID, M_ATTRIBUTESETINSTANCE_ID, LOCKQTY, SUPPLIERNOTES AS DESCRIPTION, C_UOM_ID, M_REQUISITIONLINE_ID, '' AS C_ORDERLINE_ID, COALESCE(M_PRODUCTPRICE.PRICELIST, M_REQUISITIONLINE.PRICELIST, LOCKPRICE) AS PRICELIST, COALESCE(M_PRODUCTPRICE.PRICELIMIT, LOCKPRICE) AS PRICELIMIT, COALESCE(M_PRODUCTPRICE.PRICESTD, LOCKPRICE) AS PRICESTD, ROUND(COALESCE(LOCKPRICE, M_PRODUCTPRICE.PRICESTD),(SELECT PRICEPRECISION FROM C_CURRENCY WHERE C_CURRENCY_ID = to_number(?))) AS PRICEACTUAL, ROUND((COALESCE(M_PRODUCTPRICE.PRICELIST, M_REQUISITIONLINE.PRICELIST, LOCKPRICE) - COALESCE(LOCKPRICE, M_PRODUCTPRICE.PRICESTD))/ COALESCE(M_PRODUCTPRICE.PRICELIST, M_REQUISITIONLINE.PRICELIST, LOCKPRICE)*100, (SELECT STDPRECISION FROM C_CURRENCY WHERE C_CURRENCY_ID = ?)) AS DISCOUNT, C_GetTax(M_REQUISITIONLINE.M_PRODUCT_ID, to_date(?), to_number(?), to_number(?), to_number(?), to_number(?), null, 'N') AS TAX, CASE WHEN LOCKQTY < (M_REQUISITIONLINE.QTY - M_REQUISITIONLINE.ORDEREDQTY) THEN 'N' ELSE 'Y' END AS TO_CLOSE FROM M_REQUISITIONLINE LEFT JOIN M_PRODUCTPRICE ON M_REQUISITIONLINE.M_PRODUCT_ID = M_PRODUCTPRICE.M_PRODUCT_ID AND M_PRODUCTPRICE.M_PRICELIST_VERSION_ID = to_number(?) WHERE 1=1 AND M_RequisitionLine_ID IN('1000000') ORDER BY M_REQUISITIONLINE.M_PRODUCT_ID, M_ATTRIBUTESETINSTANCE_ID, SUPPLIERNOTES, ROUND(COALESCE(LOCKPRICE, M_PRODUCTPRICE.PRICESTD),(SELECT PRICEPRECISION FROM C_CURRENCY WHERE C_CURRENCY_ID = to_number(?)))Exception:java.sql.SQLException: ORA-01476: el divisor es igual a cero
Steps To ReproduceCreate a requisiton
Add a line with a product, and price 0.
Go to Requisition to Order process.
Select this requisition and process it.

Application shows a message like "Process run error".
Proposed Solution
Additional Information
Tagscommsup_sprint6
Relationships
blocks defect 0007528 closed AinhoaPagola Requisition to Order process fails if product price is 0 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-02-12 16:01gorkaionTypedefect => backport
2009-02-12 16:01gorkaionfix_in_branchtrunk => 2.40
2009-02-12 16:01gorkaionAssigned Torafaroda => AinhoaPagola
2009-02-13 10:17svnbotCheckin
2009-02-13 10:17svnbotNote Added: 0013449
2009-02-13 10:17svnbotStatusscheduled => resolved
2009-02-13 10:17svnbotResolutionopen => fixed
2009-02-13 10:17svnbotsvn_revision => 13133
2009-02-13 10:43AinhoaPagolaTag Attached: commsup_sprint6
2009-03-03 17:31psarobeFixed in Version => 2.40MP3
2009-03-04 05:54arunkumarStatusresolved => closed
2009-03-04 05:54arunkumarNote Added: 0014341

Notes
(0013449)
svnbot   
2009-02-13 10:17   
Repository: openbravo
Revision: 13133
Author: AinhoaPagola
Date: 2009-02-13 10:17:52 +0100 (Fri, 13 Feb 2009)

Fixes issue 0007536 Requisition to Order fixed for product price 0

---
U branches/r2.40/src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=13133&sc=1 [^]
(0014341)
arunkumar   
2009-03-04 05:54   
Now we can process requisition to order even if the product price is 0.