Merge lp:~vauxoo/openerp-venezuela-localization/debit-credit-note into lp:~openerp-venezuela/openerp-venezuela-localization/6.0-trunk

[Javier Duran]

Se agrega modulo que genera notas de debitos y mejora la funcionalidad de notas de debito

[Gabriela Quilarque (gabrielaquilarque97)]

Error arrojado al instentar instalar el modulo en una BD nueva.

[2011-11-01 18:40:19,708][javier_debit_credit2] ERROR:tools.convert.xml_import:Parse error in /home/operador/6_0/server/bin/addons/debit_credit_note/account_invoice_view.xml:55:
<record id="account_inv_ext_form_crdrc" model="ir.ui.view">
            <field name="name">invoice_ext.form.crdrc</field>
            <field name="model">account.invoice</field>
            <field name="type">tree</field>
            <field name="inherit_id" ref="account.invoice_form"/>
            <field name="arch" type="xml">
                <data><xpath expr="/form/group/field[@name='period_id']" position="after">
                    <field name="parent_id" attrs="{'required':[('type','=','out_refund')]}" domain="[('partner_id','=',partner_id),('id', '!=', active_id),('type','in',['out_invoice', 'out_refund'])]"/>
                </xpath>
                <xpath expr="//button[@string='Refund']" position="after">
                    <button name="%(action_account_invoice_debit)d" type="action" string="Debit Note" states="open,paid" icon="gtk-execute" domain="[('type','=','out_invoice')]"/>
                </xpath>
            </data></field>
        </record>
Traceback (most recent call last):
  File "/home/operador/6_0/server/bin/tools/convert.py", line 865, in parse
    self._tags[rec.tag](self.cr, rec, n)
  File "/home/operador/6_0/server/bin/tools/convert.py", line 832, in _tag_record
    id = self.pool.get('ir.model.data')._update(cr, self.uid, rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode, context=rec_context )
  File "/home/operador/6_0/server/bin/addons/base/ir/ir_model.py", line 691, in _update
    res_id = model_obj.create(cr, uid, values, context=context)
  File "/home/operador/6_0/server/bin/osv/orm.py", line 3690, in create
    self._validate(cr, user, [id_new], context)
  File "/home/operador/6_0/server/bin/osv/orm.py", line 946, in _validate
    raise except_orm('ValidateError', '\n'.join(error_msgs))
except_orm: ('ValidateError', u'Error occurred while validating the field(s) arch: Invalid XML for View Architecture!')

review: Needs Fixing

[lp:~vauxoo/openerp-venezuela-localization/debit-credit-note]

469. By Javier Duran on 2011-11-02

[IMP] mejoras menores en la vista y el parser del wizard de nota de debito

[Javier Duran (javieredm)]

Corrección realizada.

review: Needs Resubmitting

[Gabriela Quilarque (gabrielaquilarque97)]

Se crea un nuevo branch para:
- Unir l10n_ve_fiscal_requirements con debit_credit_note.
- Agregar traducciones del modulo debit_credit_note.
- Corregir el campo parent_id en la vista de factura.
- Agregar seguridad al modulo debit_credit_note.
- Agregar descripción acerca del modulo debit_credit_note en el archivo __openerp__.py del modulo l10n_ve_fiscal_requirements.

branch: https://code.launchpad.net/~vauxoo/openerp-venezuela-localization/gaby-merge-debit-credit-fiscal-requirements

[Javier Duran (javieredm)]

Merged en el trunk
revno: 474
Revision ID: <email address hidden>

review: Approve

=== added directory 'debit_credit_note'
=== added file 'debit_credit_note/__init__.py'
--- debit_credit_note/__init__.py	1970-01-01 00:00:00 +0000
+++ debit_credit_note/__init__.py	2011-11-02 16:10:43 +0000
@@ -0,0 +1,37 @@
+#!/usr/bin/python
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2010 Vauxoo C.A. (http://openerp.com.ve/) All Rights Reserved.
+#                    Javier Duran <[e-mail]>
+# 
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# This program is Free Software; you can redistribute it and/or
+# modify it under the terms of the GNU General Public License
+# as published by the Free Software Foundation; either version 2
+# of the License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+
+import invoice
+import wizard
+
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'debit_credit_note/__openerp__.py'
--- debit_credit_note/__openerp__.py	1970-01-01 00:00:00 +0000
+++ debit_credit_note/__openerp__.py	2011-11-02 16:10:43 +0000
@@ -0,0 +1,53 @@
+#!/usr/bin/python
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2010 Vauxoo C.A. (http://openerp.com.ve/) All Rights Reserved.
+#                    Javier Duran <[e-mail]>
+# 
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# This program is Free Software; you can redistribute it and/or
+# modify it under the terms of the GNU General Public License
+# as published by the Free Software Foundation; either version 2
+# of the License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+{
+    "name" : "Debit and Credit Notes on Invoice",
+    "version" : "0.2",
+    "author" : "Vauxoo",
+    "website": "http://vauxoo.com",
+    "category" : "Generic Modules/Accounting",
+    "description": '''This module ads credit a debit notes on each invoices
+''',
+    "init_xml" : [],
+    "depends" : ["base","account"],
+    "update_xml" : [
+            'wizard/account_invoice_debit_view.xml',
+            "account_invoice_view.xml",
+    ],
+    "demo_xml" : [],
+    'test': [],
+    "installable": True,
+    "active": False,
+
+}
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'debit_credit_note/account_invoice_view.xml'
--- debit_credit_note/account_invoice_view.xml	1970-01-01 00:00:00 +0000
+++ debit_credit_note/account_invoice_view.xml	2011-11-02 16:10:43 +0000
@@ -0,0 +1,90 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+
+
+
+    <!-- 
+    =====================================================
+    Invoices Extension
+    =====================================================
+    -->  
+
+        <record id="account_inv_ext_view_form_crdr" model="ir.ui.view">
+            <field name="name">invoice_extended.form.crdr</field>
+            <field name="model">account.invoice</field>
+            <field name="type">form</field>
+            <field name="inherit_id" ref="account.invoice_form"/>
+            <field name="arch" type="xml">
+                <notebook>
+                    <page string="Debit-Credit Notes" position="inside">
+                        <field name="child_ids" nolabel="1" widget="many2many" domain="[('partner_id','=',partner_id),('id', '!=', active_id),('type','in',['out_invoice', 'out_refund'])]"/>
+                    </page>
+                </notebook>
+            </field>
+        </record>
+
+
+
+        <record id="account_inv_ext_view_supp_form_crdr" model="ir.ui.view">
+            <field name="name">invoice_extended.supplier.form.crdr</field>
+            <field name="model">account.invoice</field>
+            <field name="type">form</field>
+            <field name="inherit_id" ref="account.invoice_supplier_form"/>
+            <field name="arch" type="xml">
+                <notebook>
+                    <page string="Debit-Credit Notes" position="inside">
+                        <field name="child_ids" nolabel="1" widget="many2many" domain="[('partner_id','=',partner_id),('id', '!=', active_id),('type','in',['in_invoice', 'in_refund'])]"/>
+                    </page>
+                </notebook>
+            </field>
+        </record>
+
+
+        <record id="account_inv_ext_view_tree_crdr" model="ir.ui.view">
+            <field name="name">invoice_extended.tree.crdr</field>
+            <field name="model">account.invoice</field>
+            <field name="type">tree</field>
+            <field name="inherit_id" ref="account.invoice_tree"/>
+            <field name="arch" type="xml">
+                <xpath expr="/tree/field[@name='origin']" position="after">
+                    <field name="parent_id"/>
+                </xpath>
+            </field>
+        </record>
+        <record id="account_inv_ext_form_crdrc" model="ir.ui.view">
+            <field name="name">invoice_ext.form.crdrc</field>
+            <field name="model">account.invoice</field>
+            <field name="type">tree</field>
+            <field name="inherit_id" ref="account.invoice_form"/>
+            <field name="arch" type="xml">
+                <xpath expr="/form/group/field[@name='period_id']" position="after">
+                    <field name="parent_id" attrs="{'required':[('type','=','out_refund')]}" domain="[('partner_id','=',partner_id),('id', '!=', active_id),('type','in',['out_invoice', 'out_refund'])]"/>
+                </xpath>
+                <xpath expr="//button[@string='Refund']" position="after">
+                    <button name="%(action_account_invoice_debit)d" type='action' string='Debit Note' states='open,paid' icon="gtk-execute" attrs="{'invisible':[('type','in',['in_refund', 'out_refund'])]}"/>
+                </xpath>
+            </field>
+        </record>
+        <record id="account_inv_ext_form_crdrs" model="ir.ui.view">
+            <field name="name">invoice_ext.form.crdrs</field>
+            <field name="model">account.invoice</field>
+            <field name="type">tree</field>
+            <field name="inherit_id" ref="account.invoice_supplier_form"/>
+            <field name="arch" type="xml">
+                <xpath expr="/form/group/field[@name='period_id']" position="after">
+                    <field name="parent_id" attrs="{'required':[('type','=','in_refund')]}" domain="[('partner_id','=',partner_id),('id', '!=', active_id),('type','in',['in_invoice', 'in_refund'])]"/>
+                </xpath>
+                <xpath expr="//button[@string='Refund']" position="after">
+                    <button name="%(action_account_invoice_debit)d" type='action' string='Debit Note' states='open,paid' icon="gtk-execute" attrs="{'invisible':[('type','in',['in_refund', 'out_refund'])]}"/>
+                </xpath>
+            </field>
+        </record>
+
+
+
+
+
+
+    </data>
+</openerp>

=== added file 'debit_credit_note/invoice.py'
--- debit_credit_note/invoice.py	1970-01-01 00:00:00 +0000
+++ debit_credit_note/invoice.py	2011-11-02 16:10:43 +0000
@@ -0,0 +1,49 @@
+#!/usr/bin/python
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2010 Vauxoo C.A. (http://openerp.com.ve/) All Rights Reserved.
+#                    Javier Duran <[e-mail]>
+# 
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# This program is Free Software; you can redistribute it and/or
+# modify it under the terms of the GNU General Public License
+# as published by the Free Software Foundation; either version 2
+# of the License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+import time
+from osv import fields, osv
+
+
+
+class account_invoice(osv.osv):
+    _inherit = 'account.invoice'
+    _columns = {
+        'parent_id':fields.many2one('account.invoice', 'Parent Invoice', readonly=True, states={'draft':[('readonly',False)]}, help='Al seleccionar este campo, la factura se convertira en una nota de debito'),
+        'child_ids':fields.one2many('account.invoice', 'parent_id', 'Debit and Credit Notes', readonly=True, states={'draft':[('readonly',False)]}),
+    }
+
+
+account_invoice()
+
+
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added directory 'debit_credit_note/wizard'
=== added file 'debit_credit_note/wizard/__init__.py'
--- debit_credit_note/wizard/__init__.py	1970-01-01 00:00:00 +0000
+++ debit_credit_note/wizard/__init__.py	2011-11-02 16:10:43 +0000
@@ -0,0 +1,37 @@
+#!/usr/bin/python
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2010 Vauxoo C.A. (http://openerp.com.ve/) All Rights Reserved.
+#                    Javier Duran <[e-mail]>
+# 
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# This program is Free Software; you can redistribute it and/or
+# modify it under the terms of the GNU General Public License
+# as published by the Free Software Foundation; either version 2
+# of the License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+
+import account_invoice_refund
+import account_invoice_debit
+
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'debit_credit_note/wizard/account_invoice_debit.py'
--- debit_credit_note/wizard/account_invoice_debit.py	1970-01-01 00:00:00 +0000
+++ debit_credit_note/wizard/account_invoice_debit.py	2011-11-02 16:10:43 +0000
@@ -0,0 +1,233 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+import time
+
+from osv import fields, osv
+from tools.translate import _
+import netsvc
+
+class account_invoice_debit(osv.osv_memory):
+
+    """Debits Note from Invoice"""
+
+    _name = "account.invoice.debit"
+    _description = "Invoice Debit Note"
+    _columns = {
+       'date': fields.date('Operation date', help='This date will be used as the invoice date for Refund Invoice and Period will be chosen accordingly!'),
+       'period': fields.many2one('account.period', 'Force period'),
+       'journal_id': fields.many2one('account.journal', 'Refund Journal', help='You can select here the journal to use for the refund invoice that will be created. If you leave that field empty, it will use the same journal as the current invoice.'),
+       'description': fields.char('Description', size=128, required=True),
+       'comment': fields.text('Comment', required=True),
+    }
+
+    def _get_journal(self, cr, uid, context=None):
+        obj_journal = self.pool.get('account.journal')
+        if context is None:
+            context = {}
+        journal = obj_journal.search(cr, uid, [('type', '=', 'sale')])
+        if context.get('type', False):
+            if context['type'] in ('in_invoice', 'in_refund'):
+                journal = obj_journal.search(cr, uid, [('type', '=', 'purchase')])
+        return journal and journal[0] or False
+
+    _defaults = {
+        'date': lambda *a: time.strftime('%Y-%m-%d'),
+        'journal_id': _get_journal,
+        'filter_refund': 'modify',
+    }
+
+    def fields_view_get(self, cr, uid, view_id=None, view_type=False, context=None, toolbar=False, submenu=False):
+        journal_obj = self.pool.get('account.journal')
+        res = super(account_invoice_debit,self).fields_view_get(cr, uid, view_id=view_id, view_type=view_type, context=context, toolbar=toolbar, submenu=submenu)
+        #Debit note only from customer o purchase invoice
+        #type = context.get('journal_type', 'sale_refund')
+        type = context.get('journal_type', 'sale')
+        if type in ('sale', 'sale_refund'):
+            type = 'sale'
+        else:
+            type = 'purchase'
+        for field in res['fields']:
+            if field == 'journal_id':
+                journal_select = journal_obj._name_search(cr, uid, '', [('type', '=', type)], context=context, limit=None, name_get_uid=1)
+                res['fields'][field]['selection'] = journal_select
+        return res
+
+    def _get_period(self, cr, uid, context={}):
+        """
+        Return  default account period value
+        """
+        account_period_obj = self.pool.get('account.period')
+        ids = account_period_obj.find(cr, uid, context=context)
+        period_id = False
+        if ids:
+            period_id = ids[0]
+        return period_id
+
+    def _get_orig(self, cr, uid, inv, ref, context={}):
+        """
+        Return  default origin value
+        """
+        nro_ref = ref
+        if inv.type == 'out_invoice':
+            nro_ref = inv.number
+        orig = 'FACT:' +(nro_ref or '') + '- DE FECHA:' + (inv.date_invoice or '') + (' TOTAL:' + str(inv.amount_total) or '')
+        return orig
+
+    def compute_debit(self, cr, uid, ids, context=None):
+        """
+        @param cr: the current row, from the database cursor,
+        @param uid: the current user’s ID for security checks,
+        @param ids: the account invoice refund’s ID or list of IDs
+
+        """
+        inv_obj = self.pool.get('account.invoice')
+        reconcile_obj = self.pool.get('account.move.reconcile')
+        account_m_line_obj = self.pool.get('account.move.line')
+        mod_obj = self.pool.get('ir.model.data')
+        act_obj = self.pool.get('ir.actions.act_window')
+        wf_service = netsvc.LocalService('workflow')
+        inv_tax_obj = self.pool.get('account.invoice.tax')
+        inv_line_obj = self.pool.get('account.invoice.line')
+        res_users_obj = self.pool.get('res.users')
+        if context is None:
+            context = {}
+
+        for form in  self.read(cr, uid, ids, context=context):
+            created_inv = []
+            date = False
+            period = False
+            description = False
+            company = res_users_obj.browse(cr, uid, uid, context=context).company_id
+            journal_id = form.get('journal_id', False)
+            for inv in inv_obj.browse(cr, uid, context.get('active_ids'), context=context):
+                if inv.state in ['draft', 'proforma2', 'cancel']:
+                    raise osv.except_osv(_('Error !'), _('Can not create a debit note from draft/proforma/cancel invoice.'))
+                if inv.reconciled and mode in ('cancel', 'modify'):
+                    raise osv.except_osv(_('Error !'), _('Can not create a debit note from invoice which is already reconciled, invoice should be unreconciled first. You can only Refund or Debit this invoice'))
+                if inv.type not in ['in_invoice', 'out_invoice']:
+                    raise osv.except_osv(_('Error !'), _('Can not make a debit note on a refund invoice.'))
+                if form['period']:
+                    period = form['period']
+                else:
+                    #Take period from the current date
+                    #period = inv.period_id and inv.period_id.id or False
+                    period = self._get_period(cr, uid, context)
+
+                if not journal_id:
+                    journal_id = inv.journal_id.id
+
+                if form['date']:
+                    date = form['date']
+                    if not form['period']:
+                            cr.execute("select name from ir_model_fields \
+                                            where model = 'account.period' \
+                                            and name = 'company_id'")
+                            result_query = cr.fetchone()
+                            if result_query:
+                                #in multi company mode
+                                cr.execute("""select p.id from account_fiscalyear y, account_period p where y.id=p.fiscalyear_id \
+                                    and date(%s) between p.date_start AND p.date_stop and y.company_id = %s limit 1""", (date, company.id,))
+                            else:
+                                #in mono company mode
+                                cr.execute("""SELECT id
+                                        from account_period where date(%s)
+                                        between date_start AND  date_stop  \
+                                        limit 1 """, (date,))
+                            res = cr.fetchone()
+                            if res:
+                                period = res[0]
+                else:
+                    #Take current date
+                    #date = inv.date_invoice
+                    date = time.strftime('%Y-%m-%d')
+                if form['description']:
+                    description = form['description']
+                else:
+                    description = inv.name
+
+                if not period:
+                    raise osv.except_osv(_('Data Insufficient !'), \
+                                            _('No Period found on Invoice!'))
+
+                #we get original data of invoice to create a new invoice that is the copy of the original
+                invoice = inv_obj.read(cr, uid, [inv.id],
+                            ['name', 'type', 'number', 'reference',
+                            'comment', 'date_due', 'partner_id',
+                            'address_contact_id', 'address_invoice_id',
+                            'partner_insite', 'partner_contact',
+                            'partner_ref', 'payment_term', 'account_id',
+                            'currency_id', 'invoice_line', 'tax_line',
+                            'journal_id', 'period_id'], context=context)
+                invoice = invoice[0]
+                del invoice['id']
+                invoice_lines = []
+                tax_lines = []
+                #Add origin, parent and comment values
+                orig = self._get_orig(cr, uid, inv, invoice['reference'], context)
+                invoice.update({
+                    'type': inv.type,
+                    'date_invoice': date,
+                    'state': 'draft',
+                    'number': False,
+                    'invoice_line': invoice_lines,
+                    'tax_line': tax_lines,
+                    'period_id': period,
+                    'parent_id':inv.id,
+                    'name': description,
+                    'origin': orig,
+                    'comment':form['comment']
+                })
+                #take the id part of the tuple returned for many2one fields
+                for field in ('address_contact_id', 'address_invoice_id', 'partner_id',
+                        'account_id', 'currency_id', 'payment_term', 'journal_id'):
+                        invoice[field] = invoice[field] and invoice[field][0]
+                # create the new invoice
+                inv_id = inv_obj.create(cr, uid, invoice, {})
+                # we compute due date
+                if inv.payment_term.id:
+                    data = inv_obj.onchange_payment_term_date_invoice(cr, uid, [inv_id], inv.payment_term.id, date)
+                    if 'value' in data and data['value']:
+                        inv_obj.write(cr, uid, [inv_id], data['value'])
+                created_inv.append(inv_id)
+            #we get the view id
+            if inv.type in ('out_invoice', 'out_refund'):
+                xml_id = 'action_invoice_tree1'
+            else:
+                xml_id = 'action_invoice_tree2'
+            #we get the model
+            result = mod_obj.get_object_reference(cr, uid, 'account', xml_id)
+            id = result and result[1] or False
+            # we read the act window
+            result = act_obj.read(cr, uid, id, context=context)
+            # we add the new invoices into domain list
+            invoice_domain = eval(result['domain'])
+            invoice_domain.append(('id', 'in', created_inv))
+            result['domain'] = invoice_domain
+            return result
+
+    def invoice_debit(self, cr, uid, ids, context=None):
+        return self.compute_debit(cr, uid, ids, context=context)
+
+
+account_invoice_debit()
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'debit_credit_note/wizard/account_invoice_debit_view.xml'
--- debit_credit_note/wizard/account_invoice_debit_view.xml	1970-01-01 00:00:00 +0000
+++ debit_credit_note/wizard/account_invoice_debit_view.xml	2011-11-02 16:10:43 +0000
@@ -0,0 +1,43 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+
+        <record id="view_account_invoice_debit" model="ir.ui.view">
+            <field name="name">account.invoice.debit.form</field>
+            <field name="model">account.invoice.debit</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Debit Note">
+                    <separator string="Debit Note Options" colspan="4"/>
+                    <group colspan="4" >
+                         <field name="description"/>
+                         <field name="journal_id" widget='selection'/>
+                         <field name="date"/>
+                         <field name="period"/>
+                         <field name="comment" colspan="4"/>
+                    </group>
+                    <separator colspan="4"/>
+                    <group col="4" colspan="4" fill="1">
+                        <label align="0.0" width="300" string="Debit Invoice: Creates the debit note invoice, ready for editing."/>
+                    </group>
+                    <separator colspan="4"/>
+                    <group colspan="4" col="6">
+                        <button icon="gtk-cancel" special="cancel" string="Cancel"/>
+                        <button string='Debit Note' icon="gtk-execute" name="invoice_debit" type="object"/>
+                   </group>
+               </form>
+            </field>
+        </record>
+
+        <record id="action_account_invoice_debit" model="ir.actions.act_window">
+            <field name="name">Debit Note</field>
+            <field name="res_model">account.invoice.debit</field>
+            <field name="view_type">form</field>
+            <field name="view_mode">tree,form</field>
+           <field name="view_id" ref="view_account_invoice_debit"/>
+           <field name="target">new</field>
+        </record>
+
+
+    </data>
+</openerp>

=== added file 'debit_credit_note/wizard/account_invoice_refund.py'
--- debit_credit_note/wizard/account_invoice_refund.py	1970-01-01 00:00:00 +0000
+++ debit_credit_note/wizard/account_invoice_refund.py	2011-11-02 16:10:43 +0000
@@ -0,0 +1,235 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+import time
+
+from osv import fields, osv
+from tools.translate import _
+import netsvc
+
+class account_invoice_refund(osv.osv_memory):
+
+    """Refunds invoice"""
+    _inherit = 'account.invoice.refund'
+
+    def _get_journal(self, cr, uid, context=None):
+        obj_journal = self.pool.get('account.journal')
+        if context is None:
+            context = {}
+        journal = obj_journal.search(cr, uid, [('type', '=', 'sale_refund')])
+        if context.get('type', False):
+            if context['type'] in ('in_invoice', 'in_refund'):
+                journal = obj_journal.search(cr, uid, [('type', '=', 'purchase_refund')])
+        return journal and journal[0] or False
+
+
+    def fields_view_get(self, cr, uid, view_id=None, view_type=False, context=None, toolbar=False, submenu=False):
+        journal_obj = self.pool.get('account.journal')
+        res = super(account_invoice_refund,self).fields_view_get(cr, uid, view_id=view_id, view_type=view_type, context=context, toolbar=toolbar, submenu=submenu)
+        type = context.get('journal_type', 'sale_refund')
+        if type in ('sale', 'sale_refund'):
+            type = 'sale_refund'
+        else:
+            type = 'purchase_refund'
+        for field in res['fields']:
+            if field == 'journal_id':
+                journal_select = journal_obj._name_search(cr, uid, '', [('type', '=', type)], context=context, limit=None, name_get_uid=1)
+                res['fields'][field]['selection'] = journal_select
+        return res
+
+    def _get_period(self, cr, uid, context={}):
+        """
+        Return  default account period value
+        """
+        account_period_obj = self.pool.get('account.period')
+        ids = account_period_obj.find(cr, uid, context=context)
+        period_id = False
+        if ids:
+            period_id = ids[0]
+        return period_id
+
+    def _get_orig(self, cr, uid, inv, ref, context={}):
+        """
+        Return  default origin value
+        """
+        nro_ref = ref
+        if inv.type == 'out_invoice':
+            nro_ref = inv.number
+        orig = 'Devolucion FACT:' +(nro_ref or '') + '- DE FECHA:' + (inv.date_invoice or '') + (' TOTAL:' + str(inv.amount_total) or '')
+        return orig
+
+    def compute_refund(self, cr, uid, ids, mode='refund', context=None):
+        """
+        @param cr: the current row, from the database cursor,
+        @param uid: the current user’s ID for security checks,
+        @param ids: the account invoice refund’s ID or list of IDs
+
+        """
+        inv_obj = self.pool.get('account.invoice')
+        reconcile_obj = self.pool.get('account.move.reconcile')
+        account_m_line_obj = self.pool.get('account.move.line')
+        mod_obj = self.pool.get('ir.model.data')
+        act_obj = self.pool.get('ir.actions.act_window')
+        wf_service = netsvc.LocalService('workflow')
+        inv_tax_obj = self.pool.get('account.invoice.tax')
+        inv_line_obj = self.pool.get('account.invoice.line')
+        res_users_obj = self.pool.get('res.users')
+        if context is None:
+            context = {}
+
+        for form in  self.read(cr, uid, ids, context=context):
+            created_inv = []
+            date = False
+            period = False
+            description = False
+            company = res_users_obj.browse(cr, uid, uid, context=context).company_id
+            journal_id = form.get('journal_id', False)
+            for inv in inv_obj.browse(cr, uid, context.get('active_ids'), context=context):
+                if inv.state in ['draft', 'proforma2', 'cancel']:
+                    raise osv.except_osv(_('Error !'), _('Can not %s draft/proforma/cancel invoice.') % (mode))
+                if inv.reconciled and mode in ('cancel', 'modify'):
+                    raise osv.except_osv(_('Error !'), _('Can not %s invoice which is already reconciled, invoice should be unreconciled first. You can only Refund this invoice') % (mode))
+                if form['period']:
+                    period = form['period']
+                else:
+                    #Take period from the current date
+                    #period = inv.period_id and inv.period_id.id or False
+                    period = self._get_period(cr, uid, context)
+
+                if not journal_id:
+                    journal_id = inv.journal_id.id
+
+                if form['date']:
+                    date = form['date']
+                    if not form['period']:
+                            cr.execute("select name from ir_model_fields \
+                                            where model = 'account.period' \
+                                            and name = 'company_id'")
+                            result_query = cr.fetchone()
+                            if result_query:
+                                cr.execute("""select p.id from account_fiscalyear y, account_period p where y.id=p.fiscalyear_id \
+                                    and date(%s) between p.date_start AND p.date_stop and y.company_id = %s limit 1""", (date, company.id,))
+                            else:
+                                cr.execute("""SELECT id
+                                        from account_period where date(%s)
+                                        between date_start AND  date_stop  \
+                                        limit 1 """, (date,))
+                            res = cr.fetchone()
+                            if res:
+                                period = res[0]
+                else:
+                    #Take current date
+                    #date = inv.date_invoice
+                    date = time.strftime('%Y-%m-%d')
+                if form['description']:
+                    description = form['description']
+                else:
+                    description = inv.name
+
+                if not period:
+                    raise osv.except_osv(_('Data Insufficient !'), \
+                                            _('No Period found on Invoice!'))
+
+                refund_id = inv_obj.refund(cr, uid, [inv.id], date, period, description, journal_id)
+                refund = inv_obj.browse(cr, uid, refund_id[0], context=context)
+                #Add parent invoice
+                inv_obj.write(cr, uid, [refund.id], {'date_due': date,
+                                                'check_total': inv.check_total,'parent_id':inv.id})
+                inv_obj.button_compute(cr, uid, refund_id)
+
+                created_inv.append(refund_id[0])
+                if mode in ('cancel', 'modify'):
+                    movelines = inv.move_id.line_id
+                    to_reconcile_ids = {}
+                    for line in movelines:
+                        if line.account_id.id == inv.account_id.id:
+                            to_reconcile_ids[line.account_id.id] = [line.id]
+                        if type(line.reconcile_id) != osv.orm.browse_null:
+                            reconcile_obj.unlink(cr, uid, line.reconcile_id.id)
+                    wf_service.trg_validate(uid, 'account.invoice', \
+                                        refund.id, 'invoice_open', cr)
+                    refund = inv_obj.browse(cr, uid, refund_id[0], context=context)
+                    for tmpline in  refund.move_id.line_id:
+                        if tmpline.account_id.id == inv.account_id.id:
+                            to_reconcile_ids[tmpline.account_id.id].append(tmpline.id)
+                    for account in to_reconcile_ids:
+                        account_m_line_obj.reconcile(cr, uid, to_reconcile_ids[account],
+                                        writeoff_period_id=period,
+                                        writeoff_journal_id = inv.journal_id.id,
+                                        writeoff_acc_id=inv.account_id.id
+                                        )
+                    if mode == 'modify':
+                        invoice = inv_obj.read(cr, uid, [inv.id],
+                                    ['name', 'type', 'number', 'reference',
+                                    'comment', 'date_due', 'partner_id',
+                                    'address_contact_id', 'address_invoice_id',
+                                    'partner_insite', 'partner_contact',
+                                    'partner_ref', 'payment_term', 'account_id',
+                                    'currency_id', 'invoice_line', 'tax_line',
+                                    'journal_id', 'period_id'], context=context)
+                        invoice = invoice[0]
+                        del invoice['id']
+                        invoice_lines = inv_line_obj.read(cr, uid, invoice['invoice_line'], context=context)
+                        invoice_lines = inv_obj._refund_cleanup_lines(cr, uid, invoice_lines)
+                        tax_lines = inv_tax_obj.read(cr, uid, invoice['tax_line'], context=context)
+                        tax_lines = inv_obj._refund_cleanup_lines(cr, uid, tax_lines)
+                        #Add origin value
+                        orig = self._get_orig(cr, uid, inv, invoice['reference'], context)
+                        invoice.update({
+                            'type': inv.type,
+                            'date_invoice': date,
+                            'state': 'draft',
+                            'number': False,
+                            'invoice_line': invoice_lines,
+                            'tax_line': tax_lines,
+                            'period_id': period,
+                            'name': description,
+                            'origin': orig,
+                        })
+                        for field in ('address_contact_id', 'address_invoice_id', 'partner_id',
+                                'account_id', 'currency_id', 'payment_term', 'journal_id'):
+                                invoice[field] = invoice[field] and invoice[field][0]
+                        inv_id = inv_obj.create(cr, uid, invoice, {})
+                        if inv.payment_term.id:
+                            data = inv_obj.onchange_payment_term_date_invoice(cr, uid, [inv_id], inv.payment_term.id, date)
+                            if 'value' in data and data['value']:
+                                inv_obj.write(cr, uid, [inv_id], data['value'])
+                        created_inv.append(inv_id)
+            if inv.type in ('out_invoice', 'out_refund'):
+                xml_id = 'action_invoice_tree3'
+            else:
+                xml_id = 'action_invoice_tree4'
+            result = mod_obj.get_object_reference(cr, uid, 'account', xml_id)
+            id = result and result[1] or False
+            result = act_obj.read(cr, uid, id, context=context)
+            invoice_domain = eval(result['domain'])
+            invoice_domain.append(('id', 'in', created_inv))
+            result['domain'] = invoice_domain
+            return result
+
+    def invoice_refund(self, cr, uid, ids, context=None):
+        data_refund = self.read(cr, uid, ids, [],context=context)[0]['filter_refund']
+        return self.compute_refund(cr, uid, ids, data_refund, context=context)
+
+
+account_invoice_refund()
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: