0001179: Division by 0 error when generating average cost

Notes
(0001043) gorkaion (developer) 2007-05-10 13:17 edited on: 2008-06-12 09:18	Logged In: YES user_id=1500690 Originator: YES It has been detected a problem when there is a receipt that its invoice has been cancelled. In this case the total quantity invoiced could be 0. It has been changed the PL to avoid this cases. The changes on Generate_Average_costs PL are (at lines 130-146): SELECT CASE WHEN SUM(QTYINVOICED) <= 0 THEN 0 ELSE SUM(C_INVOICELINE.QTYINVOICEDC_INVOICELINE.PRICEACTUAL) /SUM(QTYINVOICED) END, CASE WHEN SUM(QTYINVOICED) <= 0 THEN 0 ELSE COUNT(C_INVOICELINE.C_INVOICELINE_ID) END INTO v_Price, v_Count FROM M_MATCHINV, C_INVOICELINE WHERE M_MATCHINV.C_INVOICELINE_ID=C_INVOICELINE.C_INVOICELINE_ID AND M_MATCHINV.M_INOUTLINE_ID=Cur_InOutLine.M_INOUTLINE_ID AND QTYINVOICED<>0; IF(v_Count=0) THEN SELECT CASE WHEN SUM(C_ORDERLINE.QTYORDERED) <= 0 THEN 0 ELSE SUM(C_ORDERLINE.QTYORDEREDC_ORDERLINE.PRICEACTUAL) /SUM(C_ORDERLINE.QTYORDERED) END, CASE WHEN SUM(C_ORDERLINE.QTYORDERED) <= 0 THEN 0 ELSE COUNT(C_ORDERLINE.C_ORDERLINE_ID) END INTO v_Price, v_Count FROM M_MATCHPO, C_ORDERLINE WHERE M_MATCHPO.C_ORDERLINE_ID=C_ORDERLINE.C_ORDERLINE_ID AND M_MATCHPO.C_INVOICELINE_ID IS NULL AND M_MATCHPO.M_INOUTLINE_ID=Cur_InOutLine.M_INOUTLINE_ID AND C_ORDERLINE.QTYORDERED<>0; END IF;

(0004768) user71 2005-06-01 00:00 edited on: 2008-06-12 09:43	This bug was originally reported in SourceForge bug tracker and then migrated to Mantis. You can see the original bug report in: https://sourceforge.net/support/tracker.php?aid=1716390 [^]

Issue History
Date Modified	Username	Field	Change

Relationships [ Relation Graph ] [ Dependency Graph ]