0007536: Requisition to Order process fails if product price is 0

Description

If 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 Reproduce

Create 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".

Tags

commsup_sprint6

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0007528

closed

AinhoaPagola

Requisition to Order process fails if product price is 0

Notes
(0013449) svnbot (reporter) 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 (reporter) 2009-03-04 05:54	Now we can process requisition to order even if the product price is 0.

Issue History
Date Modified	Username	Field	Change
2009-02-12 16:01	gorkaion	Type	defect => backport
2009-02-12 16:01	gorkaion	fix_in_branch	trunk => 2.40
2009-02-12 16:01	gorkaion	Assigned To	rafaroda => AinhoaPagola
2009-02-13 10:17	svnbot	Checkin
2009-02-13 10:17	svnbot	Note Added: 0013449
2009-02-13 10:17	svnbot	Status	scheduled => resolved
2009-02-13 10:17	svnbot	Resolution	open => fixed
2009-02-13 10:17	svnbot	svn_revision	=> 13133
2009-02-13 10:43	AinhoaPagola	Tag Attached: commsup_sprint6
2009-03-03 17:31	psarobe	Fixed in Version	=> 2.40MP3
2009-03-04 05:54	arunkumar	Status	resolved => closed
2009-03-04 05:54	arunkumar	Note Added: 0014341