Merge lp:~vauxoo/addons-vauxoo/7.0-avts-dev-julio into lp:addons-vauxoo/7.0

[Julio Serna-http://www.vauxoo.com]

Crea modulo de pago al sat de las retenciones de iva y cancelación de los impuestos con retencion

[Moisés López - http://www.vauxoo.com (moylop260)]

review: Approve

[lp:~vauxoo/addons-vauxoo/7.0-avts-dev-julio]

886. By Julio Serna-http://www.vauxoo.com on 2013-10-22

[IMP]revert change in aml of iva in vovuher tax

[hbto [Vauxoo] http://www.vauxoo.com (humbertoarocha)]

Buenas noches,

No he probado el código,

sin embargo, podría indicar

que sería mas favorable,

indicar un period_id cuyo special=False, para buscar los aml,
que se estarían filtrando,

un la búsqueda del periodo de la fecha de Contabilizacion,
colocaría tambien un filtro special=False para evitar usar los
periodos espaciales.

Saludos.

[lp:~vauxoo/addons-vauxoo/7.0-avts-dev-julio]

887. By Julio Serna-http://www.vauxoo.com on 2013-10-24

[MERGE] merge addons-vauxoo/7.0

888. By Julio Serna-http://www.vauxoo.com on 2013-10-24

[IMP]added onchanged in field period to reomve aml

889. By Julio Serna-http://www.vauxoo.com on 2013-10-24

[IMP] get period in wizard from model of sat

890. By Julio Serna-http://www.vauxoo.com on 2013-10-24

[IMP]added domain in partner_id is sat

891. By Julio Serna-http://www.vauxoo.com on 2013-10-25

[IMP] create state in module

892. By Julio Serna-http://www.vauxoo.com on 2013-10-25

[IMP]added function that validate aml not repeat

893. By Julio Serna-http://www.vauxoo.com on 2013-10-25

[MERGE] merge addons-vauxoo/7.0

=== modified file 'account_update_amount_tax_in_move_lines/wizard/update_amount_base_tax_wizard.py'
--- account_update_amount_tax_in_move_lines/wizard/update_amount_base_tax_wizard.py	2013-10-23 00:25:14 +0000
+++ account_update_amount_tax_in_move_lines/wizard/update_amount_base_tax_wizard.py	2013-10-25 22:36:34 +0000
@@ -98,7 +98,7 @@
             attrs.append(('amount_base', '=', False))
         lines_without_amount = move_line_obj.search(cr, uid, attrs, context=context)
         for move in move_line_obj.browse(cr, uid, lines_without_amount, context=context):
-            amount_tax = move.tax_id_secondary.amount
+            amount_tax = move.tax_id_secondary.tax_category_id.value_tax or move.tax_id_secondary.amount
             amount_base = 0
             if move.debit != 0:
                 amount_base = move.debit

=== added directory 'account_voucher_tax_sat'
=== added file 'account_voucher_tax_sat/__init__.py'
--- account_voucher_tax_sat/__init__.py	1970-01-01 00:00:00 +0000
+++ account_voucher_tax_sat/__init__.py	2013-10-25 22:36:34 +0000
@@ -0,0 +1,26 @@
+#!/usr/bin/python
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#    Copyright (C) Vauxoo (<http://vauxoo.com>).
+#    All Rights Reserved
+###############Credits######################################################
+#    Coded by: Julio Cesar Serna Hernandez([e-mail])
+#############################################################################
+#    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 model
+import wizard
\ No newline at end of file

=== added file 'account_voucher_tax_sat/__openerp__.py'
--- account_voucher_tax_sat/__openerp__.py	1970-01-01 00:00:00 +0000
+++ account_voucher_tax_sat/__openerp__.py	2013-10-25 22:36:34 +0000
@@ -0,0 +1,53 @@
+#!/usr/bin/python
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#    Copyright (C) Vauxoo (<http://vauxoo.com>).
+#    All Rights Reserved
+###############Credits######################################################
+#    Coded by: Julio Cesar Serna Hernandez([e-mail])
+#############################################################################
+#    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/>.
+################################################################################
+{
+    "name": "Account Voucher Tax SAT",
+    "version": "1.0",
+    "author" : "Vauxoo",
+    "category": "Accounting",
+    "website" : "http://www.vauxoo.com/",
+    "description": """ 
+Polizas de SAT:
+===============
+
+1.- Crea los apuntes contables para los impuestos con retenciones
+2.- Crea provicion de pago al SAT
+3.- Crea apuntes contables para las retenciones de IVA
+    """,
+    'depends': [
+        'account',
+        'account_voucher_tax'
+        ],
+    'data': [
+        'security/security.xml',
+        'security/ir.model.access.csv',
+        'wizard/account_tax_sat_view.xml',
+        'view/account_voucher_tax_sat_view.xml',
+        'view/partner_view.xml',
+        ],
+    'demo': [],
+    'test': [],
+    'installable': True,
+    'active': False,
+}
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added directory 'account_voucher_tax_sat/model'
=== added file 'account_voucher_tax_sat/model/__init__.py'
--- account_voucher_tax_sat/model/__init__.py	1970-01-01 00:00:00 +0000
+++ account_voucher_tax_sat/model/__init__.py	2013-10-25 22:36:34 +0000
@@ -0,0 +1,25 @@
+#!/usr/bin/python
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#    Copyright (C) Vauxoo (<http://vauxoo.com>).
+#    All Rights Reserved
+###############Credits######################################################
+#    Coded by: Julio Cesar Serna Hernandez([e-mail])
+#############################################################################
+#    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 account_voucher_tax_sat
+import partner
\ No newline at end of file

=== added file 'account_voucher_tax_sat/model/account_voucher_tax_sat.py'
--- account_voucher_tax_sat/model/account_voucher_tax_sat.py	1970-01-01 00:00:00 +0000
+++ account_voucher_tax_sat/model/account_voucher_tax_sat.py	2013-10-25 22:36:34 +0000
@@ -0,0 +1,268 @@
+#!/usr/bin/python
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#    Copyright (C) Vauxoo (<http://vauxoo.com>).
+#    All Rights Reserved
+###############Credits######################################################
+#    Coded by: Julio Cesar Serna Hernandez([e-mail])
+#############################################################################
+#    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 openerp.osv import fields, osv
+from openerp import netsvc
+import openerp.addons.decimal_precision as dp
+from openerp.tools.translate import _
+
+
+class account_voucher_tax_sat(osv.Model):
+    
+    _name = 'account.voucher.tax.sat'
+    
+    _columns = {
+        'name': fields.char('Name', size=128,
+                            help='Name of This Document',
+                            ),
+        'partner_id': fields.many2one('res.partner', 'Partner',
+                            domain = "[('sat', '=', True)]",
+                            help='Partner of SAT',
+                            ),
+        'date': fields.date('Accounting Date',
+                            help='Accounting date affected',
+                            ),
+        'aml_ids': fields.many2many('account.move.line', 'voucher_tax_sat_rel',
+                            'voucher_tax_sat_id', 'move_line_id',
+                            'Move Lines', help='Entries to close',
+                            ),
+        'journal_id':fields.many2one('account.journal', 'Journal',
+                            help='Accounting Journal where Entries will be posted',
+                            ), 
+        'move_id': fields.many2one('account.move', 'Journal Entry',
+                            help='Accounting Entry'),
+        'company_id':fields.many2one('res.company', 'Company', help='Company'), 
+        'period_id': fields.many2one('account.period', 'Period', required=True,
+                            help='Period of Entries to find',
+                            ),
+        'state': fields.selection([
+            ('draft', 'New'),
+            ('cancelled', 'Cancelled'),
+            ('done', 'Done')],
+            'Status', readonly=True, track_visibility='onchange'),
+    }
+    _defaults = {
+        'company_id': lambda s, c, u, cx: s.pool.get('res.users').browse(c, u,
+            u, cx).company_id.id,
+        'state': 'draft'
+    }
+    
+    def onchange_period(self, cr, uid, ids, period, context=None):
+        res = {}
+        if period:
+            res['value'] = {'aml_ids': []}
+        return res
+
+    def validate_move_line(self, cr, uid, voucher_tax, context=None):
+        move_line_obj = self.pool.get('account.move.line')
+        cr.execute(""" SELECT DISTINCT move_line_id FROM voucher_tax_sat_rel
+                        WHERE voucher_tax_sat_id <> %s
+                        AND move_line_id IN %s """,(
+                            voucher_tax.id,
+                            tuple([ move_lines.id\
+                                    for move_lines in voucher_tax.aml_ids ]))
+                    )
+        dat = cr.dictfetchall()
+        move_line_tax = list( set([ move_tax['move_line_id'] for move_tax in dat ]) )
+        if dat:
+            raise osv.except_osv(_('Warning'),
+                _("You have this jornal items in other voucher tax sat '%s' ")
+                % ([ move_line.name\
+                        for move_line in move_line_obj.browse(cr, uid,
+                                            move_line_tax, context=context)]))
+
+        return True
+    
+    def action_close_tax(self, cr, uid, ids, context=None):
+        aml_obj = self.pool.get('account.move.line')
+        period_obj = self.pool.get('account.period')
+        context = context or {}
+        ids= isinstance(ids,(int,long)) and [ids] or ids
+        for voucher_tax_sat in self.browse(cr, uid, ids, context=context):
+                                            
+                self.validate_move_line(cr, uid,
+                                        voucher_tax_sat, context=context)
+                                    
+                move_id = self.create_move_sat(cr, uid, ids, context=context)
+                self.write(cr, uid, ids, {'move_id': move_id})
+                
+                amount_tax_sat = sum([move_line_tax_sat.credit
+                            for move_line_tax_sat in voucher_tax_sat.aml_ids])
+                            
+                self.create_move_line_sat(cr, uid, voucher_tax_sat,
+                                            amount_tax_sat, context=context)
+                                            
+                self.create_entries_tax_iva_sat(cr, uid, voucher_tax_sat,
+                                                            context=context)
+                                        
+                move_line_copy = [ aml_obj.copy(cr, uid, move_line_tax.id,
+                    {
+                        'move_id': move_id,
+                        'period_id': period_obj.find(cr, uid,
+                                        voucher_tax_sat.date,
+                                        context=context)[0],
+                        'journal_id': voucher_tax_sat.journal_id.id,
+                        'credit': 0.0,
+                        'debit': move_line_tax.credit,
+                        'amount_base': None,
+                        'tax_id_secondary': None,
+                        'not_move_diot': True
+                    }) for move_line_tax in voucher_tax_sat.aml_ids ]
+                    
+                cr.execute('UPDATE account_move_line '\
+                            'SET amount_tax_unround = null '\
+                            'WHERE id in %s ',(tuple(move_line_copy), ))
+                            
+        return self.write(cr, uid, ids, {'state': 'done'}, context=context)
+    
+    def action_cancel(self, cr, uid, ids, context=None):
+        obj_move_line = self.pool.get('account.move.line')
+        obj_move = self.pool.get('account.move')
+        for tax_sat in self.browse(cr, uid, ids, context=context):
+            if tax_sat.move_id:
+                obj_move_line._remove_move_reconcile(cr, uid,
+                    [move_line.id
+                        for move_line in tax_sat.move_id.line_id],
+                    context=context)
+                obj_move.unlink(cr, uid, [tax_sat.move_id.id],
+                                context=context)
+        return self.write(cr, uid, ids, {'state': 'draft'}, context=context)
+    
+    def create_entries_tax_iva_sat(self, cr, uid, voucher_tax_sat,
+                                                            context=None):
+        aml_obj = self.pool.get('account.move.line')
+        av_obj = self.pool.get('account.voucher')
+        period_obj = self.pool.get('account.period')
+        for move_line in voucher_tax_sat.aml_ids:
+            if move_line.tax_id_secondary and\
+                                        move_line.tax_id_secondary.tax_sat_ok:
+                amount_base, tax_secondary = av_obj._get_base_amount_tax_secondary(cr,
+                            uid, move_line.tax_id_secondary,
+                            move_line.amount_base, move_line.credit,
+                            context=context)
+                move_line_dt = {
+                    'move_id': voucher_tax_sat.move_id.id,
+                    'journal_id': voucher_tax_sat.journal_id.id,
+                    'date': voucher_tax_sat.date,
+                    'period_id': period_obj.find(cr, uid,
+                                                    voucher_tax_sat.date,
+                                                    context=context)[0],
+                    'debit': move_line.credit,
+                    'name': _('Close of IVA Retained'),
+                    'partner_id' : move_line.partner_id.id,
+                    'account_id': move_line.tax_id_secondary.account_id_creditable.id,
+                    'credit': 0.0,
+                    'amount_base': amount_base,
+                    'tax_id_secondary': move_line.tax_id_secondary.tax_reference.id
+                }
+                move_line_cr = {
+                    'move_id': voucher_tax_sat.move_id.id,
+                    'journal_id': voucher_tax_sat.journal_id.id,
+                    'date': voucher_tax_sat.date,
+                    'period_id': period_obj.find(cr, uid,
+                                                    voucher_tax_sat.date,
+                                                    context=context)[0],
+                    'debit': 0.0,
+                    'name': _('Close of IVA Retained'),
+                    'partner_id' : move_line.partner_id.id,
+                    'account_id': move_line.tax_id_secondary.account_id_by_creditable.id,
+                    'credit': move_line.credit,
+                }
+                for line_dt_cr in [move_line_dt, move_line_cr]:
+                    aml_obj.create(cr, uid, line_dt_cr, context=context)
+        return True
+    
+    def create_move_line_sat(self, cr, uid, voucher_tax_sat, amount, context=None):
+        aml_obj = self.pool.get('account.move.line')
+        period_obj = self.pool.get('account.period')
+        vals = {
+            'move_id': voucher_tax_sat.move_id.id,
+            'journal_id': voucher_tax_sat.journal_id.id,
+            'date': voucher_tax_sat.date,
+            'period_id': period_obj.find(cr, uid,
+                                                voucher_tax_sat.date,
+                                                context=context)[0],
+            'debit': 0,
+            'name': _('Payment to SAT'),
+            'partner_id': voucher_tax_sat.partner_id.id,
+            'account_id': voucher_tax_sat.partner_id.property_account_payable.id,
+            'credit': amount,
+        }
+        return aml_obj.create(cr, uid, vals, context=context)
+    
+    def create_move_sat(self, cr, uid, ids, context=None):
+        account_move_obj = self.pool.get('account.move')
+        context = context or {}
+        ids= isinstance(ids,(int,long)) and [ids] or ids
+        for move_tax_sat in self.browse(cr, uid, ids, context=context):
+            vals_move_tax= account_move_obj.account_move_prepare(cr, uid,
+                    move_tax_sat.journal_id.id,
+                    date = move_tax_sat.date,
+                    ref='Entry SAT', context=context)
+        return account_move_obj.create(cr, uid, vals_move_tax, context=context)
+
+
+    def sat_pay(self, cr, uid, ids, context=None):
+        """
+        """
+        context = context or {}
+        ids = isinstance(ids, (int, long)) and [ids] or ids
+        if not ids: return []
+        dummy, view_id = self.pool.get('ir.model.data').\
+                                get_object_reference(cr, uid,
+                                'account_voucher', 'view_vendor_payment_form')
+        exp_brw = self.browse(cr, uid, ids[0], context=context)
+        return {
+            'name':_("Pay SAT"),
+            'view_mode': 'form',
+            'view_id': view_id,
+            'view_type': 'form',
+            'res_model': 'account.voucher',
+            'type': 'ir.actions.act_window',
+            'nodestroy': True,
+            'target': 'current',
+            'domain': '[]',
+            'context': {
+                'default_partner_id': exp_brw.partner_id.id,
+                'default_amount': 0.0,
+                'close_after_process': True,
+                'default_type': 'payment',
+                'type': 'payment',
+            }
+        }
+
+
+class account_tax(osv.Model):
+    
+    _inherit = 'account.tax'
+    
+    _columns = {
+        'tax_sat_ok': fields.boolean('Create entries IVA to SAT'),
+        'account_id_creditable': fields.many2one('account.account',
+                                        'Account of entries SAT Acreditable'),
+        'account_id_by_creditable': fields.many2one('account.account',
+                                        'Account of entries SAT x Acreditable'),
+        'tax_reference': fields.many2one('account.tax',
+            'Tax Reference',
+            help = 'Tax Reference to get data of DIOT/SAT')
+    }
\ No newline at end of file

=== added file 'account_voucher_tax_sat/model/partner.py'
--- account_voucher_tax_sat/model/partner.py	1970-01-01 00:00:00 +0000
+++ account_voucher_tax_sat/model/partner.py	2013-10-25 22:36:34 +0000
@@ -0,0 +1,36 @@
+#!/usr/bin/python
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#    Copyright (C) Vauxoo (<http://vauxoo.com>).
+#    All Rights Reserved
+###############Credits######################################################
+#    Coded by: Julio Cesar Serna Hernandez([e-mail])
+#############################################################################
+#    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 openerp.osv import fields, osv
+from openerp import netsvc
+import openerp.addons.decimal_precision as dp
+from openerp.tools.translate import _
+
+
+class res_partner(osv.Model):
+    
+    _inherit = 'res.partner'
+    
+    _columns = {
+        'sat': fields.boolean('Is SAT?')
+    }
\ No newline at end of file

=== added directory 'account_voucher_tax_sat/security'
=== added file 'account_voucher_tax_sat/security/ir.model.access.csv'
--- account_voucher_tax_sat/security/ir.model.access.csv	1970-01-01 00:00:00 +0000
+++ account_voucher_tax_sat/security/ir.model.access.csv	2013-10-25 22:36:34 +0000
@@ -0,0 +1,4 @@
+"id","name","model_id:id","group_id:id","perm_read","perm_write","perm_create","perm_unlink"
+"access_tax_sat_user","account.voucher.tax.sat.manager","model_account_voucher_tax_sat","group_voucher_tax_sat_manager",1,1,1,1
+"access_tax_sat_manager","account.voucher.tax.sat.user","model_account_voucher_tax_sat","group_voucher_tax_sat_user",1,0,0,0
+"access_tax_sat_assigned","account.voucher.tax.assigned","model_account_voucher_tax_assigned","",1,1,1,1

=== added file 'account_voucher_tax_sat/security/security.xml'
--- account_voucher_tax_sat/security/security.xml	1970-01-01 00:00:00 +0000
+++ account_voucher_tax_sat/security/security.xml	2013-10-25 22:36:34 +0000
@@ -0,0 +1,23 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+        <record model="res.groups" id="group_voucher_tax_sat_user">
+            <field name="name">Tax SAT User</field>
+        </record>
+        <record model="res.groups" id="group_voucher_tax_sat_manager">
+            <field name="name">Tax SAT Manager</field>
+        </record>
+
+        <record id="ir_rule_tax_sat_company" model="ir.rule">
+            <field name="name">See Taxes of SAT of My Own Company</field>
+            <field model="ir.model" name="model_id" ref="model_account_voucher_tax_sat"/>
+            <field name="perm_read" eval="True"/>
+            <field name="perm_write" eval="False"/>
+            <field name="perm_create" eval="False"/>
+            <field name="perm_unlink" eval="False"/>
+            <field eval="False" name="global"/>
+            <field name="domain_force">[('company_id','=',user.company_id.id)]</field>
+            <field name="groups" eval="[(4,ref('account_voucher_tax_sat.group_voucher_tax_sat_manager')),(4,ref('account_voucher_tax_sat.group_voucher_tax_sat_user'))]"/>
+        </record>
+    </data>
+</openerp>

=== added directory 'account_voucher_tax_sat/view'
=== added file 'account_voucher_tax_sat/view/account_voucher_tax_sat_view.xml'
--- account_voucher_tax_sat/view/account_voucher_tax_sat_view.xml	1970-01-01 00:00:00 +0000
+++ account_voucher_tax_sat/view/account_voucher_tax_sat_view.xml	2013-10-25 22:36:34 +0000
@@ -0,0 +1,130 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+
+        <record id="view_account_voucher_tax_sat_form" model="ir.ui.view">
+            <field name="name">account.voucher.tax.sat.form</field>
+            <field name="model">account.voucher.tax.sat</field>
+            <field name="arch" type="xml">
+                <form string="Account Voucher Tax SAT" version="7.0">
+                <header>
+                    <button string="Liquidar Cuentas"
+                            name="action_close_tax"
+                            type="object"
+                            states="draft"
+                            class="oe_highlight"/>
+                            
+                    <button string="Pay SAT"
+                            name="sat_pay"
+                            type="object"
+                            class="oe_highlight"/>
+                            
+                    <button name="%(action_view_account_voucher_tax_assigned)d"
+                            type='action'
+                            string='Assigned Account'
+                            states="draft"
+                            class="oe_highlight"/>
+                            
+                    <button name="action_cancel"
+                            type='object'
+                            string='Cancel'
+                            states="done"
+                            class="oe_highlight"/>
+                            
+                    <field name="state"
+                           widget="statusbar"
+                           statusbar_visible="draft,done,cancelled"
+                           statusbar_colors='{"draft":"blue","approved":"blue"}'/>
+                </header>
+                <div class="oe_title">
+                    <div class="oe_edit_only">
+                        <label for="name"/>
+                    </div>
+                    <h1>
+                        <field name="name"
+                               default_focus="1"
+                               placeholder="Name"
+                               required='1'
+                               attrs="{'readonly':[('state','!=','draft')]}"/>
+                    </h1>
+                </div>
+                    <group col="4">
+                        <group col='4'>
+                            <field name='partner_id'
+                                   required='1'
+                                   attrs="{'readonly':[('state','!=','draft')]}"
+                                   />
+                            <field name='date'
+                                   required='1'
+                                   attrs="{'readonly':[('state','!=','draft')]}"
+                                   />
+                            <field name='journal_id'
+                                    required='1'
+                                    attrs="{'readonly':[('state','!=','draft')]}"
+                                   />
+                            <field name='period_id'
+                                    on_change="onchange_period(period_id)"
+                                    required='1'
+                                    attrs="{'readonly':[('state','!=','draft')]}"
+                                   />
+                            <field name='move_id'
+                                    readonly='1'
+                                   />
+                        </group>
+                        <group col='1' colspan='4'>
+                            <field name='aml_ids'
+                            attrs="{'readonly':[('state','!=','draft')]}"
+                                   />
+                        </group>
+                    </group>
+                </form>
+            </field>
+        </record>
+
+        <record id="view_account_voucher_tax_sat_tree" model="ir.ui.view">
+            <field name="name">account.voucher.tax.sat.tree</field>
+            <field name="model">account.voucher.tax.sat</field>
+            <field name="arch" type="xml">
+                <tree string="Account Voucher Tax SAT">
+                        <field name="name"/>
+                        <field name="date"/>
+                        <field name="aml_ids"/>
+                </tree>
+            </field>
+        </record>
+
+        <record model="ir.actions.act_window" id="account_voucher_tax_sat_action">
+            <field name="name">Voucher Tax SAT</field>
+            <field name="res_model">account.voucher.tax.sat</field>
+            <field name="view_type">form</field>
+            <field name="view_mode">tree,form</field>
+        </record>
+
+        <menuitem 
+            id="account_voucher_tax_sat_menu" 
+            parent='account.menu_finance_payables'
+            action='account_voucher_tax_sat_action'
+            sequence='20'
+            />
+
+
+        <record id="view_account_voucher_tax_sat" model="ir.ui.view">
+                <field name="name">view.account.voucher.tax.sat</field>
+                <field name="model">account.tax</field>
+                <field name="inherit_id" ref="account.view_tax_form"/>
+                <field name="arch" type="xml">
+                    <xpath expr="//field[@name='active']" position="after">
+                        <field name="tax_sat_ok"/>
+                        <newline/>
+                        <group attrs="{'invisible':[('tax_sat_ok','=',False)]}" colspan="4">
+                            <field name="account_id_creditable" attrs="{'required':[('tax_sat_ok','=',True)]}"/>
+                            <field name="account_id_by_creditable" attrs="{'required':[('tax_sat_ok','=',True)]}"/>
+                            <field name="tax_reference" attrs="{'required':[('tax_sat_ok','=',True)]}"/>
+                        </group>
+                    </xpath>
+                </field>
+        </record>
+        
+
+    </data>
+</openerp>

=== added file 'account_voucher_tax_sat/view/partner_view.xml'
--- account_voucher_tax_sat/view/partner_view.xml	1970-01-01 00:00:00 +0000
+++ account_voucher_tax_sat/view/partner_view.xml	2013-10-25 22:36:34 +0000
@@ -0,0 +1,15 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+        <record id="view_res_partner_sat" model="ir.ui.view">
+                <field name="name">view.res.partner.sat</field>
+                <field name="model">res.partner</field>
+                <field name="inherit_id" ref="base.view_partner_form"/>
+                <field name="arch" type="xml">
+                    <xpath expr="//field[@name='customer']" position="after">
+                        <field name="sat"/>
+                    </xpath>
+                </field>
+        </record>
+    </data>
+</openerp>

=== added directory 'account_voucher_tax_sat/wizard'
=== added file 'account_voucher_tax_sat/wizard/__init__.py'
--- account_voucher_tax_sat/wizard/__init__.py	1970-01-01 00:00:00 +0000
+++ account_voucher_tax_sat/wizard/__init__.py	2013-10-25 22:36:34 +0000
@@ -0,0 +1,25 @@
+#!/usr/bin/python
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#    Copyright (C) Vauxoo (<http://vauxoo.com>).
+#    All Rights Reserved
+###############Credits######################################################
+#    Coded by: Julio Cesar Serna Hernandez([e-mail])
+#############################################################################
+#    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 account_tax_sat
\ No newline at end of file

=== added file 'account_voucher_tax_sat/wizard/account_tax_sat.py'
--- account_voucher_tax_sat/wizard/account_tax_sat.py	1970-01-01 00:00:00 +0000
+++ account_voucher_tax_sat/wizard/account_tax_sat.py	2013-10-25 22:36:34 +0000
@@ -0,0 +1,66 @@
+#!/usr/bin/python
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#    Copyright (C) Vauxoo (<http://vauxoo.com>).
+#    All Rights Reserved
+###############Credits######################################################
+#    Coded by: Julio Cesar Serna Hernandez([e-mail])
+#############################################################################
+#    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 openerp.osv import fields, osv
+from openerp import netsvc
+import openerp.addons.decimal_precision as dp
+from openerp.tools.translate import _
+
+
+class account_voucher_tax_assigned(osv.TransientModel):
+    
+    _name = 'account.voucher.tax.assigned'
+    
+    _columns = {
+        'tax_ids': fields.many2many('account.tax', 'voucher_assgined_tax_rel',
+                                'wiz_id',
+                                'tax_id',
+                                'Taxes to Close'),
+        'account_ids': fields.many2many('account.account', 'assigned_account_rel',
+                                'wiz_id',
+                                'account_id',
+                                'Account to Close'),
+    }
+    
+    def action_account_assigned(self, cr, uid, ids, context=None):
+        aml_obj = self.pool.get('account.move.line')
+        acc_voucher_tax_sat_obj = self.pool.get('account.voucher.tax.sat')
+        if context is None:
+            context = {}
+        for tax_assigned in self.browse(cr, uid, ids, context=context):
+            acc_vocuher_tax_sat = acc_voucher_tax_sat_obj.browse(cr, uid,
+                                            context.get('active_id', False))
+            taxe_assigned = [taxes.id for taxes in tax_assigned.tax_ids]
+            account_assigned = [acc.id for acc in tax_assigned.account_ids]
+            move_line_to_close = aml_obj.search(cr, uid, ['|',
+                        ('tax_id_secondary', 'in', taxe_assigned),
+                        ('account_id', 'in', account_assigned),
+                        ('credit', '>', 0.0),
+                        ('period_id', '=', acc_vocuher_tax_sat.period_id.id)
+                        ])
+            acc_voucher_tax_sat_obj.write(cr, uid, acc_vocuher_tax_sat.id,
+                {'aml_ids': [(4, move_id) for move_id in move_line_to_close]})
+        return True
+    
\ No newline at end of file

=== added file 'account_voucher_tax_sat/wizard/account_tax_sat_view.xml'
--- account_voucher_tax_sat/wizard/account_tax_sat_view.xml	1970-01-01 00:00:00 +0000
+++ account_voucher_tax_sat/wizard/account_tax_sat_view.xml	2013-10-25 22:36:34 +0000
@@ -0,0 +1,39 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+
+        <record id="view_account_voucher_tax_form2" model="ir.ui.view">
+            <field name="name">account.voucher.tax.assigned.form</field>
+            <field name="model">account.voucher.tax.assigned</field>
+            <field name="arch" type="xml">
+                <form string="Account Voucher Tax Assigned" version="7.0">
+                    <group col="4">
+                        <group col='1' colspan='4'>
+                            <field name='tax_ids'
+                                   readonly='0'
+                                   />
+                            <field name='account_ids'
+                                   readonly='0'
+                                   />
+                        </group>
+                    </group>
+                    <footer>
+                        <button string="Ok" name="action_account_assigned" type="object" class="oe_highlight"/>
+                        or
+                        <button string="Cancel" class="oe_link" special="cancel"/>
+                    </footer>
+                </form>
+            </field>
+        </record>
+
+        <record id="action_view_account_voucher_tax_assigned" model="ir.actions.act_window">
+            <field name="name">Account Voucher Tax Assigned</field>
+            <field name="res_model">account.voucher.tax.assigned</field>
+            <field name="view_type">form</field>
+            <field name="view_mode">tree,form</field>
+            <field name="view_id" ref="view_account_voucher_tax_form2"/>
+            <field name="target">new</field>
+        </record>
+
+    </data>
+</openerp>