Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

how fixed thies error :Invalid XML for View Architecture!

By
Muaz
on 1/1/14, 7:09 PM 1,824 views

whine i install my module show this error: (('ValidateError', u'Error occurred while validating the field(s) arch: Invalid XML for View Architecture!'))

my files:

accbalance.py:

from osv import fields, osv
import time
class accbalance(osv.osv):
_name = 'account.account'
_inherit = 'account.account'
_description = 'Simple accountiec'
_columns = {

    }
accbalance()

accbalance_view.xml:

<?xml version="1.0" encoding="utf-8"?>
<openerp>
<data>
<record id="view_accaccount_form" model="ir.ui.view">
        <field name="name">account.account.form</field>
        <field name="model">account.account</field>
        <field name="arch" type="xml">
            <form string="Account" version="7.0">
                    <group>
                        <field name="parent_id"/>
                        <field name="type"/>
                        <field name="user_type"/>
                        <field name="active"/>
                        <field name="company_id" widget="selection" groups="base.group_multi_company"/>
                    </group>
            </form>
        </field>
    </record>

    <record id="view_accaccount_tree" model="ir.ui.view">
        <field name="name">account.account.tree</field>
        <field name="model">account.account</field>
        <field name="arch" type="xml">
            <tree string="Chart of accounts" toolbar="1" >
                <field name="parent_id"/>
                <field name="type"/>
                <field name="user_type"/>
                <field name="active"/>
                <field name="company_id"/>
            </tree>
        </field>
    </record>

    <record id="accaction_account_form" model="ir.actions.act_window">
        <field name="name">Accounts</field>
        <field name="res_model">account.account</field>
        <field name="view_type">form</field>
        <field name="view_id" ref="view_accaccount_tree"/>
    </record>

</data> </openerp>

wizard file:

account_balance_report.py:

from openerp.osv import fields, osv

 class account_balance_report(osv.osv_memory):
_inherit = "account.common.account.report"
_name = 'account.balance.report'
_description = 'Trial Balance Report'

_columns = {
    'journal_ids': fields.many2many('account.journal', 'account_balance_report_journal_rel', 'account_id', 'journal_id', 'Journals', required=True),
}

_defaults = {
    'journal_ids': [],
}

def _print_report(self, cr, uid, ids, data, context=None):
    data = self.pre_print_report(cr, uid, ids, data, context=context)
    return {'type': 'ir.actions.report.xml', 'report_name': 'account.account.balance', 'datas': data}

account_balance_report()

account_report_account_accbalance_view.xml:

<?xml version="1.0" encoding="utf-8"?>

<openerp> <data>

    <record id="account_report_accbalance_view" model="ir.ui.view">
      <field name="name">Balance</field>
      <field name="model">account.balance.report</field>
      <field name="inherit_id" ref="account.account_common_report_view" />
      <field name="arch" type="xml">
        <data>
        <xpath expr="//notebook/page[@string='Journals']" position="replace">
        </xpath>
        <xpath expr="//field[@name='target_move']" position="after">
            <field name="display_account"/>
            <newline/>
        </xpath>
        </data>
      </field>
    </record>

    <record id="action_account_accbalance_menu" model="ir.actions.act_window">
        <field name="name">Trial Balance</field>
        <field name="type">ir.actions.act_window</field>
        <field name="res_model">account.balance.report</field>
        <field name="view_type">form</field>
        <field name="view_mode">form</field>
        <field name="view_id" ref="account_report_accbalance_view"/>
        <field name="target">new</field>
    </record>

    <menuitem
            name="acc Trial Balance"
            parent="account.final_accounting_reports"
            action="action_account_accbalance_menu"
            id="menu_general_accBalance_report"
           />

    <record model="ir.values" id="action_account_accbalance_report_values1">
        <field name="model_id" ref="account.model_account_account" />
        <field name="name">acc Trial Balance</field>
        <field name="key2">client_print_multi</field>
        <field name="value" eval="'ir.actions.act_window,' +str(ref('action_account_accbalance_menu'))" />
        <field name="key">action</field>
        <field name="model">account.account</field>
    </record>

    <record id="action_account_accbalance2_menu" model="ir.actions.act_window">
        <field name="name">Trial Balance</field>
        <field name="type">ir.actions.act_window</field>
        <field name="res_model">account.balance.report</field>
        <field name="view_type">form</field>
        <field name="view_mode">form</field>
        <field name="view_id" ref="account_report_accbalance_view"/>
        <field name="target">new</field>
    </record>

</data>

</openerp>

report files: account_balance.py:

import time

from openerp.report import report_sxw
from common_report_header import common_report_header

 class account_balance(report_sxw.rml_parse, common_report_header):
_name = 'report.account.account.balance'

def __init__(self, cr, uid, name, context=None):
    super(account_balance, self).__init__(cr, uid, name, context=context)
    self.sum_debit = 0.00
    self.sum_credit = 0.00
    self.date_lst = []
    self.date_lst_string = ''
    self.result_acc = []
    self.localcontext.update({
        'time': time,
        'lines': self.lines,
        'sum_debit': self._sum_debit,
        'sum_credit': self._sum_credit,
        'get_fiscalyear':self._get_fiscalyear,
        'get_filter': self._get_filter,
        'get_start_period': self.get_start_period,
        'get_end_period': self.get_end_period ,
        'get_account': self._get_account,
        'get_journal': self._get_journal,
        'get_start_date':self._get_start_date,
        'get_end_date':self._get_end_date,
        'get_target_move': self._get_target_move,
    })
    self.context = context

def set_context(self, objects, data, ids, report_type=None):
    new_ids = ids
    if (data['model'] == 'ir.ui.menu'):
        new_ids = 'chart_account_id' in data['form'] and [data['form']['chart_account_id']] or []
        objects = self.pool.get('account.account').browse(self.cr, self.uid, new_ids)
    return super(account_balance, self).set_context(objects, data, new_ids, report_type=report_type)

#def _add_header(self, node, header=1):
#    if header == 0:
#        self.rml_header = ""
#    return True

def _get_account(self, data):
    if data['model']=='account.account':
        return self.pool.get('account.account').browse(self.cr, self.uid, data['form']['id']).company_id.name
    return super(account_balance ,self)._get_account(data)

def lines(self, form, ids=None, done=None):
    def _process_child(accounts, disp_acc, parent):
            account_rec = [acct for acct in accounts if acct['id']==parent][0]
            currency_obj = self.pool.get('res.currency')
            acc_id = self.pool.get('account.account').browse(self.cr, self.uid, account_rec['id'])
            currency = acc_id.currency_id and acc_id.currency_id or acc_id.company_id.currency_id
            res = {
                'id': account_rec['id'],
                'type': account_rec['type'],
                'code': account_rec['code'],
                'name': account_rec['name'],
                'level': account_rec['level'],
                'debit': account_rec['debit'],
                'credit': account_rec['credit'],
                'balance': account_rec['balance'],
                'parent_id': account_rec['parent_id'],
                'bal_type': '',
            }
            self.sum_debit += account_rec['debit']
            self.sum_credit += account_rec['credit']
            if disp_acc == 'movement':
                if not currency_obj.is_zero(self.cr, self.uid, currency, res['credit']) or not currency_obj.is_zero(self.cr, self.uid, currency, res['debit']) or not currency_obj.is_zero(self.cr, self.uid, currency, res['balance']):
                    self.result_acc.append(res)
            elif disp_acc == 'not_zero':
                if not currency_obj.is_zero(self.cr, self.uid, currency, res['balance']):
                    self.result_acc.append(res)
            else:
                self.result_acc.append(res)
            if account_rec['child_id']:
                for child in account_rec['child_id']:
                    _process_child(accounts,disp_acc,child)

    obj_account = self.pool.get('account.account')
    if not ids:
        ids = self.ids
    if not ids:
        return []
    if not done:
        done={}

    ctx = self.context.copy()

    ctx['fiscalyear'] = form['fiscalyear_id']
    if form['filter'] == 'filter_period':
        ctx['period_from'] = form['period_from']
        ctx['period_to'] = form['period_to']
    elif form['filter'] == 'filter_date':
        ctx['date_from'] = form['date_from']
        ctx['date_to'] =  form['date_to']
    ctx['state'] = form['target_move']
    parents = ids
    child_ids = obj_account._get_children_and_consol(self.cr, self.uid, ids, ctx)
    if child_ids:
        ids = child_ids
    accounts = obj_account.read(self.cr, self.uid, ids, ['type','code','name','debit','credit','balance','parent_id','level','child_id'], ctx)

    for parent in parents:
            if parent in done:
                continue
            done[parent] = 1
            _process_child(accounts,form['display_account'],parent)
    return self.result_acc

  report_sxw.report_sxw('report.account.account.accbalance', 'account.account', 'addons/account/report/account_balance.rml', parser=account_balance, header="internal")

account_report.xml:

<?xml version="1.0" encoding="utf-8"?>
<openerp>
<data>

    <report auto="False" id="account_account_accbalance" menu="False" model="account.account" name="account.account.accbalance" rml="accbalance/report/account_balance.rml" string="Trial Balance"/>



</data>

</openerp>

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 1/1/14, 7:09 PM
Seen: 1824 times
Last updated: 3/16/15, 8:10 AM