Index: openacs-4/packages/dotlrn-ecommerce/www/admin/ecommerce/index.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/www/admin/ecommerce/index.tcl,v diff -u -N -r1.18 -r1.19 --- openacs-4/packages/dotlrn-ecommerce/www/admin/ecommerce/index.tcl 11 Oct 2005 15:33:05 -0000 1.18 +++ openacs-4/packages/dotlrn-ecommerce/www/admin/ecommerce/index.tcl 21 Jan 2006 13:09:35 -0000 1.19 @@ -174,7 +174,7 @@ {"[_ dotlrn-ecommerce.Outstanding_blance]" balance} } where_clause { - (case when t.method = 'invoice' then + (case when method = 'invoice' then ec_total_price(order_id) - ec_order_gift_cert_amount(order_id) - (select coalesce(sum(amount), 0) from dotlrn_ecommerce_transaction_invoice_payments