+
+ # Each row here is the sum of the discounts where taxes were applied pre discount
+ my $discount = "SELECT SUM(cust_bill_pkg_discount.amount) AS discount_amount, cust_bill_pkg_discount.billpkgnum
+ FROM cust_bill_pkg_discount
+ LEFT JOIN cust_bill_pkg_tax_location ON (cust_bill_pkg_tax_location.taxable_billpkgnum = cust_bill_pkg_discount.billpkgnum)
+ LEFT JOIN cust_main_county USING (taxnum)
+ WHERE cust_main_county.charge_prediscount = 'Y'
+ GROUP BY cust_bill_pkg_discount.billpkgnum";