[FIX]: Report Bug for Partner Balance & Ledger (case:16036)

bzr revid: ado@tinyerp.com-20110708132027-jg7zmn0l4thscrgp

diff --git a/addons/account/report/partner_balance.py b/addons/account/report/partner_balance.py
index 6540086..f6d1e46 100755 (executable)
--- a/addons/account/report/partner_balance.py
+++ b/addons/account/report/partner_balance.py
@@ -196,7 +196,7 @@ class partner_balance(report_sxw.rml_parse):
         result_tmp = 0.0
         if self.date_lst:
             self.cr.execute(
-                "SELECT p.ref,l.account_id,ac.name as account_name,ac.code as code ,p.name, sum(debit) as debit, sum(credit) as credit, " \
+                "SELECT p.ref,l.account_id,ac.name as account_name,ac.code as code ,p.name, COALESCE(sum(debit),0.00) as debit, COALESCE(sum(credit),0.00) as credit, " \
                         "CASE WHEN sum(debit) > sum(credit) " \
                             "THEN sum(debit) - sum(credit) " \
                             "ELSE 0 " \

diff --git a/addons/account/report/third_party_ledger.py b/addons/account/report/third_party_ledger.py
index def13b4..c878ecc 100644 (file)
--- a/addons/account/report/third_party_ledger.py
+++ b/addons/account/report/third_party_ledger.py
@@ -255,7 +255,7 @@ class third_party_ledger(rml_parse.rml_parse):
 #                              full_account.append(r)
                if self.date_lst_string:
                        self.cr.execute(
-                               "SELECT l.id,l.date,j.code, l.ref, l.name, l.debit, l.credit " \
+                               "SELECT l.id,l.date,j.code, l.ref, l.name, COALESCE(l.debit,0.00) as debit, COALESCE(l.credit,0.00) as credit " \
                                "FROM account_move_line l " \
                                "LEFT JOIN account_journal j " \
                                        "ON (l.journal_id = j.id) " \