Merge lp:~domsense/domsense-agilebg-addons/adding_account_vat_period_end_statement into lp:domsense-agilebg-addons/6.0

[Lorenzo Battistini]

=== added directory 'account_vat_period_end_statement'
=== added file 'account_vat_period_end_statement/AUTHORS.txt'
--- account_vat_period_end_statement/AUTHORS.txt	1970-01-01 00:00:00 +0000
+++ account_vat_period_end_statement/AUTHORS.txt	2011-10-05 08:15:22 +0000
@@ -0,0 +1,3 @@
+Lorenzo Battistini <[e-mail]>
+Marco Marchiori <[e-mail]>
+Sergio Corato <[e-mail]>

=== added file 'account_vat_period_end_statement/__init__.py'
--- account_vat_period_end_statement/__init__.py	1970-01-01 00:00:00 +0000
+++ account_vat_period_end_statement/__init__.py	2011-10-05 08:15:22 +0000
@@ -0,0 +1,22 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2011 Domsense s.r.l. (<http://www.domsense.com>).
+#
+#    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
+import report

=== added file 'account_vat_period_end_statement/__openerp__.py'
--- account_vat_period_end_statement/__openerp__.py	1970-01-01 00:00:00 +0000
+++ account_vat_period_end_statement/__openerp__.py	2011-10-05 08:15:22 +0000
@@ -0,0 +1,46 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2011 Domsense s.r.l. (<http://www.domsense.com>).
+#
+#    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": "Period End VAT Statement",
+    "version": "0.2",
+    'category': 'Generic Modules/Accounting',
+    "depends": ["account_voucher", "report_webkit"],
+    "author": "Agile Business Group & Domsense",
+    "description": """This module helps to register the VAT statement of period end. The 'VAT statement' object allows to specify every amount and relative account used by the statement.
+By default, the amounts of debit and credit taxes are automatically loaded from the tax codes of the selected period. Previous debit or credit is loaded from previous VAT statement.
+In order to load the correct amount from tax code, the tax code has to be associated to the account involved in the statement, through the tax code form.
+Confirming the statement, the account.move is created along with a draft payment voucher.
+
+Specification: http://wiki.openerp-italia.org/doku.php/moduli/vat_period_end_statement""",
+    'website': 'http://www.agilebg.com',
+    'init_xml': [],
+    'update_xml': [
+        'account_view.xml',
+        'statement_workflow.xml',
+        'security/ir.model.access.csv',
+        'reports.xml',
+        ],
+    'demo_xml': [],
+    'installable': True,
+    'active': False,
+}

=== added file 'account_vat_period_end_statement/account.py'
--- account_vat_period_end_statement/account.py	1970-01-01 00:00:00 +0000
+++ account_vat_period_end_statement/account.py	2011-10-05 08:15:22 +0000
@@ -0,0 +1,481 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2011 Domsense s.r.l. (<http://www.domsense.com>).
+#
+#    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/>.
+#
+##############################################################################
+
+from osv import fields, osv
+from tools.translate import _
+import math
+import decimal_precision as dp
+import netsvc
+from datetime import datetime
+from dateutil.relativedelta import relativedelta
+
+class account_vat_period_end_statement(osv.osv):
+
+    def _compute_authority_vat_amount(self, cr, uid, ids, field_name, arg, context):
+        res={}
+        for i in ids:
+            statement = self.browse(cr, uid, i)
+            debit_vat_amount = 0.0
+            credit_vat_amount = 0.0
+            generic_vat_amount = 0.0
+            for debit_line in statement.debit_vat_account_line_ids:
+                debit_vat_amount += debit_line.amount
+            for credit_line in statement.credit_vat_account_line_ids:
+                credit_vat_amount += credit_line.amount
+            for generic_line in statement.generic_vat_account_line_ids:
+                generic_vat_amount += generic_line.amount
+            authority_amount = (debit_vat_amount - credit_vat_amount - generic_vat_amount
+                - statement.previous_credit_vat_amount + statement.previous_debit_vat_amount)
+            res[i] = authority_amount
+        return res
+
+    def _compute_payable_vat_amount(self, cr, uid, ids, field_name, arg, context):
+        res={}
+        for i in ids:
+            statement = self.browse(cr, uid, i)
+            debit_vat_amount = 0.0
+            for debit_line in statement.debit_vat_account_line_ids:
+                debit_vat_amount += debit_line.amount
+            res[i] = debit_vat_amount
+        return res
+
+    def _compute_deductible_vat_amount(self, cr, uid, ids, field_name, arg, context):
+        res={}
+        for i in ids:
+            statement = self.browse(cr, uid, i)
+            credit_vat_amount = 0.0
+            for credit_line in statement.credit_vat_account_line_ids:
+                credit_vat_amount += credit_line.amount
+            res[i] = credit_vat_amount
+        return res
+
+    _name = "account.vat.period.end.statement"
+    _rec_name = 'period_id'
+    _columns = {
+        'debit_vat_account_line_ids': fields.one2many('statement.debit.account.line', 'statement_id', 'Debit VAT', help='The accounts containing the debit VAT amount to write-off', required=True, states={'confirmed': [('readonly', True)], 'paid': [('readonly', True)]}),
+
+        'credit_vat_account_line_ids': fields.one2many('statement.credit.account.line', 'statement_id', 'Credit VAT', help='The accounts containing the credit VAT amount to write-off', required=True, states={'confirmed': [('readonly', True)], 'paid': [('readonly', True)]}),
+
+        'previous_credit_vat_account_id': fields.many2one('account.account', 'Previous Credits VAT', help='Credit VAT from previous periods', states={'confirmed': [('readonly', True)], 'paid': [('readonly', True)]}),
+        'previous_credit_vat_amount': fields.float('Previous Credits VAT Amount', states={'confirmed': [('readonly', True)], 'paid': [('readonly', True)]}),
+
+        'previous_debit_vat_account_id': fields.many2one('account.account', 'Previous Debits VAT', help='Debit VAT from previous periods', states={'confirmed': [('readonly', True)], 'paid': [('readonly', True)]}),
+        'previous_debit_vat_amount': fields.float('Previous Debits VAT Amount', states={'confirmed': [('readonly', True)], 'paid': [('readonly', True)]}),
+
+        'generic_vat_account_line_ids': fields.one2many('statement.generic.account.line', 'statement_id', 'Other VAT Credits / Debits or Tax Compensations', states={'confirmed': [('readonly', True)], 'paid': [('readonly', True)]}),
+
+        'authority_partner_id': fields.many2one('res.partner', 'Tax Authority Partner', required=True, states={'confirmed': [('readonly', True)], 'paid': [('readonly', True)]}),
+        'authority_vat_account_id': fields.many2one('account.account', 'Tax Authority VAT Account', required=True, states={'confirmed': [('readonly', True)], 'paid': [('readonly', True)]}),
+        'authority_vat_amount': fields.function(_compute_authority_vat_amount, method=True, string='Authority VAT Amount'),
+        'payable_vat_amount': fields.function(_compute_payable_vat_amount, method=True, string='Payable VAT Amount'),
+        'deductible_vat_amount': fields.function(_compute_deductible_vat_amount, method=True, string='Deductible VAT Amount'),
+
+        'journal_id': fields.many2one('account.journal', 'Journal', required=True, states={'confirmed': [('readonly', True)], 'paid': [('readonly', True)]}),
+        'period_id': fields.many2one('account.period', 'Period', required=True, states={'confirmed': [('readonly', True)], 'paid': [('readonly', True)]}),
+        'move_id': fields.many2one('account.move', 'VAT statement move', readonly=True),
+        'voucher_id': fields.many2one('account.voucher', 'VAT payment', readonly=True),
+
+        'state': fields.selection([
+            ('draft', 'Draft'),
+            ('confirmed', 'Confirmed'),
+            ('paid', 'Paid'),
+            ], 'State', readonly=True),
+    }
+
+    _defaults = {
+        'period_id': lambda self, cr, uid, c: self.pool.get('account.period').find(cr, uid, context=c)[0],
+    }
+
+    def _get_tax_code_amount(self, cr, uid, tax_code_id, period_id, context):
+        if not context:
+            context={}
+        context['period_id'] = period_id
+        return self.pool.get('account.tax.code').browse(cr, uid, tax_code_id, context)._sum_period(
+            None, None, context)[tax_code_id]
+
+    def unlink(self, cr, uid, ids, context=None):
+        if isinstance(ids, (long,int)):
+            ids = [ids]
+        for statement in self.browse(cr, uid, ids, context):
+            if statement.state == 'confirmed' or statement.state == 'paid':
+                raise osv.except_osv(_('Error!'), _('You cannot delete a confirmed or paid statement'))
+        res = super(account_vat_period_end_statement, self).unlink(cr, uid, ids, context)
+        return res
+
+    def statement_draft(self, cr, uid, ids, context=None):
+        for statement in self.browse(cr, uid, ids, context):
+            if statement.move_id:
+                statement.move_id.unlink()
+            if statement.voucher_id:
+                statement.voucher_id.unlink()
+        self.write(cr, uid, ids , {'state': 'draft'})
+
+    def statement_paid(self, cr, uid, ids, context=None):
+        self.write(cr, uid, ids , {'state': 'paid'})
+
+    def create_move(self, cr, uid, ids, context=None):
+        move_obj = self.pool.get('account.move')
+        voucher_obj = self.pool.get('account.voucher')
+        line_obj = self.pool.get('account.move.line')
+        for statement in self.browse(cr, uid, ids, context):
+
+            statement_ids = self.search(cr, uid, [('period_id', '=', statement.period_id.id)])
+            if len(statement_ids) > 1:
+                raise osv.except_osv(_('Error!'), _('The current period has VAT statement yet'))
+
+            # move
+
+            move_data = {
+                'name': _('VAT statement') + ' - ' + statement.period_id.name,
+                'period_id': statement.period_id.id,
+                'date': statement.period_id.date_stop,
+                'journal_id': statement.journal_id.id,
+                }
+            move_id = move_obj.create(cr, uid, move_data)
+            statement.write({'move_id': move_id})
+
+            for debit_line in statement.debit_vat_account_line_ids:
+                debit_vat_data = {
+                    'name': _('Debit VAT'),
+                    'account_id': debit_line.account_id.id,
+                    'move_id': move_id,
+                    'period_id': statement.period_id.id,
+                    'journal_id': statement.journal_id.id,
+                    'debit': 0.0,
+                    'credit': 0.0,
+                    'date': statement.period_id.date_stop,
+                    }
+                if debit_line.amount > 0:
+                    debit_vat_data['debit'] = math.fabs(debit_line.amount)
+                else:
+                    debit_vat_data['credit'] = math.fabs(debit_line.amount)
+                line_obj.create(cr, uid, debit_vat_data)
+
+            for credit_line in statement.credit_vat_account_line_ids:
+                credit_vat_data = {
+                    'name': _('Credit VAT'),
+                    'account_id': credit_line.account_id.id,
+                    'move_id': move_id,
+                    'period_id': statement.period_id.id,
+                    'journal_id': statement.journal_id.id,
+                    'debit': 0.0,
+                    'credit': 0.0,
+                    'date': statement.period_id.date_stop,
+                    }
+                if credit_line.amount < 0:
+                    credit_vat_data['debit'] = math.fabs(credit_line.amount)
+                else:
+                    credit_vat_data['credit'] = math.fabs(credit_line.amount)
+                line_obj.create(cr, uid, credit_vat_data)
+
+            if statement.previous_credit_vat_amount:
+                previous_credit_vat_data = {
+                    'name': _('Previous Credits VAT'),
+                    'account_id': statement.previous_credit_vat_account_id.id,
+                    'move_id': move_id,
+                    'period_id': statement.period_id.id,
+                    'journal_id': statement.journal_id.id,
+                    'debit': 0.0,
+                    'credit': 0.0,
+                    'date': statement.period_id.date_stop,
+                    }
+                if statement.previous_credit_vat_amount < 0:
+                    previous_credit_vat_data['debit'] = math.fabs(statement.previous_credit_vat_amount)
+                else:
+                    previous_credit_vat_data['credit'] = math.fabs(statement.previous_credit_vat_amount)
+                line_obj.create(cr, uid, previous_credit_vat_data)
+
+            if statement.previous_debit_vat_amount:
+                previous_debit_vat_data = {
+                    'name': _('Previous Debits VAT'),
+                    'account_id': statement.previous_debit_vat_account_id.id,
+                    'move_id': move_id,
+                    'period_id': statement.period_id.id,
+                    'journal_id': statement.journal_id.id,
+                    'debit': 0.0,
+                    'credit': 0.0,
+                    'date': statement.period_id.date_stop,
+                    }
+                if statement.previous_debit_vat_amount > 0:
+                    previous_debit_vat_data['debit'] = math.fabs(statement.previous_debit_vat_amount)
+                else:
+                    previous_debit_vat_data['credit'] = math.fabs(statement.previous_debit_vat_amount)
+                line_obj.create(cr, uid, previous_debit_vat_data)
+
+            for generic_line in statement.generic_vat_account_line_ids:
+                generic_vat_data = {
+                    'name': _('Other VAT Credits / Debits'),
+                    'account_id': generic_line.account_id.id,
+                    'move_id': move_id,
+                    'period_id': statement.period_id.id,
+                    'journal_id': statement.journal_id.id,
+                    'debit': 0.0,
+                    'credit': 0.0,
+                    'date': statement.period_id.date_stop,
+                    }
+                if generic_line.amount < 0:
+                    generic_vat_data['debit'] = math.fabs(generic_line.amount)
+                else:
+                    generic_vat_data['credit'] = math.fabs(generic_line.amount)
+                line_obj.create(cr, uid, generic_vat_data)
+
+            end_debit_vat_data = {
+                'name': _('Tax Authority VAT'),
+                'account_id': statement.authority_vat_account_id.id,
+                'partner_id': statement.authority_partner_id.id,
+                'move_id': move_id,
+                'period_id': statement.period_id.id,
+                'journal_id': statement.journal_id.id,
+                'date': statement.period_id.date_stop,
+                }
+            if statement.authority_vat_amount > 0:
+                end_debit_vat_data['debit'] = 0.0
+                end_debit_vat_data['credit'] = math.fabs(statement.authority_vat_amount)
+            elif statement.authority_vat_amount < 0:
+                end_debit_vat_data['debit'] = math.fabs(statement.authority_vat_amount)
+                end_debit_vat_data['credit'] = 0.0
+            line_obj.create(cr, uid, end_debit_vat_data)
+
+            move_obj.button_validate(cr, uid, [move_id], context)
+
+            # voucher
+
+            if statement.authority_vat_amount > 0:
+                voucher_data = {
+                    'partner_id': statement.authority_partner_id.id,
+                    'amount': statement.authority_vat_amount,
+                    'journal_id': statement.journal_id.id,
+                    'type': 'payment',
+                    }
+                vals = voucher_obj.onchange_partner_id(
+                    cr, uid, ids, statement.authority_partner_id.id, statement.journal_id.id, statement.authority_vat_amount,
+                    None, 'payment', None, context)
+                voucher_data.update(vals['value'])
+
+                line_dr_ids = []
+                for line_dr in voucher_data['line_dr_ids']:
+                    line_dr_ids.append((0,0, line_dr))
+                voucher_data['line_dr_ids'] = line_dr_ids
+                voucher_data['line_ids'] = []
+                voucher_data['line_cr_ids'] = []
+
+                voucher_id = voucher_obj.create(cr, uid, voucher_data, context)
+                statement.write({'voucher_id': voucher_id})
+
+            self.write(cr, uid, statement.id , {'state': 'confirmed'})
+
+        return True
+
+    def _create_statement_account_line(self, cr, uid, statement_ids, tax_code_type='debit', context=None):
+        if not context:
+            context={}
+        tax_code_pool = self.pool.get('account.tax.code')
+        line_obj = self.pool.get('statement.' + tax_code_type + '.account.line')
+        for statement in self.browse(cr, uid, statement_ids):
+            for line in eval('statement.' + tax_code_type + '_vat_account_line_ids'):
+                line.unlink()
+            context['period_id'] = statement.period_id.id
+            tax_code_ids = tax_code_pool.search(cr, uid, [
+                ('vat_statement_account_id', '!=', False),
+                ('vat_statement_type', '=', tax_code_type),
+                ], context=context)
+            for tax_code in tax_code_pool.browse(cr, uid, tax_code_ids, context=context):
+                line_obj.create(cr, uid, {
+                    'statement_id': statement.id,
+                    'account_id': tax_code.vat_statement_account_id.id,
+                    'amount': tax_code.sum_period,
+                    })
+        return True
+
+    # TODO load by default. see voucher lines
+    '''
+    'line_dr_ids': [{'account_id': 96,
+                      'amount': 20.0,
+                      'amount_original': 20.0,
+                      'amount_unreconciled': 20.0,
+                      'date_due': False,
+                      'date_original': '2011-09-30',
+                      'move_line_id': 17,
+                      'name': u'VAT statement - 09/2011',
+                      'type': 'dr'}],
+    '''
+
+    def load_debit_accounts(self, cr, uid, ids, context=None):
+        if not context:
+            context={}
+        self._create_statement_account_line(cr, uid, ids, tax_code_type='debit', context=context)
+        return True
+
+    def load_credit_accounts(self, cr, uid, ids, context=None):
+        if not context:
+            context={}
+        self._create_statement_account_line(cr, uid, ids, tax_code_type='credit', context=context)
+        return True
+
+    def open_chart_of_taxes(self, cr, uid, ids, context=None):
+        result = {}
+        if context is None:
+            context = {}
+        for statement in self.browse(cr, uid, ids, context):
+            mod_obj = self.pool.get('ir.model.data')
+            act_obj = self.pool.get('ir.actions.act_window')
+            period_obj = self.pool.get('account.period')
+            result = mod_obj.get_object_reference(cr, uid, 'account', 'action_tax_code_tree')
+            id = result and result[1] or False
+            result = act_obj.read(cr, uid, [id], context=context)[0]
+
+            fiscalyear_id = statement.period_id.fiscalyear_id.id
+            result['context'] = str({'period_id': statement.period_id.id, \
+                                     'fiscalyear_id': fiscalyear_id, \
+                                        'state': 'posted'})
+
+            period_code = statement.period_id.code
+            result['name'] += period_code and (':' + period_code) or ''
+            result['nodestroy'] = True
+        return result
+
+    def on_change_partner_id(self, cr, uid, ids, partner_id, context=None):
+        partner = self.pool.get('res.partner').browse(cr, uid, partner_id, context)
+        return {'value': {'authority_vat_account_id': partner.property_account_payable.id}}
+
+    def on_change_period_id(self, cr, uid, ids, period_id, context=None):
+        if not context:
+            context={}
+        res = {'value': {}}
+        period_pool = self.pool.get('account.period')
+        period = period_pool.browse(cr, uid, period_id, context)
+        start_period = datetime.strptime(period.date_start, '%Y-%m-%d')
+        prev_period_stop = start_period - relativedelta(days=1)
+        prev_period_ids = period_pool.search(cr, uid, [('date_stop', '=', prev_period_stop)])
+        if prev_period_ids:
+            prev_statement_ids = self.search(cr, uid, [('period_id', '=', prev_period_ids[0])])
+            if prev_statement_ids:
+                prev_statement = self.browse(cr, uid, prev_statement_ids[0])
+                if prev_statement.state == 'confirmed':
+                    if prev_statement.authority_vat_amount > 0:
+                        res['value']['previous_debit_vat_amount'] = prev_statement.authority_vat_amount
+                    elif prev_statement.authority_vat_amount < 0:
+                        res['value']['previous_credit_vat_amount'] = math.fabs(prev_statement.authority_vat_amount)
+
+        statement_ids = self.search(cr, uid, [('period_id', '=', period_id)])
+        if statement_ids:
+            statement = self.browse(cr, uid, statement_ids[0])
+            for debit_line in statement.debit_vat_account_line_ids:
+                debit_line.unlink()
+            for credit_line in statement.credit_vat_account_line_ids:
+                credit_line.unlink()
+
+        context['period_id'] = period_id
+        credit_line_ids = []
+        debit_line_ids = []
+        tax_code_pool = self.pool.get('account.tax.code')
+
+        debit_tax_code_ids = tax_code_pool.search(cr, uid, [
+            ('vat_statement_account_id', '!=', False),
+            ('vat_statement_type', '=', 'debit'),
+            ], context=context)
+        for debit_tax_code in tax_code_pool.browse(cr, uid, debit_tax_code_ids, context=context):
+            debit_line_ids.append({
+                'account_id': debit_tax_code.vat_statement_account_id.id,
+                'amount': debit_tax_code.sum_period,
+                })
+
+        credit_tax_code_ids = tax_code_pool.search(cr, uid, [
+            ('vat_statement_account_id', '!=', False),
+            ('vat_statement_type', '=', 'credit'),
+            ], context=context)
+        for credit_tax_code in tax_code_pool.browse(cr, uid, credit_tax_code_ids, context=context):
+            credit_line_ids.append({
+                'account_id': credit_tax_code.vat_statement_account_id.id,
+                'amount': credit_tax_code.sum_period,
+                })
+
+        res['value']['debit_vat_account_line_ids'] = debit_line_ids
+        res['value']['credit_vat_account_line_ids'] = credit_line_ids
+
+        return res
+
+account_vat_period_end_statement()
+
+class statement_debit_account_line(osv.osv):
+    _name='statement.debit.account.line'
+    _columns = {
+        'account_id': fields.many2one('account.account', 'Account', required=True),
+        'statement_id': fields.many2one('account.vat.period.end.statement', 'VAT statement'),
+        'amount': fields.float('Amount', digits_compute= dp.get_precision('Account'), required=True),
+        }
+
+statement_debit_account_line()
+
+class statement_credit_account_line(osv.osv):
+    _name='statement.credit.account.line'
+    _columns = {
+        'account_id': fields.many2one('account.account', 'Account', required=True),
+        'statement_id': fields.many2one('account.vat.period.end.statement', 'VAT statement'),
+        'amount': fields.float('Amount', digits_compute= dp.get_precision('Account'), required=True),
+        }
+
+statement_credit_account_line()
+
+class statement_generic_account_line(osv.osv):
+    _name='statement.generic.account.line'
+    _columns = {
+        'account_id': fields.many2one('account.account', 'Account', required=True),
+        'statement_id': fields.many2one('account.vat.period.end.statement', 'VAT statement'),
+        'amount': fields.float('Amount', digits_compute= dp.get_precision('Account'), required=True),
+        }
+
+    def on_change_vat_account_id(self, cr, uid, ids, vat_account_id=False, context=None):
+        res = {}
+        res['value'] = {}
+        if not vat_account_id:
+            return res
+        res['value']['amount'] = self.pool.get('account.account').browse(cr, uid, vat_account_id,
+            context).balance
+        return res
+
+statement_generic_account_line()
+
+class account_tax_code(osv.osv):
+    _inherit = "account.tax.code"
+    _columns = {
+        'vat_statement_account_id': fields.many2one('account.account', "Account used for VAT statement"),
+        'vat_statement_type': fields.selection([('credit','Credit'),('debit','Debit')], 'Type', help="This establish whether amount will be loaded as debit or credit"),
+        }
+    _defaults = {
+        'vat_statement_type': 'debit',
+    }
+account_tax_code()
+
+class account_voucher(osv.osv):
+    _inherit = "account.voucher"
+
+    def proforma_voucher(self, cr, uid, ids, context=None):
+        res = super(account_voucher, self).proforma_voucher(cr, uid, ids, context=context)
+        statement_pool = self.pool.get('account.vat.period.end.statement')
+        for voucher_id in ids:
+            statement_ids = statement_pool.search(cr, uid, [('voucher_id', '=', voucher_id)])
+            for statement_id in statement_ids:
+                wf_service = netsvc.LocalService("workflow")
+                wf_service.trg_validate(uid, 'account.vat.period.end.statement', statement_id, 'set_paid', cr)
+        return res
+
+account_voucher()

=== added file 'account_vat_period_end_statement/account_view.xml'
--- account_vat_period_end_statement/account_view.xml	1970-01-01 00:00:00 +0000
+++ account_vat_period_end_statement/account_view.xml	2011-10-05 08:15:22 +0000
@@ -0,0 +1,120 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+
+<!--    Statement   -->
+
+        <record id="view_account_vat_period_end_statement" model="ir.ui.view">
+            <field name="name">account.vat.period.end.statement.form</field>
+            <field name="model">account.vat.period.end.statement</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Vat statement">
+                    <field name="journal_id"   widget="selection" select="1"/>
+                    <group col="3" colspan="2">
+                        <field name="period_id"  select="1" on_change="on_change_period_id(period_id)"/>
+                        <button name="open_chart_of_taxes" string="View chart of taxes for selected period" type="object"/>
+                    </group>
+                    <field name="move_id"  select="1"/>
+                    <field name="voucher_id"  select="1" context="{'form_view_ref' : 'account_voucher.view_vendor_payment_form'}"/>
+                    <notebook colspan="4">
+                        <page string="General">
+                            <group colspan="4" col="3">
+                                <group col="2" colspan="3">
+                                    <field name="debit_vat_account_line_ids" nolabel="1"  >
+                                        <tree editable="bottom" string="Debit Account Lines">
+                                            <field name="account_id" />
+                                            <field name="amount" />
+                                       </tree>
+                                        <form editable="bottom">
+                                            <field name="account_id" />
+                                            <field name="amount" />
+                                       </form>
+                                    </field>
+                                    <field name="credit_vat_account_line_ids" nolabel="1">
+                                        <tree editable="bottom" string="Credit Account Lines">
+                                            <field name="account_id" />
+                                            <field name="amount" />
+                                       </tree>
+                                        <form editable="bottom">
+                                            <field name="account_id" />
+                                            <field name="amount" />
+                                       </form>
+                                    </field>
+                                    <button name="load_debit_accounts" string="Load chargeable VAT" type="object"/>
+                                    <button name="load_credit_accounts" string="Load deductible VAT" type="object"/>
+                                </group>
+                                <separator colspan="3" string="Previous Credits VAT"/>
+                                <field name="previous_credit_vat_account_id" attrs="{'required':[('previous_credit_vat_amount','!=',0)]}"/>
+                                <field name="previous_credit_vat_amount" nolabel="1"/>
+                                <separator colspan="3" string="Previous Debits VAT"/>
+                                <field name="previous_debit_vat_account_id" attrs="{'required':[('previous_debit_vat_amount','!=',0)]}"/>
+                                <field name="previous_debit_vat_amount" nolabel="1"/>
+                                <separator colspan="3" string="Other VAT Credits / Debits or Tax Compensations (Positive amounts for credits, negative for debits)"/>
+                                <field name="generic_vat_account_line_ids" colspan="3" nolabel="1">
+                                    <tree editable="bottom" string="Account Lines">
+                                        <field name="account_id" on_change="on_change_vat_account_id(account_id)"/>
+                                        <field name="amount" />
+                                   </tree>
+                                    <form editable="bottom">
+                                        <field name="account_id" />
+                                        <field name="amount" />
+                                   </form>
+                                </field>
+                            </group>
+                        </page>
+                        <page string="Tax Authority">
+                            <field name="authority_partner_id"  select="1" on_change="on_change_partner_id(authority_partner_id)"/>
+                            <newline/>
+                            <field name="authority_vat_account_id"  select="1" />
+                            <field name="authority_vat_amount" nolabel="1"/>
+                        </page>
+                    </notebook>
+                    <field name="state"  select="1"/>
+                    <button name="create_move" states="draft" string="Create Move"/>
+                    <button name="set_draft" states="confirmed,paid" string="Set to draft"/>
+               </form>
+            </field>
+        </record>
+        <record id="view_account_vat_period_end_statement_tree" model="ir.ui.view">
+            <field name="name">account.vat.period.end.statement.tree</field>
+            <field name="model">account.vat.period.end.statement</field>
+            <field name="type">tree</field>
+            <field name="arch" type="xml">
+                <tree string="Vat statement">
+                    <field name="period_id" />
+                    <field name="journal_id" />
+                    <field name="authority_vat_amount"   />
+                    <field name="state" />
+               </tree>
+            </field>
+        </record>
+
+        <record id="action_account_vat_period_end_statement" model="ir.actions.act_window">
+            <field name="name">Vat statement</field>
+            <field name="res_model">account.vat.period.end.statement</field>
+        </record>
+
+        <menuitem id="menu_account_vat_period_end_statement" action="action_account_vat_period_end_statement"
+            name="VAT statements" parent="account.menu_account_end_year_treatments"/>
+
+<!--    tax code   -->
+
+        <record id="view_tax_code_form" model="ir.ui.view">
+            <field name="name">account.tax.code.form</field>
+            <field name="model">account.tax.code</field>
+            <field name="inherit_id" ref="account.view_tax_code_form"></field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <separator string="Description" position="before">
+                    <group colspan="2" col="2">
+                        <separator string="VAT statement" colspan="4"/>
+                        <field name="vat_statement_account_id"/>
+                        <field name="vat_statement_type"/>
+                    </group>
+                </separator>
+            </field>
+        </record>
+
+    </data>
+</openerp>

=== added directory 'account_vat_period_end_statement/i18n'
=== added file 'account_vat_period_end_statement/i18n/account_vat_period_end_statement.pot'
--- account_vat_period_end_statement/i18n/account_vat_period_end_statement.pot	1970-01-01 00:00:00 +0000
+++ account_vat_period_end_statement/i18n/account_vat_period_end_statement.pot	2011-10-05 08:15:22 +0000
@@ -0,0 +1,379 @@
+# Translation of OpenERP Server.
+# This file contains the translation of the following modules:
+#	* account_vat_period_end_statement
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: OpenERP Server 6.0.3\n"
+"Report-Msgid-Bugs-To: [e-mail]\n"
+"POT-Creation-Date: 2011-09-10 08:34+0000\n"
+"PO-Revision-Date: 2011-09-10 08:34+0000\n"
+"Last-Translator: <>\n"
+"Language-Team: \n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: \n"
+"Plural-Forms: \n"
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,voucher_id:0
+msgid "VAT payment"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: selection:account.vat.period.end.statement,state:0
+msgid "Confirmed"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+msgid "Credit Account Lines"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: model:ir.model,name:account_vat_period_end_statement.model_statement_generic_account_line
+msgid "statement.generic.account.line"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: code:addons/account_vat_period_end_statement/account.py:225
+#, python-format
+msgid "Other VAT Credits / Debits"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: model:ir.model,name:account_vat_period_end_statement.model_account_tax_code
+msgid "Tax Code"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: model:ir.model,name:account_vat_period_end_statement.model_account_vat_period_end_statement
+msgid "account.vat.period.end.statement"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: report:addons/account_vat_period_end_statement/report/vat_period_end_statement.mako:18
+msgid "Payable VAT"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+#: field:account.vat.period.end.statement,previous_debit_vat_account_id:0
+#: code:addons/account_vat_period_end_statement/account.py:208
+#: report:addons/account_vat_period_end_statement/report/vat_period_end_statement.mako:58
+#, python-format
+msgid "Previous Debits VAT"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+msgid "Set to draft"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: help:account.vat.period.end.statement,previous_credit_vat_account_id:0
+msgid "Credit VAT from previous periods"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+msgid "Tax Authority"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,state:0
+msgid "State"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: selection:account.vat.period.end.statement,state:0
+msgid "Draft"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+msgid "Load chargeable VAT"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: selection:account.tax.code,vat_statement_type:0
+msgid "Debit"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: code:addons/account_vat_period_end_statement/account.py:241
+#, python-format
+msgid "Tax Authority VAT"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: model:ir.ui.menu,name:account_vat_period_end_statement.menu_account_vat_period_end_statement
+msgid "VAT statements"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: field:account.tax.code,vat_statement_type:0
+msgid "Type"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,previous_debit_vat_amount:0
+msgid "Previous Debits VAT Amount"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,credit_vat_account_line_ids:0
+#: code:addons/account_vat_period_end_statement/account.py:174
+#, python-format
+msgid "Credit VAT"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+msgid "Debit Account Lines"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,journal_id:0
+msgid "Journal"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,payable_vat_amount:0
+msgid "Payable VAT Amount"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: selection:account.vat.period.end.statement,state:0
+msgid "Paid"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: view:account.tax.code:0
+#: code:addons/account_vat_period_end_statement/account.py:147
+#: field:statement.credit.account.line,statement_id:0
+#: field:statement.debit.account.line,statement_id:0
+#: field:statement.generic.account.line,statement_id:0
+#, python-format
+msgid "VAT statement"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: model:ir.module.module,description:account_vat_period_end_statement.module_meta_information
+msgid "This module helps to register the VAT statement of period end. The 'VAT statement' object allows to specify every amount and relative account used by the statement.\n"
+"By default, the amounts of debit and credit taxes are automatically loaded from the tax codes of the selected period. Previous debit or credit is loaded from previous VAT statement.\n"
+"In order to load the correct amount from tax code, the tax code has to be associated to the account involved in the statement, through the tax code form.\n"
+"Confirming the statement, the account.move is created along with a draft payment voucher.\n"
+"\n"
+"Specification: http://wiki.openerp-italia.org/doku.php/moduli/vat_period_end_statement"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: model:ir.model,name:account_vat_period_end_statement.model_statement_credit_account_line
+msgid "statement.credit.account.line"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: code:addons/account_vat_period_end_statement/account.py:119
+#: code:addons/account_vat_period_end_statement/account.py:142
+#, python-format
+msgid "Error!"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,move_id:0
+msgid "VAT statement move"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: code:addons/account_vat_period_end_statement/account.py:119
+#, python-format
+msgid "You cannot delete a confirmed or paid statement"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: report:addons/account_vat_period_end_statement/report/vat_period_end_statement.mako:10
+#: model:ir.actions.report.xml,name:account_vat_period_end_statement.print_vat_period_end_statement
+msgid "VAT Statement Summary"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+msgid "Account Lines"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: field:statement.credit.account.line,account_id:0
+#: field:statement.debit.account.line,account_id:0
+#: field:statement.generic.account.line,account_id:0
+msgid "Account"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,generic_vat_account_line_ids:0
+msgid "Other VAT Credits / Debits or Tax Compensations"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: help:account.tax.code,vat_statement_type:0
+msgid "This establish whether amount will be loaded as debit or credit"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+#: field:account.vat.period.end.statement,previous_credit_vat_account_id:0
+#: code:addons/account_vat_period_end_statement/account.py:191
+#: report:addons/account_vat_period_end_statement/report/vat_period_end_statement.mako:54
+#, python-format
+msgid "Previous Credits VAT"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,authority_vat_account_id:0
+msgid "Tax Authority VAT Account"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: model:ir.module.module,shortdesc:account_vat_period_end_statement.module_meta_information
+msgid "Period End VAT Statement"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,previous_credit_vat_amount:0
+msgid "Previous Credits VAT Amount"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: field:account.tax.code,vat_statement_account_id:0
+msgid "Account used for VAT statement"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: model:ir.model,name:account_vat_period_end_statement.model_statement_debit_account_line
+msgid "statement.debit.account.line"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,deductible_vat_amount:0
+msgid "Deductible VAT Amount"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: report:addons/account_vat_period_end_statement/report/vat_period_end_statement.mako:15
+#: field:statement.credit.account.line,amount:0
+#: field:statement.debit.account.line,amount:0
+#: field:statement.generic.account.line,amount:0
+msgid "Amount"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: help:account.vat.period.end.statement,previous_debit_vat_account_id:0
+msgid "Debit VAT from previous periods"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: code:addons/account_vat_period_end_statement/account.py:142
+#, python-format
+msgid "The current period has VAT statement yet"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,authority_partner_id:0
+msgid "Tax Authority Partner"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: report:addons/account_vat_period_end_statement/report/vat_period_end_statement.mako:72
+msgid "Amount to pay"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+msgid "Load deductible VAT"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: view:account.tax.code:0
+msgid "Description"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+msgid "View chart of taxes for selected period"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: help:account.vat.period.end.statement,debit_vat_account_line_ids:0
+msgid "The accounts containing the debit VAT amount to write-off"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: constraint:account.tax.code:0
+msgid "Error ! You can not create recursive accounts."
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: selection:account.tax.code,vat_statement_type:0
+msgid "Credit"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+#: model:ir.actions.act_window,name:account_vat_period_end_statement.action_account_vat_period_end_statement
+msgid "Vat statement"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,debit_vat_account_line_ids:0
+#: code:addons/account_vat_period_end_statement/account.py:157
+#, python-format
+msgid "Debit VAT"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: model:ir.model,name:account_vat_period_end_statement.model_account_voucher
+msgid "Accounting Voucher"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,period_id:0
+#: report:addons/account_vat_period_end_statement/report/vat_period_end_statement.mako:11
+msgid "Period"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+msgid "General"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,authority_vat_amount:0
+msgid "Authority VAT Amount"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+msgid "Other VAT Credits / Debits or Tax Compensations (Positive amounts for credits, negative for debits)"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+msgid "Create Move"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: help:account.vat.period.end.statement,credit_vat_account_line_ids:0
+msgid "The accounts containing the credit VAT amount to write-off"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: report:addons/account_vat_period_end_statement/report/vat_period_end_statement.mako:28
+#: report:addons/account_vat_period_end_statement/report/vat_period_end_statement.mako:46
+msgid "Total"
+msgstr ""
+
+#. module: account_vat_period_end_statement
+#: report:addons/account_vat_period_end_statement/report/vat_period_end_statement.mako:36
+msgid "Deductible VAT"
+msgstr ""
+

=== added file 'account_vat_period_end_statement/i18n/it.po'
--- account_vat_period_end_statement/i18n/it.po	1970-01-01 00:00:00 +0000
+++ account_vat_period_end_statement/i18n/it.po	2011-10-05 08:15:22 +0000
@@ -0,0 +1,386 @@
+# Translation of OpenERP Server.
+# This file contains the translation of the following modules:
+#	* account_vat_period_end_statement
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: OpenERP Server 6.0.3\n"
+"Report-Msgid-Bugs-To: [e-mail]\n"
+"POT-Creation-Date: 2011-09-10 08:35+0000\n"
+"PO-Revision-Date: 2011-09-10 10:37+0100\n"
+"Last-Translator: Lorenzo Battistini <[e-mail]>\n"
+"Language-Team: \n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: 8bit\n"
+"Plural-Forms: \n"
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,voucher_id:0
+msgid "VAT payment"
+msgstr "Versamento IVA"
+
+#. module: account_vat_period_end_statement
+#: selection:account.vat.period.end.statement,state:0
+msgid "Confirmed"
+msgstr "Confermato"
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+msgid "Credit Account Lines"
+msgstr "Righe conti di credito"
+
+#. module: account_vat_period_end_statement
+#: model:ir.model,name:account_vat_period_end_statement.model_statement_generic_account_line
+msgid "statement.generic.account.line"
+msgstr "statement.generic.account.line"
+
+#. module: account_vat_period_end_statement
+#: code:addons/account_vat_period_end_statement/account.py:225
+#, python-format
+msgid "Other VAT Credits / Debits"
+msgstr "Altri Crediti / Debiti per IVA"
+
+#. module: account_vat_period_end_statement
+#: model:ir.model,name:account_vat_period_end_statement.model_account_tax_code
+msgid "Tax Code"
+msgstr "Codice imposta"
+
+#. module: account_vat_period_end_statement
+#: model:ir.model,name:account_vat_period_end_statement.model_account_vat_period_end_statement
+msgid "account.vat.period.end.statement"
+msgstr "account.vat.period.end.statement"
+
+#. module: account_vat_period_end_statement
+#: report:addons/account_vat_period_end_statement/report/vat_period_end_statement.mako:18
+msgid "Payable VAT"
+msgstr "IVA Esigibile"
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+#: field:account.vat.period.end.statement,previous_debit_vat_account_id:0
+#: code:addons/account_vat_period_end_statement/account.py:208
+#: report:addons/account_vat_period_end_statement/report/vat_period_end_statement.mako:58
+#, python-format
+msgid "Previous Debits VAT"
+msgstr "IVA debiti precedenti"
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+msgid "Set to draft"
+msgstr "Imposta a bozza"
+
+#. module: account_vat_period_end_statement
+#: help:account.vat.period.end.statement,previous_credit_vat_account_id:0
+msgid "Credit VAT from previous periods"
+msgstr "IVA a credito da periodi precedenti"
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+msgid "Tax Authority"
+msgstr "Erario"
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,state:0
+msgid "State"
+msgstr "Stato"
+
+#. module: account_vat_period_end_statement
+#: selection:account.vat.period.end.statement,state:0
+msgid "Draft"
+msgstr "Bozza"
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+msgid "Load chargeable VAT"
+msgstr "Carica IVA esigibile"
+
+#. module: account_vat_period_end_statement
+#: selection:account.tax.code,vat_statement_type:0
+msgid "Debit"
+msgstr "Debito"
+
+#. module: account_vat_period_end_statement
+#: code:addons/account_vat_period_end_statement/account.py:241
+#, python-format
+msgid "Tax Authority VAT"
+msgstr "IVA Erario"
+
+#. module: account_vat_period_end_statement
+#: model:ir.ui.menu,name:account_vat_period_end_statement.menu_account_vat_period_end_statement
+msgid "VAT statements"
+msgstr "Liquidazioni IVA"
+
+#. module: account_vat_period_end_statement
+#: field:account.tax.code,vat_statement_type:0
+msgid "Type"
+msgstr "Tipo"
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,previous_debit_vat_amount:0
+msgid "Previous Debits VAT Amount"
+msgstr "Importo IVA debiti precedenti"
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,credit_vat_account_line_ids:0
+#: code:addons/account_vat_period_end_statement/account.py:174
+#, python-format
+msgid "Credit VAT"
+msgstr "IVA a credito"
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+msgid "Debit Account Lines"
+msgstr "Righe conti di debito"
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,journal_id:0
+msgid "Journal"
+msgstr "Sezionale"
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,payable_vat_amount:0
+msgid "Payable VAT Amount"
+msgstr "Importo IVA Esigibile"
+
+#. module: account_vat_period_end_statement
+#: selection:account.vat.period.end.statement,state:0
+msgid "Paid"
+msgstr "Pagato"
+
+#. module: account_vat_period_end_statement
+#: view:account.tax.code:0
+#: code:addons/account_vat_period_end_statement/account.py:147
+#: field:statement.credit.account.line,statement_id:0
+#: field:statement.debit.account.line,statement_id:0
+#: field:statement.generic.account.line,statement_id:0
+#, python-format
+msgid "VAT statement"
+msgstr "Liquidazione IVA"
+
+#. module: account_vat_period_end_statement
+#: model:ir.module.module,description:account_vat_period_end_statement.module_meta_information
+msgid ""
+"This module helps to register the VAT statement of period end. The 'VAT statement' object allows to specify every amount and relative account used by the statement.\n"
+"By default, the amounts of debit and credit taxes are automatically loaded from the tax codes of the selected period. Previous debit or credit is loaded from previous VAT statement.\n"
+"In order to load the correct amount from tax code, the tax code has to be associated to the account involved in the statement, through the tax code form.\n"
+"Confirming the statement, the account.move is created along with a draft payment voucher.\n"
+"\n"
+"Specification: http://wiki.openerp-italia.org/doku.php/moduli/vat_period_end_statement"
+msgstr ""
+"This module helps to register the VAT statement of period end. The 'VAT statement' object allows to specify every amount and relative account used by the statement.\n"
+"By default, the amounts of debit and credit taxes are automatically loaded from the tax codes of the selected period. Previous debit or credit is loaded from previous VAT statement.\n"
+"In order to load the correct amount from tax code, the tax code has to be associated to the account involved in the statement, through the tax code form.\n"
+"Confirming the statement, the account.move is created along with a draft payment voucher.\n"
+"\n"
+"Specification: http://wiki.openerp-italia.org/doku.php/moduli/vat_period_end_statement"
+
+#. module: account_vat_period_end_statement
+#: model:ir.model,name:account_vat_period_end_statement.model_statement_credit_account_line
+msgid "statement.credit.account.line"
+msgstr "statement.credit.account.line"
+
+#. module: account_vat_period_end_statement
+#: code:addons/account_vat_period_end_statement/account.py:119
+#: code:addons/account_vat_period_end_statement/account.py:142
+#, python-format
+msgid "Error!"
+msgstr "Errore!"
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,move_id:0
+msgid "VAT statement move"
+msgstr "Movimento liquidazione IVA"
+
+#. module: account_vat_period_end_statement
+#: code:addons/account_vat_period_end_statement/account.py:119
+#, python-format
+msgid "You cannot delete a confirmed or paid statement"
+msgstr "Non è possibile eliminare una liquidazione confermata o pagata"
+
+#. module: account_vat_period_end_statement
+#: report:addons/account_vat_period_end_statement/report/vat_period_end_statement.mako:10
+#: model:ir.actions.report.xml,name:account_vat_period_end_statement.print_vat_period_end_statement
+msgid "VAT Statement Summary"
+msgstr "Prospetto liquidazione IVA"
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+msgid "Account Lines"
+msgstr "Righe conti"
+
+#. module: account_vat_period_end_statement
+#: field:statement.credit.account.line,account_id:0
+#: field:statement.debit.account.line,account_id:0
+#: field:statement.generic.account.line,account_id:0
+msgid "Account"
+msgstr "Conto"
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,generic_vat_account_line_ids:0
+msgid "Other VAT Credits / Debits or Tax Compensations"
+msgstr "Altri Crediti / Debiti per IVA o compensazioni di imposta"
+
+#. module: account_vat_period_end_statement
+#: help:account.tax.code,vat_statement_type:0
+msgid "This establish whether amount will be loaded as debit or credit"
+msgstr "Questo stabilisce se il saldo debba essere caricato come debito o come credito"
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+#: field:account.vat.period.end.statement,previous_credit_vat_account_id:0
+#: code:addons/account_vat_period_end_statement/account.py:191
+#: report:addons/account_vat_period_end_statement/report/vat_period_end_statement.mako:54
+#, python-format
+msgid "Previous Credits VAT"
+msgstr "IVA crediti precedenti"
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,authority_vat_account_id:0
+msgid "Tax Authority VAT Account"
+msgstr "Conto IVA Erario"
+
+#. module: account_vat_period_end_statement
+#: model:ir.module.module,shortdesc:account_vat_period_end_statement.module_meta_information
+msgid "Period End VAT Statement"
+msgstr "Liquidazione IVA di fine periodo"
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,previous_credit_vat_amount:0
+msgid "Previous Credits VAT Amount"
+msgstr "Importo IVA crediti precedenti"
+
+#. module: account_vat_period_end_statement
+#: field:account.tax.code,vat_statement_account_id:0
+msgid "Account used for VAT statement"
+msgstr "Conto utilizzato per la liquidazione IVA"
+
+#. module: account_vat_period_end_statement
+#: model:ir.model,name:account_vat_period_end_statement.model_statement_debit_account_line
+msgid "statement.debit.account.line"
+msgstr "statement.debit.account.line"
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,deductible_vat_amount:0
+msgid "Deductible VAT Amount"
+msgstr "Importo IVA Deducibile"
+
+#. module: account_vat_period_end_statement
+#: report:addons/account_vat_period_end_statement/report/vat_period_end_statement.mako:15
+#: field:statement.credit.account.line,amount:0
+#: field:statement.debit.account.line,amount:0
+#: field:statement.generic.account.line,amount:0
+msgid "Amount"
+msgstr "Importo"
+
+#. module: account_vat_period_end_statement
+#: help:account.vat.period.end.statement,previous_debit_vat_account_id:0
+msgid "Debit VAT from previous periods"
+msgstr "IVA a debito da periodi precedenti"
+
+#. module: account_vat_period_end_statement
+#: code:addons/account_vat_period_end_statement/account.py:142
+#, python-format
+msgid "The current period has VAT statement yet"
+msgstr "Il periodo selezionato ha già una dichiarazione IVA"
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,authority_partner_id:0
+msgid "Tax Authority Partner"
+msgstr "Partner Erario"
+
+#. module: account_vat_period_end_statement
+#: report:addons/account_vat_period_end_statement/report/vat_period_end_statement.mako:72
+msgid "Amount to pay"
+msgstr "Totale da pagare"
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+msgid "Load deductible VAT"
+msgstr "Carica IVA detraibile"
+
+#. module: account_vat_period_end_statement
+#: view:account.tax.code:0
+msgid "Description"
+msgstr "Descrizione"
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+msgid "View chart of taxes for selected period"
+msgstr "Visualizza i conti imposta per il periodo selezionato"
+
+#. module: account_vat_period_end_statement
+#: help:account.vat.period.end.statement,debit_vat_account_line_ids:0
+msgid "The accounts containing the debit VAT amount to write-off"
+msgstr "I conti contenenti l'IVA a debito da stornare"
+
+#. module: account_vat_period_end_statement
+#: constraint:account.tax.code:0
+msgid "Error ! You can not create recursive accounts."
+msgstr "Errore! Non puoi creare conti ricorsivi"
+
+#. module: account_vat_period_end_statement
+#: selection:account.tax.code,vat_statement_type:0
+msgid "Credit"
+msgstr "Credito"
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+#: model:ir.actions.act_window,name:account_vat_period_end_statement.action_account_vat_period_end_statement
+msgid "Vat statement"
+msgstr "Liquidazione IVA"
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,debit_vat_account_line_ids:0
+#: code:addons/account_vat_period_end_statement/account.py:157
+#, python-format
+msgid "Debit VAT"
+msgstr "IVA a debito"
+
+#. module: account_vat_period_end_statement
+#: model:ir.model,name:account_vat_period_end_statement.model_account_voucher
+msgid "Accounting Voucher"
+msgstr "Voucher contabile"
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,period_id:0
+#: report:addons/account_vat_period_end_statement/report/vat_period_end_statement.mako:11
+msgid "Period"
+msgstr "Periodo"
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+msgid "General"
+msgstr "Generale"
+
+#. module: account_vat_period_end_statement
+#: field:account.vat.period.end.statement,authority_vat_amount:0
+msgid "Authority VAT Amount"
+msgstr "Importo IVA Erario"
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+msgid "Other VAT Credits / Debits or Tax Compensations (Positive amounts for credits, negative for debits)"
+msgstr "Altri crediti / debiti per IVA o compensazioni di imposta (importi positivi per i crediti, negativi per i debiti)"
+
+#. module: account_vat_period_end_statement
+#: view:account.vat.period.end.statement:0
+msgid "Create Move"
+msgstr "Crea movimento"
+
+#. module: account_vat_period_end_statement
+#: help:account.vat.period.end.statement,credit_vat_account_line_ids:0
+msgid "The accounts containing the credit VAT amount to write-off"
+msgstr "I conti contenenti l'IVA a credito da stornare"
+
+#. module: account_vat_period_end_statement
+#: report:addons/account_vat_period_end_statement/report/vat_period_end_statement.mako:28
+#: report:addons/account_vat_period_end_statement/report/vat_period_end_statement.mako:46
+msgid "Total"
+msgstr "Totale"
+
+#. module: account_vat_period_end_statement
+#: report:addons/account_vat_period_end_statement/report/vat_period_end_statement.mako:36
+msgid "Deductible VAT"
+msgstr "IVA Deducibile"
+

=== added directory 'account_vat_period_end_statement/report'
=== added file 'account_vat_period_end_statement/report/__init__.py'
--- account_vat_period_end_statement/report/__init__.py	1970-01-01 00:00:00 +0000
+++ account_vat_period_end_statement/report/__init__.py	2011-10-05 08:15:22 +0000
@@ -0,0 +1,21 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2011 Domsense s.r.l. (<http://www.domsense.com>).
+#
+#    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 vat_period_end_statement

=== added file 'account_vat_period_end_statement/report/vat_period_end_statement.mako'
--- account_vat_period_end_statement/report/vat_period_end_statement.mako	1970-01-01 00:00:00 +0000
+++ account_vat_period_end_statement/report/vat_period_end_statement.mako	2011-10-05 08:15:22 +0000
@@ -0,0 +1,78 @@
+<html>
+<head>
+    <style type="text/css">
+        ${css}
+    </style>
+</head>
+<body>
+<% setLang(company.partner_id.lang) %>
+% for statement in objects:
+<h1>${_("VAT Statement Summary")} </h1>
+<h2>${_("Period")}: ${statement.period_id.name|entity}</h2>
+<table class="list_table"  width="90%">
+    <tr>
+        <th></th>
+        <th> ${ _('Amount') }</th>
+    </tr>
+    <tr style="page-break-inside: avoid; vertical-align:text-top;">
+        <td><strong>${_("Payable VAT")}</strong></td>
+        <td></td>
+    </tr>
+    %for debit_line in statement.debit_vat_account_line_ids :
+        <tr style="page-break-inside: avoid; vertical-align:text-top;">
+            <td>${ debit_line.account_id.name|entity }</td>
+            <td>${ debit_line.amount|entity }</td>
+        </tr>
+    %endfor
+    <tr style="page-break-inside: avoid; vertical-align:text-top;">
+        <td>${_("Total")}</td>
+        <td>${ statement.payable_vat_amount|entity }</td>
+    </tr>
+    <tr style="page-break-inside: avoid; vertical-align:text-top;">
+        <td></td>
+        <td></td>
+    </tr>
+    <tr style="page-break-inside: avoid; vertical-align:text-top;">
+        <td><strong>${_("Deductible VAT")}</strong></td>
+        <td></td>
+    </tr>
+    %for credit_line in statement.credit_vat_account_line_ids :
+        <tr style="page-break-inside: avoid; vertical-align:text-top;">
+            <td>${ credit_line.account_id.name|entity }</td>
+            <td>${ credit_line.amount|entity }</td>
+        </tr>
+    %endfor
+    <tr style="page-break-inside: avoid; vertical-align:text-top;">
+        <td>${_("Total")}</td>
+        <td>${ statement.deductible_vat_amount|entity }</td>
+    </tr>
+    <tr style="page-break-inside: avoid; vertical-align:text-top;">
+        <td></td>
+        <td></td>
+    </tr>
+    <tr style="page-break-inside: avoid; vertical-align:text-top;">
+        <td>${_("Previous Credits VAT")}</td>
+        <td>${ statement.previous_credit_vat_amount|entity }</td>
+    </tr>
+    <tr style="page-break-inside: avoid; vertical-align:text-top;">
+        <td>${_("Previous Debits VAT")}</td>
+        <td>${ statement.previous_debit_vat_amount|entity }</td>
+    </tr>
+    %for generic_line in statement.generic_vat_account_line_ids :
+        <tr style="page-break-inside: avoid; vertical-align:text-top;">
+            <td>${ generic_line.account_id.name|entity }</td>
+            <td>${ generic_line.amount|entity }</td>
+        </tr>
+    %endfor
+    <tr style="page-break-inside: avoid; vertical-align:text-top;">
+        <td></td>
+        <td></td>
+    </tr>
+    <tr style="page-break-inside: avoid; vertical-align:text-top;">
+        <td><strong>${_("Amount to pay")}</strong></td>
+        <td><strong>${ statement.authority_vat_amount|entity }</strong></td>
+    </tr>
+</table>
+%endfor
+</body>
+</html>

=== added file 'account_vat_period_end_statement/report/vat_period_end_statement.py'
--- account_vat_period_end_statement/report/vat_period_end_statement.py	1970-01-01 00:00:00 +0000
+++ account_vat_period_end_statement/report/vat_period_end_statement.py	2011-10-05 08:15:22 +0000
@@ -0,0 +1,43 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2011 Domsense s.r.l. (<http://www.domsense.com>).
+#
+#    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 report import report_sxw
+
+class print_vat_period_end_statement(report_sxw.rml_parse):
+    _name = 'parser.vat.period.end.statement'
+
+    def __init__(self, cr, uid, name, context=None):
+        if context is None:
+            context = {}
+        super(print_vat_period_end_statement, self).__init__(cr, uid, name, context=context)
+        self.localcontext.update( {
+            'time': time,
+        })
+        self.context = context
+
+report_sxw.report_sxw('report.account.print.vat.period.end.statement',
+                      'account.vat.period.end.statement',
+                      'addons/account_vat_period_end_statement/report/vat_period_end_statement.mako',
+                      parser=print_vat_period_end_statement)
+
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'account_vat_period_end_statement/reports.xml'
--- account_vat_period_end_statement/reports.xml	1970-01-01 00:00:00 +0000
+++ account_vat_period_end_statement/reports.xml	2011-10-05 08:15:22 +0000
@@ -0,0 +1,16 @@
+<?xml version="1.0"?>
+<openerp>
+    <data>
+
+        <report
+            auto="False"
+            id="print_vat_period_end_statement"
+            model="account.vat.period.end.statement"
+            name="account.print.vat.period.end.statement"
+            file="account_vat_period_end_statement/report/vat_period_end_statement.mako"
+            string="VAT Statement Summary"
+            report_type="webkit" />
+
+    </data>
+</openerp>
+

=== added directory 'account_vat_period_end_statement/security'
=== added file 'account_vat_period_end_statement/security/ir.model.access.csv'
--- account_vat_period_end_statement/security/ir.model.access.csv	1970-01-01 00:00:00 +0000
+++ account_vat_period_end_statement/security/ir.model.access.csv	2011-10-05 08:15:22 +0000
@@ -0,0 +1,9 @@
+"id","name","model_id:id","group_id:id","perm_read","perm_write","perm_create","perm_unlink"
+"access_account_vat_period_end_statement_accountant","access_account_vat_period_end_statement_accountant","model_account_vat_period_end_statement","account.group_account_user","1","1","1","1"
+"access_account_vat_period_end_statement_manager","access_account_vat_period_end_statement_manager","model_account_vat_period_end_statement","account.group_account_manager","1","1","1","1"
+"access_statement_debit_account_line_accountant","access_statement_debit_account_line_accountant","model_statement_debit_account_line","account.group_account_user","1","1","1","1"
+"access_statement_debit_account_line_manager","access_statement_debit_account_line_manager","model_statement_debit_account_line","account.group_account_manager","1","1","1","1"
+"access_statement_credit_account_line_accountant","access_statement_credit_account_line_accountant","model_statement_credit_account_line","account.group_account_user","1","1","1","1"
+"access_statement_credit_account_line_manager","access_statement_credit_account_line_manager","model_statement_credit_account_line","account.group_account_manager","1","1","1","1"
+"access_statement_generic_account_line_accountant","access_statement_generic_account_line_accountant","model_statement_generic_account_line","account.group_account_user","1","1","1","1"
+"access_statement_generic_account_line_manager","access_statement_generic_account_line_manager","model_statement_generic_account_line","account.group_account_manager","1","1","1","1"

=== added file 'account_vat_period_end_statement/statement_workflow.xml'
--- account_vat_period_end_statement/statement_workflow.xml	1970-01-01 00:00:00 +0000
+++ account_vat_period_end_statement/statement_workflow.xml	2011-10-05 08:15:22 +0000
@@ -0,0 +1,58 @@
+<?xml version="1.0"?>
+<openerp>
+    <data>
+        <record model="workflow" id="wkf_vat_period_end_statement">
+            <field name="name">workflow.vat.period.end.statement</field>
+            <field name="osv">account.vat.period.end.statement</field>
+            <field name="on_create">True</field>
+        </record>
+
+        <record model="workflow.activity" id="act_draft">
+            <field name="wkf_id" ref="wkf_vat_period_end_statement" />
+            <field name="flow_start">True</field>
+            <field name="name">draft</field>
+            <field name="kind">function</field>
+            <field name="action">statement_draft()</field>
+        </record>
+
+        <record model="workflow.activity" id="act_move_created">
+            <field name="wkf_id" ref="wkf_vat_period_end_statement" />
+            <field name="name">created</field>
+            <field name="kind">function</field>
+            <field name="action">create_move()</field>
+        </record>
+
+        <record model="workflow.activity" id="act_statement_paid">
+            <field name="wkf_id" ref="wkf_vat_period_end_statement" />
+            <field name="name">paid</field>
+            <field name="kind">function</field>
+            <field name="action">statement_paid()</field>
+<!--            <field name="flow_stop">True</field>    -->
+        </record>
+
+        <record model="workflow.transition" id="t1">
+            <field name="act_from" ref="act_draft" />
+            <field name="act_to" ref="act_move_created" />
+            <field name="signal">create_move</field>
+        </record>
+
+        <record model="workflow.transition" id="t2">
+            <field name="act_to" ref="act_draft" />
+            <field name="act_from" ref="act_move_created" />
+            <field name="signal">set_draft</field>
+        </record>
+
+        <record model="workflow.transition" id="t3">
+            <field name="act_to" ref="act_statement_paid" />
+            <field name="act_from" ref="act_move_created" />
+            <field name="signal">set_paid</field>
+        </record>
+
+        <record model="workflow.transition" id="t4">
+            <field name="act_to" ref="act_draft" />
+            <field name="act_from" ref="act_statement_paid" />
+            <field name="signal">set_draft</field>
+        </record>
+
+    </data>
+</openerp>