Issue #24224:normalize margin calculations

[xtuple] / foundation-database / public / functions / calcinvoiceamt.sql

diff --git a/foundation-database/public/functions/calcinvoiceamt.sql b/foundation-database/public/functions/calcinvoiceamt.sql
index fb79c3f..a60452d 100644 (file)
--- a/foundation-database/public/functions/calcinvoiceamt.sql
+++ b/foundation-database/public/functions/calcinvoiceamt.sql
@@ -37,7 +37,7 @@ BEGIN
   WHERE (invcitem_invchead_id=pInvcheadid);
 
   IF (pType IN ('T', 'X')) THEN
-    SELECT SUM(tax) INTO _tax
+    SELECT COALESCE(SUM(tax), 0.0) INTO _tax
     FROM (SELECT COALESCE(ROUND(SUM(taxdetail_tax), 2), 0.0) AS tax
           FROM tax
                JOIN calculateTaxDetailSummary('I', pInvcheadid, 'T')ON (taxdetail_tax_id=tax_id)