← Back to branch summary

~jgrandguillaume-c2c/openobject-addons/multi-company-cost-price

« back to all changes in this revision

Viewing changes to account/report/general_ledger_landscape.py

  • Committer: Joël Grand-Guillaume
  • Date: 2010-04-08 09:00:10 UTC
  • mfrom: (2533.3.664)
  • Revision ID: joel.grandguillaume@camptocamp.com-20100408090010-c0pqjan341s18bxs
[MRG] Merge from last trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
account/report/general_ledger_landscape.py
27
27
##############################################################################
28
28
 
29
29
import time
30
 
from mx.DateTime import *
31
30
from report import report_sxw
32
31
import xml
33
32
import rml_parse
261
260
        else:
262
261
            sorttag = 'j.code'
263
262
        sql = """
264
 
            SELECT l.id, l.date, j.code,c.code AS currency_code,l.amount_currency,l.ref, l.name , l.debit, l.credit, l.period_id
 
263
            SELECT l.id, l.date, j.code,c.code AS currency_code,l.amount_currency,l.ref, l.name , COALESCE(l.debit,0) as debit, COALESCE(l.credit,0) as credit, l.period_id
265
264
                    FROM account_move_line as l
266
265
                       LEFT JOIN res_currency c on (l.currency_id=c.id)
267
266
                          JOIN account_journal j on (l.journal_id=j.id)