Merge lp:~vauxoo/openerp-venezuela-localization/gaby-merge-debit-credit-fiscal-requirements into lp:~openerp-venezuela/openerp-venezuela-localization/6.0-trunk

[Gabriela Quilarque]

Merge debit_credit_note to l10n_ve_fiscal_requirements:

Improvements:
-Translations.
-Security.
-Update invoice view.
-Update description in __openerp__.py.
-Merge modules.

[lp:~vauxoo/openerp-venezuela-localization/gaby-merge-debit-credit-fiscal-requirements]

472. By Gabriela Quilarque on 2011-11-03

[MERGE] Merge from lp:~vauxoo/openerp-venezuela-localization/gaby-merge-debit-credit-fiscal-requirements

=== modified file 'l10n_ve_fiscal_requirements/__init__.py'
--- l10n_ve_fiscal_requirements/__init__.py	2011-10-25 20:33:16 +0000
+++ l10n_ve_fiscal_requirements/__init__.py	2011-11-03 23:12:26 +0000
@@ -29,4 +29,5 @@
 import seniat_url
 import l10n_ut
 import wizard
+
 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== modified file 'l10n_ve_fiscal_requirements/__openerp__.py'
--- l10n_ve_fiscal_requirements/__openerp__.py	2011-11-03 19:22:42 +0000
+++ l10n_ve_fiscal_requirements/__openerp__.py	2011-11-03 23:12:26 +0000
@@ -38,9 +38,16 @@
 Automatically on install wizard.
     - Damaged "Legal free forms" declaration.
     - Tax Units configuration.
+<<<<<<< TREE
     - When a partner is updated by using the SENIAT Update Button, its name changes to
       readonly to avoid manual changes.
     ---------------------------------------------------------------------------
+=======
+    - Added field Parent in the invoice of customers and suppliers, for link the invoice 
+    that generated debit or credit note.
+    --Added wizard for generate debit note from invoice and done accounting entry.
+    -------------------------------------------------------------------------------------------
+>>>>>>> MERGE-SOURCE
     For damaged invoices (Free form formats), you must go to the company and, under the configuration section,
     create the corresponding journal and account.
     TODO : Include this on wizard configuration.
@@ -69,6 +76,8 @@
         'wizard/wizard_nro_ctrl_view.xml',
         'wizard/wizard_url_seniat_view.xml',
         'wizard/update_info_partner.xml',
+        'wizard/account_invoice_debit_view.xml',
+        'account_invoice_view.xml',
     ],
     'demo_xml': [
         'demo/demo_partners.xml',

=== added file 'l10n_ve_fiscal_requirements/account_invoice_view.xml'
--- l10n_ve_fiscal_requirements/account_invoice_view.xml	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_requirements/account_invoice_view.xml	2011-11-03 23:12:26 +0000
@@ -0,0 +1,92 @@
+<?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/group" position="after">
+                    <newline/>
+                    <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/group" position="after">
+                    <newline/>
+                    <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>

=== modified file 'l10n_ve_fiscal_requirements/i18n/es_VE.po'
--- l10n_ve_fiscal_requirements/i18n/es_VE.po	2011-11-02 13:13:38 +0000
+++ l10n_ve_fiscal_requirements/i18n/es_VE.po	2011-11-03 23:12:26 +0000
@@ -390,3 +390,115 @@
 msgid "Date on which goes into effect the new Unit Tax Unit"
 msgstr "Fecha en la cual entra en vigencia la nueva Unidad Tributaria"
 
+#. module: l10n_ve_fiscal_requirements
+#: code:addons/l10n_ve_fiscal_requirements/wizard/account_invoice_debit.py:125
+#, python-format
+msgid "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"
+msgstr "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"
+
+#. module: l10n_ve_fiscal_requirements
+#: view:account.invoice:0
+#: view:account.invoice.debit:0
+#: model:ir.actions.act_window,name:l10n_ve_fiscal_requirements.action_account_invoice_debit
+msgid "Debit Note"
+msgstr "Nota de Debito"
+
+#. module: l10n_ve_fiscal_requirements
+#: field:account.invoice,child_ids:0
+msgid "Debit and Credit Notes"
+msgstr "Notas de Débito/Crédito"
+
+#. module: l10n_ve_fiscal_requirements
+#: view:account.invoice.debit:0
+msgid "Debit Invoice: Creates the debit note invoice, ready for editing."
+msgstr "Nota de Débito: Crea la nota de dédito lista para ser editada."
+
+#. module: l10n_ve_fiscal_requirements
+#: view:account.invoice.debit:0
+msgid "Debit Note Options"
+msgstr "Opciones Nota de Débito"
+
+#. module: l10n_ve_fiscal_requirements
+#: field:account.invoice.debit,comment:0
+msgid "Comment"
+msgstr "Comentario"
+
+#. module: l10n_ve_fiscal_requirements
+#: code:addons/l10n_ve_fiscal_requirements/wizard/account_invoice_refund.py:109
+#, python-format
+msgid "Can not %s invoice which is already reconciled, invoice should be unreconciled first. You can only Refund this invoice"
+msgstr "Imposible generar una nota de crédito cuando la factura %s ya esta conciliada, primero debes realizar la desconciliación."
+
+#. module: l10n_ve_fiscal_requirements
+#: model:ir.model,name:l10n_ve_fiscal_requirements.model_account_invoice_debit
+msgid "Invoice Debit Note"
+msgstr "Nota de Débito"
+
+#. module: l10n_ve_fiscal_requirements
+#: code:addons/l10n_ve_fiscal_requirements/wizard/account_invoice_debit.py:123
+#, python-format
+msgid "Can not create a debit note from draft/proforma/cancel invoice."
+msgstr "Imposible crear nota de débito desde draft/proforma/cancel invoice."
+
+#. module: l10n_ve_fiscal_requirements
+#: help:account.invoice.debit,journal_id:0
+msgid "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."
+msgstr "Puedes seleccionar un diario para la nota de débito que será creada. Si dejas este campo vacio, se usará el diario de la factura actual."
+
+#. module: l10n_ve_fiscal_requirements
+#: code:addons/l10n_ve_fiscal_requirements/wizard/account_invoice_debit.py:168
+#: code:addons/l10n_ve_fiscal_requirements/wizard/account_invoice_refund.py:148
+#, python-format
+msgid "Data Insufficient !"
+msgstr "Datos Insuficientes !"
+
+#. module: l10n_ve_fiscal_requirements
+#: field:account.invoice.debit,description:0
+msgid "Description"
+msgstr "Descripción"
+
+#. module: l10n_ve_fiscal_requirements
+#: help:account.invoice.debit,date:0
+msgid "This date will be used as the invoice date for Refund Invoice and Period will be chosen accordingly!"
+msgstr "Puedes definir la fecha que tendrá la Nota de Débito."
+
+#. module: l10n_ve_fiscal_requirements
+#: model:ir.model,name:l10n_ve_fiscal_requirements.model_account_invoice_refund
+msgid "Invoice Refund"
+msgstr "Nota de Crédito"
+
+#. module: l10n_ve_fiscal_requirements
+#: view:account.invoice:0
+msgid "Debit-Credit Notes"
+msgstr "Notas de Débito/Crédito"
+
+#. module: l10n_ve_fiscal_requirements
+#: help:account.invoice,parent_id:0
+msgid "When this field has information, this invoice is a credit note or debit note. This field is used to reference to the invoice that originated this credit note or debit note."
+msgstr "Cuando este campo contiene información, estamos en presencia de una Nota de Crédito o Débito. Es usado para referenciar a la factura desde donde se originó la Nota de Crédito o Débito."
+
+#. module: l10n_ve_fiscal_requirements
+#: code:addons/l10n_ve_fiscal_requirements/wizard/account_invoice_debit.py:127
+#, python-format
+msgid "Can not make a debit note on a refund invoice."
+msgstr "No puedes crear una nota de débito o credito."
+
+#. module: l10n_ve_fiscal_requirements
+#: field:account.invoice,parent_id:0
+msgid "Parent Invoice"
+msgstr "Factura Origen"
+
+#. module: l10n_ve_fiscal_requirements
+#: field:account.invoice.debit,date:0
+msgid "Operation date"
+msgstr "Fecha operación"
+
+#. module: l10n_ve_fiscal_requirements
+#: field:account.invoice.debit,journal_id:0
+msgid "Refund Journal"
+msgstr "Diario Reembolso"
+
+#. module: l10n_ve_fiscal_requirements
+#: field:account.invoice.debit,period:0
+msgid "Force period"
+msgstr "Periodo"

=== modified file 'l10n_ve_fiscal_requirements/invoice.py'
--- l10n_ve_fiscal_requirements/invoice.py	2011-10-25 20:33:16 +0000
+++ l10n_ve_fiscal_requirements/invoice.py	2011-11-03 23:12:26 +0000
@@ -31,6 +31,8 @@
     _columns = {
         'nro_ctrl': fields.char('Control Number', size=32, readonly=True, states={'draft':[('readonly',False)]}, help="Code used for intern invoice control"),
         'sin_cred': fields.boolean('Tax-exempt?', readonly=False, help="Set it true if the invoice is V.A.T. exempt"),
+        'parent_id':fields.many2one('account.invoice', 'Parent Invoice', readonly=True, states={'draft':[('readonly',False)]}, help='When this field has information, this invoice is a credit note or debit note. This field is used to reference to the invoice that originated this credit note or debit note.'),
+        'child_ids':fields.one2many('account.invoice', 'parent_id', 'Debit and Credit Notes', readonly=True, states={'draft':[('readonly',False)]}),
     }
 account_invoice()
 

=== modified file 'l10n_ve_fiscal_requirements/security/ir.model.access.csv'
--- l10n_ve_fiscal_requirements/security/ir.model.access.csv	2011-10-29 15:51:25 +0000
+++ l10n_ve_fiscal_requirements/security/ir.model.access.csv	2011-11-03 23:12:26 +0000
@@ -4,3 +4,4 @@
 "access_account_seniat_url_3","seniat.url","model_seniat_url","account.group_account_manager",1,1,1,1
 "access_account_seniat_url_4","seniat.url","model_seniat_url","base.group_erp_manager",1,1,1,1
 "access_account_seniat_url_5","seniat.url","model_seniat_url","base.group_partner_manager",1,0,0,0
+"access_account_invoice_debit_6","account.invoice.debit","model_account_invoice_debit","base.group_partner_manager",1,0,0,0

=== modified file 'l10n_ve_fiscal_requirements/wizard/__init__.py'
--- l10n_ve_fiscal_requirements/wizard/__init__.py	2011-10-25 20:33:16 +0000
+++ l10n_ve_fiscal_requirements/wizard/__init__.py	2011-11-03 23:12:26 +0000
@@ -27,3 +27,5 @@
 import wizard_invoice_nro_ctrl
 import wizard_url_seniat
 import update_info_partner
+import account_invoice_refund
+import account_invoice_debit

=== added file 'l10n_ve_fiscal_requirements/wizard/account_invoice_debit.py'
--- l10n_ve_fiscal_requirements/wizard/account_invoice_debit.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_requirements/wizard/account_invoice_debit.py	2011-11-03 23:12:26 +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 'l10n_ve_fiscal_requirements/wizard/account_invoice_debit_view.xml'
--- l10n_ve_fiscal_requirements/wizard/account_invoice_debit_view.xml	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_requirements/wizard/account_invoice_debit_view.xml	2011-11-03 23:12:26 +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 'l10n_ve_fiscal_requirements/wizard/account_invoice_refund.py'
--- l10n_ve_fiscal_requirements/wizard/account_invoice_refund.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_requirements/wizard/account_invoice_refund.py	2011-11-03 23:12:26 +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: