Merge lp:~domsense/domsense-agilebg-addons/adding_account_multiple_currency into lp:domsense-agilebg-addons/6.1

[Lorenzo Battistini]

[lp:~domsense/domsense-agilebg-addons/adding_account_multiple_currency]

137. By Lorenzo Battistini on 2012-02-21

[FIX] authors

138. By Lorenzo Battistini on 2012-02-21

[MERGE] from parent

139. By Lorenzo Battistini on 2012-02-21

[MERGE] from parent

=== added directory 'account_parallel_currency'
=== added file 'account_parallel_currency/AUTHORS.txt'
--- account_parallel_currency/AUTHORS.txt	1970-01-01 00:00:00 +0000
+++ account_parallel_currency/AUTHORS.txt	2012-02-21 09:16:36 +0000
@@ -0,0 +1,1 @@
+Lorenzo Battistini <[e-mail]>

=== added file 'account_parallel_currency/__init__.py'
--- account_parallel_currency/__init__.py	1970-01-01 00:00:00 +0000
+++ account_parallel_currency/__init__.py	2012-02-21 09:16:36 +0000
@@ -0,0 +1,22 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#    
+#    Copyright (C) 2012 Agile Business Group sagl (<http://www.agilebg.com>)
+#    Copyright (C) 2012 Domsense srl (<http://www.domsense.com>)
+#    All Rights Reserved
+#
+#    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 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

=== added file 'account_parallel_currency/__openerp__.py'
--- account_parallel_currency/__openerp__.py	1970-01-01 00:00:00 +0000
+++ account_parallel_currency/__openerp__.py	2012-02-21 09:16:36 +0000
@@ -0,0 +1,45 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#    
+#    Copyright (C) 2012 Agile Business Group sagl (<http://www.agilebg.com>)
+#    Copyright (C) 2012 Domsense srl (<http://www.domsense.com>)
+#    All Rights Reserved
+#
+#    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 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 Parallel Currency",
+    'version': '0.1',
+    'category': 'Generic Modules/Accounting',
+    'description': """
+    This module handles parallel accounting entries based on different currencies.
+    It is useful for companies who have to manage accounting with more than one currency at the same time. For instance, companies who have to produce balances on different currencies.
+    
+    In order to use the module, you have to define one company for each parallel chart of accounts. Then you have to map parallel accounts and parallel journals through the related forms.
+    
+    When posting new journal entries, the system checks the configured parallel accounts and automatically generates the parallel entries.
+    """,
+    'author': 'Agile Business Group & Domsense',
+    'website': 'http://www.agilebg.com',
+    'license': 'AGPL-3',
+    "depends" : ['account'],
+    "init_xml" : [],
+    "update_xml" : [
+        'account_view.xml',
+        ],
+    "demo_xml" : [],
+    "active": False,
+    "installable": True
+}

=== added file 'account_parallel_currency/account.py'
--- account_parallel_currency/account.py	1970-01-01 00:00:00 +0000
+++ account_parallel_currency/account.py	2012-02-21 09:16:36 +0000
@@ -0,0 +1,188 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#    
+#    Copyright (C) 2012 Agile Business Group sagl (<http://www.agilebg.com>)
+#    Copyright (C) 2012 Domsense srl (<http://www.domsense.com>)
+#    All Rights Reserved
+#
+#    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 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 time
+
+class account_account(osv.osv):
+    _inherit = "account.account"
+    
+    _columns = {
+        'parallel_account_ids': fields.many2many('account.account', 'parallel_account_rel', 'child_id',
+            'parent_id', 'Parallel Currency Accounts', Help="Set here the accounts you want to automatically move when registering entries in this account"),
+        'master_parallel_account_ids': fields.many2many('account.account', 'parallel_account_rel', 'parent_id',
+            'child_id', 'Master Parallel Currency Accounts', Help="You can see here the accounts that automatically move this account", readonly=True),
+        }
+    
+account_account()
+
+class account_move_line(osv.osv):
+    _inherit = "account.move.line"
+    
+account_move_line()
+
+#and tax codes?
+class account_move(osv.osv):
+    _inherit = "account.move"
+    
+    _columns = {
+        'parallel_move_ids': fields.one2many('account.move', 'master_parallel_move_id', 'Parallel Entries',
+            readonly=True),
+        'master_parallel_move_id': fields.many2one('account.move', 'Master Parallel Entry'),
+        }
+    
+    def button_cancel(self, cr, uid, ids, context=None):
+        res = super(account_move, self).button_cancel(cr, uid, ids, context=context)
+        for move in self.browse(cr, uid, ids, context=context):
+            for parallel_move in move.parallel_move_ids:
+                parallel_move.button_cancel(context=context)
+                parallel_move.unlink(context=context)
+        return res
+
+    def post(self, cr, uid, ids, context=None):
+        res = super(account_move, self).post(cr, uid, ids, context=context)
+        if context is None:
+            context = {}
+        curr_pool = self.pool.get('res.currency')
+        for move in self.browse(cr, uid, ids, context=context):
+            if move.state == 'posted':
+                new_move_lines = []
+                parallel_data = {}
+                for line in move.line_id:
+                    for parallel_account in line.account_id.parallel_account_ids:
+                        parallel_data[parallel_account.company_id.id] = {}
+                        parallel_data[parallel_account.company_id.id]['move_name'] = line.move_id.name
+                        parallel_data[parallel_account.company_id.id]['ref'] = line.move_id.ref
+                        parallel_data[parallel_account.company_id.id]['date'] = line.date
+                        parallel_data[parallel_account.company_id.id]['move_id'] = line.move_id.id
+                            
+                        # search period by move date and parallel company
+                        period_ids = self.pool.get('account.period').search(cr, uid, [
+                            ('date_start','<=',line.date),
+                            ('date_stop','>=',line.date ),
+                            ('company_id', '=', parallel_account.company_id.id)])
+                            
+                        if len(period_ids) == 0:
+                            raise osv.except_osv(_('Error !'), _('Period %s does not exist in company %s !')
+                                % (line.date, parallel_account.company_id.name))
+                        if len(period_ids) > 1:
+                            raise osv.except_osv(_('Error !'), _('Too many periods %s for company %s !')
+                                % (line.date, parallel_account.company_id.name))
+                        
+                        parallel_data[parallel_account.company_id.id]['period_id'] = period_ids[0]
+                        
+                        # search parallel journals for the parallel company
+                        parallel_journal_ids = []
+                        for journal in line.journal_id.parallel_journal_ids:
+                            if journal.company_id.id == parallel_account.company_id.id:
+                                parallel_journal_ids.append(journal.id)
+                        
+                        if len(parallel_journal_ids) == 0:
+                            raise osv.except_osv(_('Error !'), _('Journal %s does not exist in company %s !')
+                                % (line.journal_id.name, parallel_account.company_id.name))
+                        if len(parallel_journal_ids) > 1:
+                            raise osv.except_osv(_('Error !'), _('Too many journals %s for company %s !')
+                                % (line.journal_id.name, parallel_account.company_id.name))
+                        
+                        parallel_data[parallel_account.company_id.id]['journal_id'] = parallel_journal_ids[0]
+
+                        new_line_values = {
+                            'name': line.name,
+                            'date_maturity': line.date_maturity or False,
+                            'account_id': parallel_account.id,
+                            'period_id': period_ids[0],
+                            'journal_id': parallel_journal_ids[0],
+                            'company_id': parallel_account.company_id.id,
+                            'partner_id': line.partner_id and line.partner_id.id or False,
+                            }
+
+                        if line.currency_id and line.amount_currency:
+                            parallel_sec_curr_iso_code = line.currency_id.name
+                            amount = line.amount_currency
+                        else:
+                            parallel_sec_curr_iso_code = line.company_id.currency_id.name
+                            amount = line.debit or ( - line.credit)
+                            
+                        # search parallel currency by ISO code and parallel company
+                        parallel_secondary_curr_ids = curr_pool.search(cr, uid, [
+                            ('name', '=', parallel_sec_curr_iso_code),
+                            ('company_id', '=', parallel_account.company_id.id),
+                            ], context=context)
+                            
+                        if len(parallel_secondary_curr_ids) == 0:
+                            raise osv.except_osv(_('Error !'), _('Currency %s does not exist in company %s !')
+                                % (parallel_sec_curr_iso_code, parallel_account.company_id.name))
+                        if len(parallel_secondary_curr_ids) > 1:
+                            raise osv.except_osv(_('Error !'), _('Too many currencies %s for company %s !')
+                                % (parallel_sec_curr_iso_code, parallel_account.company_id.name))
+                        
+                        # compute parallel base amount from document currency, using move date
+                        context.update({'date': line.date})
+                        parallel_base_amount = curr_pool.compute(cr, uid, parallel_secondary_curr_ids[0],
+                            parallel_account.company_id.currency_id.id, amount,
+                            context=context)
+                            
+                        new_line_values['amount_currency'] = amount or False
+                        new_line_values['currency_id'] = parallel_secondary_curr_ids[0]
+                        new_line_values['debit'] = 0.0
+                        new_line_values['credit'] = 0.0
+                        if parallel_base_amount > 0:
+                            new_line_values['debit'] = abs(parallel_base_amount)
+                        elif parallel_base_amount < 0:
+                            new_line_values['credit'] = abs(parallel_base_amount)
+                        
+                        new_move_lines.append((parallel_account.company_id.id, (0,0,new_line_values)))
+                        #parallel_data[parallel_account.company_id.id]['move_lines'].append((0,0,new_line_values))
+                        
+                for company_id in parallel_data:
+                    move_lines = []
+                    for new_move_line in new_move_lines:
+                        if new_move_line[0] == company_id:
+                            move_lines.append(new_move_line[1])
+                    move_values = {
+                        'name': parallel_data[company_id]['move_name'],
+                        'period_id': parallel_data[company_id]['period_id'],
+                        'journal_id': parallel_data[company_id]['journal_id'],
+                        'date': parallel_data[company_id]['date'],
+                        'company_id': company_id,
+                        'line_id': move_lines,
+                        'master_parallel_move_id': parallel_data[company_id]['move_id'],
+                        'ref': parallel_data[company_id]['ref'],
+                        }
+                    move_id = self.create(cr, uid, move_values, context=context)
+                    self.post(cr, uid, [move_id], context=context)
+                
+        return res
+
+account_move()
+
+class account_journal(osv.osv):
+    _inherit = "account.journal"
+    
+    _columns = {
+        'parallel_journal_ids': fields.many2many('account.journal', 'parallel_journal_rel', 'child_id',
+            'parent_id', 'Parallel Currency Journals', Help="Set here the journals you want to automatically move when registering entries in this journal"),
+        'master_parallel_journal_ids': fields.many2many('account.journal', 'parallel_journal_rel', 'parent_id',
+            'child_id', 'Master Parallel Currency Journals', Help="You can see here the journals that automatically move this journal", readonly=True),
+        }
+account_journal()

=== added file 'account_parallel_currency/account_view.xml'
--- account_parallel_currency/account_view.xml	1970-01-01 00:00:00 +0000
+++ account_parallel_currency/account_view.xml	2012-02-21 09:16:36 +0000
@@ -0,0 +1,50 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+        <record id="view_account_form" model="ir.ui.view">
+            <field name="name">account.account.form</field>
+            <field name="model">account.account</field>
+            <field name="type">form</field>
+            <field name="inherit_id" ref="account.view_account_form"></field>
+            <field name="arch" type="xml">
+                <page string="Notes" position="after">
+                    <page string="Parallel Currency">
+                        <separator string="Parallel Currency Accounts" colspan="4"/>
+                        <field colspan="4" name="parallel_account_ids" nolabel="1" domain="[('company_id', '!=', company_id)]"/>
+                        <separator string="Master Parallel Currency Accounts" colspan="4"/>
+                        <field colspan="4" name="master_parallel_account_ids" nolabel="1"/>
+                    </page>
+                </page>
+            </field>
+        </record>
+        <record id="view_account_journal_form" model="ir.ui.view">
+            <field name="name">view_account_journal_form</field>
+            <field name="model">account.journal</field>
+            <field name="type">form</field>
+            <field name="inherit_id" ref="account.view_account_journal_form"></field>
+            <field name="arch" type="xml">
+                <page string="Entry Controls" position="after">
+                    <page string="Parallel Currency">
+                        <separator string="Parallel Currency Journals" colspan="4"/>
+                        <field colspan="4" name="parallel_journal_ids" nolabel="1" domain="[('company_id', '!=', company_id)]"/>
+                        <separator string="Master Parallel Currency Journals" colspan="4"/>
+                        <field colspan="4" name="master_parallel_journal_ids" nolabel="1"/>
+                    </page>
+                </page>
+            </field>
+        </record>
+        <record id="view_move_form" model="ir.ui.view">
+            <field name="name">view_move_form</field>
+            <field name="model">account.move</field>
+            <field name="type">form</field>
+            <field name="inherit_id" ref="account.view_move_form"></field>
+            <field name="arch" type="xml">
+                <page string="Journal Items" position="after">
+                    <page string="Parallel Entries">
+                        <field colspan="4" name="parallel_move_ids" nolabel="1" />
+                    </page>
+                </page>
+            </field>
+        </record>
+    </data>
+</openerp>

=== added directory 'account_parallel_currency/i18n'