Hello,

I am trying to show some fields in a pdf report but getting this error :

Odoo Server Error

Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/qweb.py", line 333, in _compiled_fn
    return compiled(self, append, new, options, log)
  File "", line 1, in template_mosadakat_3ameel_report_res_partner_22
  File "", line 2, in body_call_content_20
  File "", line 3, in foreach_19
  File "", line 4, in body_call_content_17
TypeError: 'NoneType' object is not subscriptable

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 2034, in report_download
    response = self.report_routes(reportname, docids=docids, converter=converter, context=context)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 515, in response_wrap
    response = f(*args, **kw)
  File "/home/ubuntu/mymodules/report_xlsx/controllers/main.py", line 49, in report_routes
    reportname, docids, converter, **data
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 515, in response_wrap
    response = f(*args, **kw)
  File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 1972, in report_routes
    pdf = report.with_context(context).render_qweb_pdf(docids, data=data)[0]
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_actions_report.py", line 737, in render_qweb_pdf
    html = self.with_context(context).render_qweb_html(res_ids, data=data)[0]
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_actions_report.py", line 777, in render_qweb_html
    return self.render_template(self.report_name, data), 'html'
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_actions_report.py", line 548, in render_template
    return view_obj.render_template(template, values)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_ui_view.py", line 1191, in render_template
    return self.browse(self.get_view_id(template)).render(values, engine)
  File "/usr/lib/python3/dist-packages/odoo/addons/website/models/ir_ui_view.py", line 336, in render
    return super(View, self).render(values, engine=engine, minimal_qcontext=minimal_qcontext)
  File "/usr/lib/python3/dist-packages/odoo/addons/web_editor/models/ir_ui_view.py", line 27, in render
    return super(IrUiView, self).render(values=values, engine=engine, minimal_qcontext=minimal_qcontext)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_ui_view.py", line 1199, in render
    return self.env[engine].render(self.id, qcontext)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_qweb.py", line 58, in render
    result = super(IrQWeb, self).render(id_or_xml_id, values=values, **context)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/qweb.py", line 260, in render
    self.compile(template, options)(self, body.append, values or {})
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/qweb.py", line 340, in _compiled_fn
    raise QWebException("Error to render compiling AST", e, path, node and etree.tostring(node[0], encoding='unicode'), name)
odoo.addons.base.models.qweb.QWebException: 'NoneType' object is not subscriptable
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/qweb.py", line 333, in _compiled_fn
    return compiled(self, append, new, options, log)
  File "", line 1, in template_mosadakat_3ameel_report_res_partner_22
  File "", line 2, in body_call_content_20
  File "", line 3, in foreach_19
  File "", line 4, in body_call_content_17
TypeError: 'NoneType' object is not subscriptable

Error to render compiling AST
TypeError: 'NoneType' object is not subscriptable
Template: mosadakat_3ameel.report_res_partner
Path: /t/t/t/t/div[1]/div/span[4]

Here is my python code:

def _get_account_move_entry(self, accounts, init_balance, sortby, display_account):
    """
    :param:
            accounts: the recordset of accounts
            init_balance: boolean value of initial_balance
            sortby: sorting by date or partner and journal
            display_account: type of account(receivable, payable and both)

    Returns a dictionary of accounts with following key and value {
            'code': account code,
            'name': account name,
            'debit': sum of total debit amount,
            'credit': sum of total credit amount,
            'balance': total balance,
            'amount_currency': sum of amount_currency,
            'move_lines': list of move line
    }
    """
    cr = self.env.cr
    MoveLine = self.env['account.move.line']
    move_lines = {x: [] for x in accounts.ids}

    # Prepare initial sql query and Get the initial move lines
    if init_balance:
        init_tables, init_where_clause, init_where_params = MoveLine.with_context(
            date_from=self.env.context.get('date_from'), date_to=False, initial_bal=True)._query_get()
        init_wheres = [""]
        if init_where_clause.strip():
            init_wheres.append(init_where_clause.strip())
        init_filters = " AND ".join(init_wheres)
        filters = init_filters.replace('account_move_line__move_id', 'm').replace('account_move_line', 'l')
        sql = ("""SELECT 0 AS lid, l.account_id AS account_id, '' AS ldate, '' AS lcode, 0.0 AS amount_currency, '' AS lref, 'Initial Balance' AS lname, COALESCE(SUM(l.debit),0.0) AS debit, COALESCE(SUM(l.credit),0.0) AS credit, COALESCE(SUM(l.debit),0) - COALESCE(SUM(l.credit), 0) as balance, '' AS lpartner_id,\
            '' AS move_name, '' AS mmove_id, '' AS currency_code,\
            NULL AS currency_id,\
            '' AS invoice_id, '' AS invoice_type, '' AS invoice_number,\
            '' AS partner_name\
            FROM account_move_line l\
            LEFT JOIN account_move m ON (l.move_id=m.id)\
            LEFT JOIN res_currency c ON (l.currency_id=c.id)\
            LEFT JOIN res_partner p ON (l.partner_id=p.id)\
            JOIN account_journal j ON (l.journal_id=j.id)\
            WHERE l.account_id IN %s""" + filters + ' GROUP BY l.account_id')
        params = (tuple(accounts.ids),) + tuple(init_where_params)
        cr.execute(sql, params)
        for row in cr.dictfetchall():
            move_lines[row.pop('account_id')].append(row)

    sql_sort = 'l.date, l.move_id'
    if sortby == 'sort_journal_partner':
        sql_sort = 'j.code, p.name, l.move_id'

    # Prepare sql query base on selected parameters from wizard
    tables, where_clause, where_params = MoveLine._query_get()
    wheres = [""]
    if where_clause.strip():
        wheres.append(where_clause.strip())
    filters = " AND ".join(wheres)
    filters = filters.replace('account_move_line__move_id', 'm').replace('account_move_line', 'l')

    # Get move lines base on sql query and Calculate the total balance of move lines
    sql = ('''SELECT l.id AS lid, l.account_id AS account_id, l.date AS ldate, j.code AS lcode, l.currency_id, l.amount_currency, l.ref AS lref, l.name AS lname, COALESCE(l.debit,0) AS debit, COALESCE(l.credit,0) AS credit, COALESCE(SUM(l.debit),0) - COALESCE(SUM(l.credit), 0) AS balance,\
        m.name AS move_name, c.symbol AS currency_code, p.name AS partner_name\
        FROM account_move_line l\
        JOIN account_move m ON (l.move_id=m.id)\
        LEFT JOIN res_currency c ON (l.currency_id=c.id)\
        LEFT JOIN res_partner p ON (l.partner_id=p.id)\
        JOIN account_journal j ON (l.journal_id=j.id)\
        JOIN account_account acc ON (l.account_id = acc.id) \
        WHERE l.account_id IN %s ''' + filters + ''' GROUP BY l.id, l.account_id, l.date, j.code, l.currency_id, l.amount_currency, l.ref, l.name, m.name, c.symbol, p.name ORDER BY ''' + sql_sort)
    params = (tuple(accounts.ids),) + tuple(where_params)
    cr.execute(sql, params)

    for row in cr.dictfetchall():
        balance = 0
        for line in move_lines.get(row['account_id']):
            balance += line['debit'] - line['credit']
        row['balance'] += balance
        move_lines[row.pop('account_id')].append(row)

    # Calculate the debit, credit and balance for Accounts
    account_res = []
    for account in accounts:
        currency = account.currency_id and account.currency_id or account.company_id.currency_id
        res = dict((fn, 0.0) for fn in ['credit', 'debit', 'balance'])
        res['code'] = account.code
        res['name'] = account.name
        res['move_lines'] = move_lines[account.id]
        for line in res.get('move_lines'):
            res['debit'] += line['debit']
            res['credit'] += line['credit']
            res['balance'] = line['balance']
        if display_account == 'all':
            account_res.append(res)
        if display_account == 'movement' and res.get('move_lines'):
            account_res.append(res)
        if display_account == 'not_zero' and not currency.is_zero(res['balance']):
            account_res.append(res)
    return account_res

@api.model
def _get_report_values(self, docids, data=None):
    if not data.get('form') or not self.env.context.get('active_model'):
        raise UserError(_("Form content is missing, this report cannot be printed."))

    self.model = self.env.context.get('active_model')
    docs = self.env[self.model].browse(self.env.context.get('active_ids', []))

    init_balance = data['form'].get('initial_balance', True)
    sortby = data['form'].get('sortby', 'sort_date')
    display_account = data['form']['display_account']
    codes = []
    if data['form'].get('journal_ids', False):
        codes = [journal.code for journal in
                 self.env['account.journal'].search([('id', 'in', data['form']['journal_ids'])])]

    accounts = docs if self.model == 'account.account' else self.env['account.account'].search([])
    accounts_res = self.with_context(data['form'].get('used_context', {}))._get_account_move_entry(accounts,
                                                                                                   init_balance,
                                                                                                   sortby,
                                                                                                   display_account)
    return {
        'doc_ids': docids,
        'doc_model': self.model,
        'data': data['form'],
        'docs': docs,
        'time': time,
        'Accounts': accounts_res,
        'print_journal': codes,
    }

Thanks in advance.