summaryrefslogtreecommitdiff
path: root/addons
diff options
context:
space:
mode:
authorqdp-odoo <qdp@odoo.com>2015-08-19 15:44:49 +0200
committerqdp-odoo <qdp@odoo.com>2015-08-19 15:44:59 +0200
commit6cb6f43c2beffaccd871ac93f19e11aeeb92d131 (patch)
tree94d062f1160c8f80621ec0e9c1b39ad02aef1a3c /addons
parent256e5bd23a5b6f792fc35381413ef948b24e1dc7 (diff)
[REF] base: simplified res.partner.bank and res.bank objects for a greater usability + [IMP] account: bank journals are now the bank accounts of a company
Diffstat (limited to 'addons')
-rw-r--r--addons/account/__openerp__.py2
-rw-r--r--addons/account/models/__init__.py1
-rw-r--r--addons/account/models/account.py116
-rw-r--r--addons/account/models/account_bank.py44
-rw-r--r--addons/account/models/account_journal_dashboard.py22
-rw-r--r--addons/account/models/chart_template.py41
-rw-r--r--addons/account/models/company.py2
-rw-r--r--addons/account/models/res_config.py11
-rw-r--r--addons/account/report/inherited_layouts.xml22
-rw-r--r--addons/account/static/src/less/account_journal_dashboard.less4
-rw-r--r--addons/account/test/account_bank_statement.yml7
-rw-r--r--addons/account/test/account_minimal_test.xml14
-rw-r--r--addons/account/tests/test_account_customer_invoice.py6
-rw-r--r--addons/account/tests/test_payment.py8
-rw-r--r--addons/account/tests/test_reconciliation.py10
-rw-r--r--addons/account/views/account_bank_view.xml62
-rw-r--r--addons/account/views/account_journal_dashboard_view.xml42
-rw-r--r--addons/account/views/account_view.xml72
-rw-r--r--addons/account/views/res_config_view.xml2
-rw-r--r--addons/account_bank_statement_import/__init__.py1
-rw-r--r--addons/account_bank_statement_import/account_bank_statement_import.py86
-rw-r--r--addons/account_bank_statement_import/account_bank_statement_import_view.xml18
-rw-r--r--addons/account_bank_statement_import/account_journal.py21
-rw-r--r--addons/account_bank_statement_import/demo/partner_bank.xml20
-rw-r--r--addons/account_bank_statement_import/wizard/journal_creation.py35
-rw-r--r--addons/account_bank_statement_import/wizard/journal_creation.xml14
-rw-r--r--addons/base_iban/__openerp__.py3
-rw-r--r--addons/base_iban/base_iban.py37
-rw-r--r--addons/base_iban/base_iban_data.xml32
-rw-r--r--addons/base_iban/base_iban_view.xml6
-rw-r--r--addons/base_iban/demo/iban_demo.xml15
-rw-r--r--addons/crm/security/ir.model.access.csv1
-rw-r--r--addons/hr_payroll_account/test/hr_payroll_account.yml4
-rw-r--r--addons/l10n_in_hr_payroll/l10n_in_hr_payroll.py2
-rw-r--r--addons/l10n_in_hr_payroll/test/payment_advice_batch.yml4
-rw-r--r--addons/l10n_in_hr_payroll/views/report_payrolladvice.xml4
-rw-r--r--addons/membership/tests/test_membership.py4
-rw-r--r--addons/payment_transfer/models/payment_acquirer.py6
-rw-r--r--addons/purchase/tests/test_purchase_to_invoice.py2
-rw-r--r--addons/report/views/layouts.xml10
-rw-r--r--addons/sale/security/ir.model.access.csv2
-rw-r--r--addons/sale/tests/test_sale_to_invoice.py3
-rw-r--r--addons/stock_dropshipping/tests/test_invoicing.py2
43 files changed, 390 insertions, 430 deletions
diff --git a/addons/account/__openerp__.py b/addons/account/__openerp__.py
index b1592ba5bec..f5322dc2a2c 100644
--- a/addons/account/__openerp__.py
+++ b/addons/account/__openerp__.py
@@ -41,12 +41,12 @@ You could use this simplified accounting in case you work with an (external) acc
'views/product_view.xml',
'views/account_analytic_view.xml',
'views/company_view.xml',
- 'views/account_bank_view.xml',
'views/res_config_view.xml',
'views/account_tip_data.xml',
'views/account.xml',
'views/report_invoice.xml',
'report/account_invoice_report_view.xml',
+ 'report/inherited_layouts.xml',
'views/account_journal_dashboard_view.xml',
],
'demo': [
diff --git a/addons/account/models/__init__.py b/addons/account/models/__init__.py
index a31840bb76e..b4855fb482f 100644
--- a/addons/account/models/__init__.py
+++ b/addons/account/models/__init__.py
@@ -5,7 +5,6 @@ import account
import account_payment
import account_invoice
import account_bank_statement
-import account_bank
import account_move
import chart_template
import account_analytic_line
diff --git a/addons/account/models/account.py b/addons/account/models/account.py
index f3a1228b58d..95e1f061165 100644
--- a/addons/account/models/account.py
+++ b/addons/account/models/account.py
@@ -6,7 +6,7 @@ import math
from openerp.osv import expression
from openerp.tools.float_utils import float_round as round
from openerp.tools import DEFAULT_SERVER_DATETIME_FORMAT
-from openerp.exceptions import UserError
+from openerp.exceptions import UserError, ValidationError
from openerp import api, fields, models, _
@@ -189,7 +189,7 @@ class AccountJournal(models.Model):
return self.env.ref('account.account_payment_method_manual_out')
name = fields.Char(string='Journal Name', required=True)
- code = fields.Char(string='Sequence Prefix', size=5, required=True, help="The journal entries of this journal will be named using this prefix.")
+ code = fields.Char(string='Short Code', size=5, required=True, help="The journal entries of this journal will be named using this prefix.")
type = fields.Selection([
('sale', 'Sale'),
('purchase', 'Purchase'),
@@ -240,6 +240,13 @@ class AccountJournal(models.Model):
profit_account_id = fields.Many2one('account.account', string='Profit Account', domain=[('deprecated', '=', False)], help="Used to register a profit when the ending balance of a cash register differs from what the system computes")
loss_account_id = fields.Many2one('account.account', string='Loss Account', domain=[('deprecated', '=', False)], help="Used to register a loss when the ending balance of a cash register differs from what the system computes")
+ # Bank journals fields
+ bank_account_id = fields.Many2one('res.partner.bank', string="Bank Account", ondelete='restrict')
+ display_on_footer = fields.Boolean("Show in Invoices Footer", help="Display this bank account on the footer of printed documents like invoices and sales orders.")
+ bank_statements_source = fields.Selection([('manual', 'Record Manually')], string='Bank Feeds')
+ bank_acc_number = fields.Char(related='bank_account_id.acc_number')
+ bank_id = fields.Many2one('res.bank', related='bank_account_id.bank_id')
+
_sql_constraints = [
('code_company_uniq', 'unique (code, name, company_id)', 'The code and name of the journal must be unique per company !'),
]
@@ -253,6 +260,17 @@ class AccountJournal(models.Model):
if self.default_debit_account_id and not self.default_debit_account_id.currency_id.id == self.currency_id.id:
raise UserError(_('Configuration error!\nThe currency of the journal should be the same than the default debit account.'))
+ @api.one
+ @api.constrains('type', 'bank_account_id')
+ def _check_bank_account(self):
+ if self.type == 'bank' and self.bank_account_id:
+ if self.bank_account_id.company_id != self.company_id:
+ raise ValidationError(_('The bank account of a bank journal must belong to the same company (%s).') % self.company_id.name)
+ # A bank account can belong to a customer/supplier, in which case their partner_id is the customer/supplier.
+ # Or they are part of a bank journal and their partner_id must be the company's partner_id.
+ if self.bank_account_id.partner_id != self.company_id.partner_id:
+ raise ValidationError(_('The holder of a journal\'s bank account must be the company (%s).') % self.company_id.name)
+
@api.onchange('default_debit_account_id')
def onchange_debit_account_id(self):
if not self.default_credit_account_id:
@@ -285,7 +303,14 @@ class AccountJournal(models.Model):
if journal.refund_sequence_id:
new_prefix = self._get_sequence_prefix(vals['code'], refund=True)
journal.refund_sequence_id.write({'prefix': new_prefix})
- return super(AccountJournal, self).write(vals)
+ result = super(AccountJournal, self).write(vals)
+
+ # Create the bank_account_id if necessary
+ if 'bank_acc_number' in vals:
+ for journal in self.filtered(lambda r: r.type == 'bank' and not r.bank_account_id):
+ journal.set_bank_account(vals.get('bank_acc_number'), vals.get('bank_id'))
+
+ return result
@api.model
def _get_sequence_prefix(self, code, refund=False):
@@ -350,56 +375,54 @@ class AccountJournal(models.Model):
}
@api.model
- def _prepare_bank_journal(self, company, line):
- '''
- This function prepares the value to use for the creation of a bank journal created through the wizard of
- generating COA from templates.
-
- :param company: company for which the wizard is running
- :param line: dictionary containing the values encoded by the user related to his bank account with keys
- - acc_name (char): name of the bank account
- - account_type (char): kind of liquidity journal to create. Either 'bank' or 'cash'
- - currency_id (int): id of the currency related to this account if its different than the company currency (False otherwise)
- :return: mapping of field names and values
- :rtype: dict
- '''
- # we need to loop to find next number for journal code
- for num in xrange(1, 100):
- # journal_code has a maximal size of 5, hence we can enforce the boundary num < 100
- journal_code = line.get('account_type', 'bank') == 'cash' and 'CSH' or 'BNK'
- journal_code += str(num)
- journal = self.env['account.journal'].search([('code', '=', journal_code), ('company_id', '=', company.id)], limit=1)
- if not journal:
- break
- else:
- raise UserError(_('Cannot generate an unused journal code.'))
-
- return {
- 'name': line['acc_name'],
- 'code': journal_code,
- 'type': line.get('account_type', 'bank'),
- 'company_id': company.id,
- 'analytic_journal_id': False,
- 'currency_id': line.get('currency_id', False),
- 'show_on_dashboard': True,
- }
-
- @api.model
def create(self, vals):
+ company_id = vals.get('company_id', self.env.user.company_id.id)
if vals.get('type') in ('bank', 'cash'):
+ # If no code provided, loop to find next available journal code
+ if not vals.get('code'):
+ for num in xrange(1, 100):
+ # journal_code has a maximal size of 5, hence we can enforce the boundary num < 100
+ journal_code = (vals['type'] == 'cash' and 'CSH' or 'BNK') + str(num)
+ journal = self.env['account.journal'].search([('code', '=', journal_code), ('company_id', '=', company_id)], limit=1)
+ if not journal:
+ vals['code'] = journal_code
+ break
+ else:
+ raise UserError(_("Cannot generate an unused journal code. Please fill the 'Shortcode' field."))
+
+ # Create a default debit/credit account if not given
default_account = vals.get('default_debit_account_id') or vals.get('default_credit_account_id')
if not default_account:
- company = self.env['res.company'].browse(vals['company_id'])
+ company = self.env['res.company'].browse(company_id)
account_vals = self._prepare_liquidity_account(vals.get('name'), company, vals.get('currency_id'), vals.get('type'))
default_account = self.env['account.account'].create(account_vals)
vals['default_debit_account_id'] = default_account.id
vals['default_credit_account_id'] = default_account.id
+
# We just need to create the relevant sequences according to the chosen options
if not vals.get('sequence_id'):
vals.update({'sequence_id': self.sudo()._create_sequence(vals).id})
if vals.get('refund_sequence') and not vals.get('refund_sequence_id'):
vals.update({'refund_sequence_id': self.sudo()._create_sequence(vals, refund=True).id})
- return super(AccountJournal, self).create(vals)
+
+ journal = super(AccountJournal, self).create(vals)
+
+ # Create the bank_account_id if necessary
+ if journal.type == 'bank' and not journal.bank_account_id and vals.get('bank_acc_number'):
+ journal.set_bank_account(vals.get('bank_acc_number'), vals.get('bank_id'))
+
+ return journal
+
+ def set_bank_account(self, acc_number, bank_id=None):
+ """ Create a res.partner.bank and set it as value of the field bank_account_id """
+ self.ensure_one()
+ self.bank_account_id = self.env['res.partner.bank'].create({
+ 'acc_number': acc_number,
+ 'bank_id': bank_id,
+ 'company_id': self.company_id.id,
+ 'currency_id': self.currency_id.id,
+ 'partner_id': self.company_id.partner_id.id,
+ }).id
@api.multi
@api.depends('name', 'currency_id', 'company_id', 'company_id.currency_id')
@@ -419,6 +442,19 @@ class AccountJournal(models.Model):
journal.at_least_one_outbound = bool(len(self.outbound_payment_method_ids))
+class ResPartnerBank(models.Model):
+ _inherit = "res.partner.bank"
+
+ journal_id = fields.One2many('account.journal', 'bank_account_id', domain=[('type', '=', 'bank')], string='Account Journal', readonly=True,
+ help="The accounting journal corresponding to this bank account.")
+
+ @api.one
+ @api.constrains('journal_id')
+ def _check_journal_id(self):
+ if len(self.journal_id) > 1:
+ raise ValidationError(_('A bank account can anly belong to one journal.'))
+
+
#----------------------------------------------------------
# Tax
#----------------------------------------------------------
diff --git a/addons/account/models/account_bank.py b/addons/account/models/account_bank.py
deleted file mode 100644
index 96b69d81bab..00000000000
--- a/addons/account/models/account_bank.py
+++ /dev/null
@@ -1,44 +0,0 @@
-# -*- coding: utf-8 -*-
-
-from openerp import api, fields, models
-
-
-class Bank(models.Model):
- _inherit = "res.partner.bank"
-
- journal_id = fields.Many2one('account.journal', string='Account Journal',
- help="This journal will be created automatically for this bank account when you save the record")
-
- @api.model
- def create(self, data):
- result = super(Bank, self).create(data)
- result.post_write()
- return result
-
- @api.multi
- def write(self, data):
- result = super(Bank, self).write(data)
- self.post_write()
- return result
-
- @api.model
- def _prepare_name(self, bank):
- "Return the name to use when creating a bank journal"
- name = bank.bank_name + ' ' if bank.bank_name else ''
- name += bank.acc_number
- return name
-
- @api.multi
- def post_write(self):
- JournalObj = self.env['account.journal']
- for bank in self:
- # Create a journal for the bank account if it belongs to the company.
- if bank.company_id and not bank.journal_id:
- journal_vals = JournalObj._prepare_bank_journal(bank.company_id, {'acc_name': self._prepare_name(bank), 'currency_id': bank.currency_id.id, 'account_type': 'bank'})
- journal = JournalObj.create(journal_vals)
- missing_vals = {'journal_id': journal.id}
- if not bank.partner_id:
- missing_vals['partner_id'] = bank.company_id.partner_id.id
- if not bank.owner_name:
- missing_vals['owner_name'] = bank.company_id.partner_id.name
- bank.write(missing_vals)
diff --git a/addons/account/models/account_journal_dashboard.py b/addons/account/models/account_journal_dashboard.py
index 27e3bc8fb77..d4a8add628b 100644
--- a/addons/account/models/account_journal_dashboard.py
+++ b/addons/account/models/account_journal_dashboard.py
@@ -187,7 +187,8 @@ class account_journal(models.Model):
'sum_waiting': formatLang(self.env, sum_waiting or 0.0, currency_obj=self.currency_id or self.company_id.currency_id),
'sum_late': formatLang(self.env, sum_late or 0.0, currency_obj=self.currency_id or self.company_id.currency_id),
'currency_id': self.currency_id and self.currency_id.id or self.company_id.currency_id.id,
- 'show_import': True if self.type in ['bank', 'cash'] and len(ac_bnk_stmt) == 0 and last_balance == 0 else False,
+ 'no_statement': bool(self.type in ['bank', 'cash'] and len(ac_bnk_stmt) == 0),
+ 'bank_statements_source': self.bank_statements_source,
'title': title,
}
@@ -220,7 +221,7 @@ class account_journal(models.Model):
}
@api.multi
- def create_cash_bank(self):
+ def create_cash_statement(self):
ctx = self._context.copy()
ctx.update({'journal_id': self.id, 'default_journal_id': self.id, 'default_journal_type': 'cash'})
return {
@@ -337,13 +338,12 @@ class account_journal(models.Model):
return action
@api.multi
- def import_statement(self):
- """return action to import bank/cash statements. This button should be called only on journals with type =='bank'"""
- model = 'account.bank.statement'
- action_name = 'action_account_bank_statement_import'
- ir_model_obj = self.pool['ir.model.data']
- model, action_id = ir_model_obj.get_object_reference(self._cr, self._uid, 'account_bank_statement_import', action_name)
- action = self.pool[model].read(self._cr, self._uid, action_id, context=self.env.context)
- # Note: this drops action['context'], which is a dict stored as a string, which is not easy to update
- action.update({'context': (u"{'journal_id': " + str(self.id) + u"}")})
+ def create_bank_statement(self):
+ """return action to create a bank statements. This button should be called only on journals with type =='bank'"""
+ self.bank_statements_source = 'manual'
+ action = self.env.ref('account.action_bank_statement_tree').read()[0]
+ action.update({
+ 'views': [[False, 'form']],
+ 'context': "{'default_journal_id': " + str(self.id) + "}",
+ })
return action
diff --git a/addons/account/models/chart_template.py b/addons/account/models/chart_template.py
index 12b4433bd70..d9eebe31e1c 100644
--- a/addons/account/models/chart_template.py
+++ b/addons/account/models/chart_template.py
@@ -751,42 +751,21 @@ class WizardMultiChartsAccounts(models.TransientModel):
def _create_bank_journals_from_o2m(self, company, acc_template_ref):
'''
This function creates bank journals and its accounts for each line encoded in the field bank_account_ids of the
- wizard.
+ wizard (which is currently only used to create a default bank and cash journal when the CoA is installed).
- :param company_id: the id of the company for which the wizard is running.
+ :param company: the company for which the wizard is running.
:param acc_template_ref: the dictionary containing the mapping between the ids of account templates and the ids
of the accounts that have been generated from them.
- :return: True
'''
self.ensure_one()
- # Build a list with all the data to process
- journal_data = []
- if self.bank_account_ids:
- for acc in self.bank_account_ids:
- vals = {
- 'acc_name': acc.acc_name,
- 'account_type': acc.account_type,
- 'currency_id': acc.currency_id.id,
- }
- journal_data.append(vals)
-
- for line in journal_data:
- if line['account_type'] == 'bank':
- #create the bank account that will trigger the journal and account.account creation
- res_partner_bank_vals = {
- 'acc_number': line['acc_name'],
- 'currency_id': line['currency_id'],
- 'company_id': company.id,
- 'owner_name': company.partner_id.name,
- 'partner_id': company.partner_id.id,
- 'footer': True
- }
- self.env['res.partner.bank'].create(res_partner_bank_vals)
- else:
- #create the cash journal that will trigger the account.account creation
- vals_journal = self.env['account.journal']._prepare_bank_journal(company, line)
- self.env['account.journal'].create(vals_journal)
- return True
+ # Create the journals that will trigger the account.account creation
+ for acc in self.bank_account_ids:
+ self.env['account.journal'].create({
+ 'name': acc.acc_name,
+ 'type': acc.account_type,
+ 'company_id': company.id,
+ 'currency_id': acc.currency_id.id,
+ })
class AccountBankAccountsWizard(models.TransientModel):
diff --git a/addons/account/models/company.py b/addons/account/models/company.py
index 0b3c0a8d1a9..d329003480b 100644
--- a/addons/account/models/company.py
+++ b/addons/account/models/company.py
@@ -34,6 +34,8 @@ class ResCompany(models.Model):
property_stock_account_input_categ_id = fields.Many2one('account.account', oldname="property_stock_account_input_categ")
property_stock_account_output_categ_id = fields.Many2one('account.account', oldname="property_stock_account_output_categ")
property_stock_valuation_account_id = fields.Many2one('account.account')
+ bank_journal_ids = fields.One2many('account.journal', 'company_id', domain=[('type', '=', 'bank')], string='Bank Journals')
+
@api.multi
def compute_fiscalyear_dates(self, date):
diff --git a/addons/account/models/res_config.py b/addons/account/models/res_config.py
index da44469b2cb..dc19a8dd3ac 100644
--- a/addons/account/models/res_config.py
+++ b/addons/account/models/res_config.py
@@ -174,14 +174,9 @@ class AccountConfigSettings(models.TransientModel):
return True
@api.multi
- def open_company_form(self):
- return {
- 'type': 'ir.actions.act_window',
- 'name': 'Configure your Company',
- 'res_model': 'res.company',
- 'res_id': self.company_id.id,
- 'view_mode': 'form',
- }
+ def open_bank_accounts(self):
+ action_rec = self.env['ir.model.data'].xmlid_to_object('account.action_account_bank_journal_form')
+ return action_rec.read([])[0]
@api.multi
def set_transfer_account(self):
diff --git a/addons/account/report/inherited_layouts.xml b/addons/account/report/inherited_layouts.xml
new file mode 100644
index 00000000000..290c1ba3a23
--- /dev/null
+++ b/addons/account/report/inherited_layouts.xml
@@ -0,0 +1,22 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+<data>
+
+<template id="external_layout_footer" inherit_id="report.external_layout_footer">
+ <xpath expr="//ul[@name='financial_infos']" position="inside">
+ <t t-if="not company.custom_footer">
+ <t t-set="is_first" t-value="True"/>
+ <t t-foreach="company.bank_journal_ids" t-as="journal">
+ <t t-set="bank_acc" t-value="journal.bank_account_id"/>
+ <t t-if="journal.display_on_footer">
+ <li t-if="(is_first and company.vat) or (not is_first)">&amp;bull;</li>
+ <li><span t-esc="bank_acc.bank_name"/><t t-if="bank_acc.bank_bic"> (<span t-esc="bank_acc.bank_bic"/>)</t>: <span t-esc="bank_acc.acc_number"/></li>
+ <t t-set="is_first" t-value="False"/>
+ </t>
+ </t>
+ </t>
+ </xpath>
+</template>
+
+</data>
+</openerp>
diff --git a/addons/account/static/src/less/account_journal_dashboard.less b/addons/account/static/src/less/account_journal_dashboard.less
index e0b15be344c..5e86c31d237 100644
--- a/addons/account/static/src/less/account_journal_dashboard.less
+++ b/addons/account/static/src/less/account_journal_dashboard.less
@@ -6,6 +6,10 @@
min-width: inherit;
}
+ button {
+ margin-bottom: 5px;
+ }
+
.o_kanban_card_settings {
padding: 8px;
diff --git a/addons/account/test/account_bank_statement.yml b/addons/account/test/account_bank_statement.yml
index cadb1f2fcd3..bd668e07a13 100644
--- a/addons/account/test/account_bank_statement.yml
+++ b/addons/account/test/account_bank_statement.yml
@@ -2,13 +2,6 @@
!context
journal_type: 'bank'
-
- We create a new bank with the company as partner in order to be sure to have at least one bank journal
--
- !record {model: res.partner.bank, id: test_bank}:
- acc_number: BE123456789
- bank_name: BNP Test bank
- partner_id: base.main_partner
--
In order to test Bank Statement feature of account I create a bank statement line and confirm it and check it's move created
-
I select the period and journal for the bank statement
diff --git a/addons/account/test/account_minimal_test.xml b/addons/account/test/account_minimal_test.xml
index 2d495188db0..9760eb53757 100644
--- a/addons/account/test/account_minimal_test.xml
+++ b/addons/account/test/account_minimal_test.xml
@@ -237,6 +237,12 @@
<field name="refund_sequence" eval="True"/>
</record>
+ <record id="bank_account" model="res.partner.bank">
+ <field name="acc_number">987654321</field>
+ <field name="acc_type">bank</field>
+ <field name="bank_name">Bank</field>
+ <field name="partner_id" ref="base.main_partner"/>
+ </record>
<record id="bank_journal" model="account.journal">
<field name="name">Bank - Test</field>
<field name="code">TBNK</field>
@@ -244,6 +250,7 @@
<field name="default_debit_account_id" ref="bnk"/>
<field name="default_credit_account_id" ref="bnk"/>
<field name="analytic_journal_id" ref="analytic.sit"/>
+ <field name="bank_account_id" ref="bank_account"/>
</record>
<record id="cash_journal" model="account.journal">
<field name="name">Cash - Test</field>
@@ -271,6 +278,12 @@
<field name="show_on_dashboard" eval="False"/>
</record>
+ <record id="bank_account_usd" model="res.partner.bank">
+ <field name="acc_number">123456789</field>
+ <field name="acc_type">bank</field>
+ <field name="bank_name">Bank US</field>
+ <field name="partner_id" ref="base.main_partner"/>
+ </record>
<record id="bank_journal_usd" model="account.journal">
<field name="name">USD Bank - Test</field>
<field name="code">TUBK</field>
@@ -278,6 +291,7 @@
<field name="default_debit_account_id" ref="usd_bnk"/>
<field name="default_credit_account_id" ref="usd_bnk"/>
<field name="currency_id" ref="base.USD"/>
+ <field name="bank_account_id" ref="bank_account_usd"/>
</record>
<record id="base.main_company" model="res.company">
<field name="currency_exchange_journal_id" ref="currency_diff_journal"/>
diff --git a/addons/account/tests/test_account_customer_invoice.py b/addons/account/tests/test_account_customer_invoice.py
index 0b79b47a0d9..565057d733d 100644
--- a/addons/account/tests/test_account_customer_invoice.py
+++ b/addons/account/tests/test_account_customer_invoice.py
@@ -8,13 +8,11 @@ class TestAccountCustomerInvoice(AccountTestUsers):
# I will create bank detail with using manager access rights
# because account manager can only create bank details.
self.res_partner_bank_0 = self.env['res.partner.bank'].sudo(self.account_manager.id).create(dict(
- state='bank',
+ acc_type='bank',
company_id=self.main_company.id,
partner_id=self.main_partner.id,
acc_number='123456789',
- footer=True,
- bank=self.main_bank.id,
- bank_name=self.main_bank.name,
+ bank_id=self.main_bank.id,
))
# Test with that user which have rights to make Invoicing and payment and who is accountant.
diff --git a/addons/account/tests/test_payment.py b/addons/account/tests/test_payment.py
index fba65d6f54c..00fcc9d7d3c 100644
--- a/addons/account/tests/test_payment.py
+++ b/addons/account/tests/test_payment.py
@@ -26,15 +26,11 @@ class TestPayment(AccountingTestCase):
self.account_payable = self.env['account.account'].search([('user_type_id', '=', self.env.ref('account.data_account_type_payable').id)], limit=1)
self.account_revenue = self.env['account.account'].search([('user_type_id', '=', self.env.ref('account.data_account_type_revenue').id)], limit=1)
- self.bank_euro = self.env['res.partner.bank'].create({'acc_number': '0123456789', 'bank_name': 'Test Bank', 'company_id': self.env.user.company_id.id})
- self.bank_journal_euro = self.bank_euro.journal_id
+ self.bank_journal_euro = self.env['account.journal'].create({'name': 'Bank', 'type': 'bank', 'code': 'BNK67'})
self.account_eur = self.bank_journal_euro.default_debit_account_id
- self.bank_usd = self.env['res.partner.bank'].create({'acc_number': '0123456789', 'bank_name': 'Test Bank USD', 'company_id': self.env.user.company_id.id})
- self.bank_journal_usd = self.bank_usd.journal_id
+ self.bank_journal_usd = self.env['account.journal'].create({'name': 'Bank US', 'type': 'bank', 'code': 'BNK68', 'currency_id': self.currency_usd_id})
self.account_usd = self.bank_journal_usd.default_debit_account_id
- self.account_usd.write({'currency_id': self.currency_usd_id})
- self.bank_journal_usd.write({'currency_id': self.currency_usd_id})
self.transfer_account = self.env['res.users'].browse(self.env.uid).company_id.transfer_account_id
self.diff_income_account = self.env['res.users'].browse(self.env.uid).company_id.income_currency_exchange_account_id
diff --git a/addons/account/tests/test_reconciliation.py b/addons/account/tests/test_reconciliation.py
index e155923e20a..a11987dae07 100644
--- a/addons/account/tests/test_reconciliation.py
+++ b/addons/account/tests/test_reconciliation.py
@@ -28,16 +28,12 @@ class TestReconciliation(AccountingTestCase):
self.account_rsa = self.env['account.account'].search([('user_type_id', '=', self.env.ref('account.data_account_type_payable').id)], limit=1)
self.product = self.env.ref("product.product_product_4")
- self.bank_euro = self.env['res.partner.bank'].create({'acc_number': 'Reconciliation test', 'bank_name': 'Test Bank', 'company_id': self.env.user.company_id.id})
- self.bank_journal_euro = self.bank_euro.journal_id
+ self.bank_journal_euro = self.env['account.journal'].create({'name': 'Bank', 'type': 'bank', 'code': 'BNK67'})
self.account_euro = self.bank_journal_euro.default_debit_account_id
- self.bank_usd = self.env['res.partner.bank'].create({'acc_number': 'Reconciliation test USD',
- 'bank_name': 'Test Bank USD', 'company_id': self.env.user.company_id.id})
- self.bank_journal_usd = self.bank_usd.journal_id
+ self.bank_journal_usd = self.env['account.journal'].create({'name': 'Bank US', 'type': 'bank', 'code': 'BNK68', 'currency_id': self.currency_usd_id})
self.account_usd = self.bank_journal_usd.default_debit_account_id
- self.account_usd.write({'currency_id': self.currency_usd_id})
- self.bank_journal_usd.write({'currency_id': self.currency_usd_id})
+
self.diff_income_account = self.env['res.users'].browse(self.env.uid).company_id.income_currency_exchange_account_id
self.diff_expense_account = self.env['res.users'].browse(self.env.uid).company_id.expense_currency_exchange_account_id
diff --git a/addons/account/views/account_bank_view.xml b/addons/account/views/account_bank_view.xml
deleted file mode 100644
index d125251c360..00000000000
--- a/addons/account/views/account_bank_view.xml
+++ /dev/null
@@ -1,62 +0,0 @@
-<?xml version="1.0" encoding="utf-8"?>
-<openerp>
-<data>
-
- <!--
- Bank Accounts
- -->
-
- <record id="view_partner_bank_form_inherit" model="ir.ui.view">
- <field name="name">Partner Bank Accounts - Journal</field>
- <field name="model">res.partner.bank</field>
- <field name="inherit_id" ref="base.view_partner_bank_form"/>
- <field name="arch" type="xml">
- <group name="bank" position="after">
- <group name="accounting" col="2" colspan="2" attrs="{'invisible': [('company_id','=', False)]}">
- <separator string="Accounting Information" colspan="2"/>
- <field name="journal_id"/>
- <field name="currency_id" groups="base.group_multi_currency" options="{'no_create': True}"/>
- </group>
- </group>
- </field>
- </record>
-
-
- <record id="view_partner_bank_tree_add_currency" model="ir.ui.view">
- <field name="name">Partner Bank Accounts - Add currency on tree</field>
- <field name="model">res.partner.bank</field>
- <field name="inherit_id" ref="base.view_partner_bank_tree"/>
- <field name="arch" type="xml">
- <field name="acc_number" position="after">
- <field name="currency_id" options="{'no_create': True}" groups="base.group_multi_currency"/>
- </field>
- </field>
- </record>
-
-
- <record id="action_bank_tree" model="ir.actions.act_window">
- <field name="name">Bank Accounts</field>
- <field name="res_model">res.partner.bank</field>
- <field name="view_type">form</field>
- <field name="view_mode">tree,form</field>
- <field name="context" eval="{'default_partner_id':ref('base.main_partner'), 'company_hide':False, 'search_default_my_bank':1}"/>
- <field name="help" type="html">
- <p class="oe_view_nocontent_create">
- Click to setup a new bank account.
- </p><p>
- Configure your company's bank account and select those that must
- appear on the report footer.
- </p><p>
- If you use the accounting application of Odoo, journals and
- accounts will be created automatically based on these data.
- </p>
- </field>
- </record>
- <menuitem
- sequence="99"
- parent="account.account_account_menu"
- id="menu_action_bank_tree"
- action="action_bank_tree"/>
-
-</data>
-</openerp>
diff --git a/addons/account/views/account_journal_dashboard_view.xml b/addons/account/views/account_journal_dashboard_view.xml
index aa4dc1a2187..3d343f7ab84 100644
--- a/addons/account/views/account_journal_dashboard_view.xml
+++ b/addons/account/views/account_journal_dashboard_view.xml
@@ -71,12 +71,12 @@
<div class="o_kanban_card_manage_title">
<span>New</span>
</div>
- <div>
+ <div name="bank_cash_commands">
<t t-if="journal_type == 'bank'">
- <a type="object" name="import_statement">Import Statement</a>
+ <a type="object" name="create_bank_statement">Transaction</a>
</t>
<t t-if="journal_type == 'cash'">
- <a type="object" name="create_cash_bank">Transaction</a>
+ <a type="object" name="create_cash_statement">Transaction</a>
</t>
</div>
<div>
@@ -200,12 +200,30 @@
</t>
<t t-name="JournalBodyBankCash">
- <t t-if="!dashboard.show_import">
- <div class="col-xs-6 o_kanban_primary_left">
- <button t-if="dashboard.number_to_reconcile > 0" type="object" name="action_open_reconcile" class="btn btn-primary btn-sm">
- Reconcile <t t-esc="dashboard.number_to_reconcile"/> Items
- </button>
- </div>
+ <!-- On the left, display :
+ - A button corresponding to the bank_statements_source, if it wasn't configured, a button for each of them
+ - If there are statements to reconcile, a link to reconcile them -->
+ <div class="col-xs-6 o_kanban_primary_left">
+ <t t-if="journal_type == 'bank'">
+ <t t-if="! dashboard.bank_statements_source">
+ <div name="bank_journal_default_cta">
+ <button type="object" name="create_bank_statement" class="btn btn-primary btn-sm">Create Statement</button>
+ </div>
+ </t>
+ <t t-if="dashboard.bank_statements_source">
+ <div name="bank_journal_cta">
+ <button t-if="dashboard.bank_statements_source == 'manual'" type="object" name="create_bank_statement" class="btn btn-primary btn-sm">Create Statement</button>
+ </div>
+ </t>
+ </t>
+ <button t-if="journal_type == 'cash'" type="object" name="create_cash_statement" class="btn btn-primary btn-sm">Register Transactions</button>
+ <br/>
+ <t t-if="!dashboard.no_statement and dashboard.number_to_reconcile > 0">
+ <a type="object" name="action_open_reconcile" class="oe_inline"> Reconcile <t t-esc="dashboard.number_to_reconcile"/> Items</a>
+ </t>
+ </div>
+ <!-- On the right, show other common informations/actions -->
+ <t t-if="!dashboard.no_statement">
<div class="col-xs-6 o_kanban_primary_right">
<div class="row">
<div class="col-xs-6">
@@ -260,11 +278,7 @@
</t>
<t t-name="JournalBodyGraph">
<div class="row">
- <div t-if="dashboard.show_import" class="col-xs-12 o_kanban_primary_left">
- <button t-if="journal_type == 'bank'" type="object" name="import_statement" class="btn btn-primary btn-sm">Import Statement</button>
- <button t-if="journal_type == 'cash'" type="object" name="create_cash_bank" class="btn btn-primary btn-sm">Register Transactions</button>
- </div>
- <div t-if="!dashboard.show_import" class="o_kanban_graph_section">
+ <div t-if="!dashboard.no_statement" class="o_kanban_graph_section">
<field name="kanban_dashboard_graph" t-att-graph_type="_.contains(['cash','bank'],journal_type) ? 'line' : 'bar'" widget="dashboard_graph"></field>
</div>
</div>
diff --git a/addons/account/views/account_view.xml b/addons/account/views/account_view.xml
index 65d1f101eed..79f7e3d36d4 100644
--- a/addons/account/views/account_view.xml
+++ b/addons/account/views/account_view.xml
@@ -215,6 +215,7 @@
<record id="view_account_journal_search" model="ir.ui.view">
<field name="name">account.journal.search</field>
<field name="model">account.journal</field>
+ <field name="priority">1</field>
<field name="arch" type="xml">
<search string="Search Account Journal">
<field name="name" filter_domain="['|', ('name','ilike',self), ('code','ilike',self)]" string="Journal"/>
@@ -230,6 +231,7 @@
<record id="view_account_journal_form" model="ir.ui.view">
<field name="name">account.journal.form</field>
<field name="model">account.journal</field>
+ <field name="priority">1</field>
<field name="arch" type="xml">
<form string="Account Journal">
<sheet>
@@ -249,7 +251,7 @@
<page name="journal_entries" string="Journal Entries">
<group>
<group>
- <field name="code"/>
+ <field name="code" attrs="{'readonly': ['|',('type', 'in', ['bank','cash']),('sequence_id','!=',False)], 'required': [('type', 'not in', ['bank', 'cash'])]}"/>
<field name="refund_sequence" attrs="{'invisible': [('type', 'not in', ['sale', 'purchase'])]}"/>
<field name="sequence_id" required="0" groups="base.group_no_one"/>
<field name="refund_sequence_id" attrs="{'invisible': ['|',('type', 'not in', ['sale', 'purchase']), ('refund_sequence', '!=', True)]}" required="0" groups="base.group_no_one"/>
@@ -279,11 +281,79 @@
</group>
</group>
</page>
+ <page name="bank_account" string="Bank Account" attrs="{'invisible': [('type', '!=', 'bank')]}">
+ <group>
+ <group>
+ <field name="bank_acc_number"/>
+ <field name="bank_id"/>
+ <field name="display_on_footer"/>
+ </group>
+ <group >
+ <field name="bank_statements_source" widget="radio" attrs="{'required': [('type', '=', 'bank')]}"/>
+ </group>
+ </group>
+ </page>
</notebook>
</sheet>
</form>
</field>
</record>
+
+ <record id="view_account_bank_journal_tree" model="ir.ui.view">
+ <field name="name">account.bank.journal.tree</field>
+ <field name="model">account.journal</field>
+ <field name="priority">10</field>
+ <field name="arch" type="xml">
+ <tree string="Account Journal">
+ <field name='sequence' widget='handle'/>
+ <field name="name"/>
+ <field name="display_on_footer"/>
+ <field name="company_id" groups="base.group_multi_company"/>
+ </tree>
+ </field>
+ </record>
+ <record id="view_account_bank_journal_form" model="ir.ui.view">
+ <field name="name">account.bank.journal.form</field>
+ <field name="model">account.journal</field>
+ <field name="priority">10</field>
+ <field name="arch" type="xml">
+ <form string="Bank Account">
+ <sheet>
+ <field name="type" invisible="1"/>
+ <field name="name" invisible="1"/>
+ <div class="oe_title">
+ <label for="bank_acc_number" required="1" class="oe_edit_only"/>
+ <h1><field name="bank_acc_number" required="1"/></h1>
+ </div>
+ <group col="4">
+ <field name="bank_id"/>
+ <field name="display_on_footer"/>
+ <field name="company_id" options="{'no_create': True}" groups="base.group_multi_company"/>
+ <field name="currency_id" options="{'no_create': True}" groups="base.group_multi_currency"/>
+ <field name="inbound_payment_method_ids" widget="many2many_checkboxes"/>
+ <field name="outbound_payment_method_ids" widget="many2many_checkboxes"/>
+ </group>
+ </sheet>
+ </form>
+ </field>
+ </record>
+ <record id="action_account_bank_journal_form" model="ir.actions.act_window">
+ <field name="name">Bank Accounts</field>
+ <field name="res_model">account.journal</field>
+ <field name="view_mode">tree,form</field>
+ <field name="view_ids" eval="[(5, 0, 0),
+ (0, 0, {'view_mode': 'tree', 'view_id': ref('view_account_bank_journal_tree')}),
+ (0, 0, {'view_mode': 'form', 'view_id': ref('view_account_bank_journal_form')})]"/>
+ <field name="domain">[('type', '=', 'bank')]</field>
+ <field name="context">{'default_type': 'bank', 'default_display_on_footer': True}</field>
+ <field name="help" type="html">
+ <p class="oe_view_nocontent_create">
+ Click to add a bank account.
+ </p>
+ </field>
+ </record>
+ <menuitem action="action_account_bank_journal_form" id="menu_action_account_bank_journal_form" parent="account_account_menu"/>
+
<record id="action_account_journal_form" model="ir.actions.act_window">
<field name="name">Journals</field>
<field name="res_model">account.journal</field>
diff --git a/addons/account/views/res_config_view.xml b/addons/account/views/res_config_view.xml
index 6fc3552e650..2160a3a7d02 100644
--- a/addons/account/views/res_config_view.xml
+++ b/addons/account/views/res_config_view.xml
@@ -164,7 +164,7 @@
<div>
<div name='company_footer'>
<label for="company_footer"/>
- <button name="open_company_form" type="object"
+ <button name="open_bank_accounts" type="object"
string="Configure your company bank accounts" icon="gtk-go-forward"
class="oe_inline oe_link"/>
<field name="company_footer"/>
diff --git a/addons/account_bank_statement_import/__init__.py b/addons/account_bank_statement_import/__init__.py
index a72befb7117..65797c0f6e3 100644
--- a/addons/account_bank_statement_import/__init__.py
+++ b/addons/account_bank_statement_import/__init__.py
@@ -1,5 +1,6 @@
# -*- encoding: utf-8 -*-
import account_bank_statement_import
+import account_journal
import wizard
diff --git a/addons/account_bank_statement_import/account_bank_statement_import.py b/addons/account_bank_statement_import/account_bank_statement_import.py
index c9ca9c19388..6ea8c4d266c 100644
--- a/addons/account_bank_statement_import/account_bank_statement_import.py
+++ b/addons/account_bank_statement_import/account_bank_statement_import.py
@@ -4,6 +4,7 @@ import base64
from openerp import api, fields, models, _
from openerp.exceptions import UserError
+from openerp.addons.base.res.res_bank import sanitize_account_number
import logging
_logger = logging.getLogger(__name__)
@@ -30,20 +31,17 @@ class AccountBankStatementImport(models.TransientModel):
def import_file(self):
""" Process the file chosen in the wizard, create bank statement(s) and go to reconciliation. """
self.ensure_one()
- #set the active_id in the context, so that any extension module could
- #reuse the fields chosen in the wizard if needed (see .QIF for example)
- data_file = self.data_file
# Let the appropriate implementation module parse the file and return the required data
# The active_id is passed in context in case an implementation module requires information about the wizard state (see QIF)
- currency_code, account_number, stmts_vals = self.with_context(active_id=self.ids[0])._parse_file(base64.b64decode(data_file))
+ currency_code, account_number, stmts_vals = self.with_context(active_id=self.ids[0])._parse_file(base64.b64decode(self.data_file))
# Check raw data
self._check_parsed_data(stmts_vals)
# Try to find the currency and journal in odoo
- currency, journal, bank_account = self._find_additional_data(currency_code, account_number)
+ currency, journal = self._find_additional_data(currency_code, account_number)
# If no journal found, ask the user about creating one
if not journal:
# The active_id is passed in context so the wizard can call import_file again once the journal is created
- return self.with_context(active_id=self.ids[0])._journal_creation_wizard(currency, account_number, bank_account)
+ return self.with_context(active_id=self.ids[0])._journal_creation_wizard(currency, account_number)
# Prepare statement data to be used for bank statements creation
stmts_vals = self._complete_stmts_vals(stmts_vals, journal, account_number)
# Create the bank statements
@@ -60,8 +58,8 @@ class AccountBankStatementImport(models.TransientModel):
'type': 'ir.actions.client',
}
- def _journal_creation_wizard(self, currency, account_number, bank_account):
- """ Calls a wizard that allows the user to accept/refuse journal creation """
+ def _journal_creation_wizard(self, currency, account_number):
+ """ Calls a wizard that allows the user to carry on with journal creation """
return {
'name': _('Journal Creation'),
'type': 'ir.actions.act_window',
@@ -71,10 +69,11 @@ class AccountBankStatementImport(models.TransientModel):
'target': 'new',
'context': {
'statement_import_transient_id': self.env.context['active_id'],
- 'default_currency_id': currency and currency.id or False,
- 'default_account_number': account_number,
- 'bank_account_id': bank_account and bank_account.id or False,
+ 'default_bank_acc_number': account_number,
'default_name': _('Bank') + ' ' + account_number,
+ 'default_currency_id': currency and currency.id or False,
+ 'default_type': 'bank',
+ 'default_bank_statements_source': 'file_import',
}
}
@@ -118,10 +117,13 @@ class AccountBankStatementImport(models.TransientModel):
raise UserError(_('This file doesn\'t contain any transaction.'))
def _find_additional_data(self, currency_code, account_number):
- """ Get the res.currency ID and the res.partner.bank ID """
+ """ Look for a res.currency and account.journal using values extracted from the
+ statement and make sure it's consistent.
+ """
company_currency = self.env.user.company_id.currency_id
journal_obj = self.env['account.journal']
currency = None
+ sanitized_account_number = sanitize_account_number(account_number)
if currency_code:
currency = self.env['res.currency'].search([('name', '=ilike', currency_code)], limit=1)
@@ -130,31 +132,20 @@ class AccountBankStatementImport(models.TransientModel):
if currency == company_currency:
currency = False
- bank_account = None
- if account_number and len(account_number) > 4:
- bank_account = self.env['res.partner.bank'].search([('acc_number', '=', account_number)], limit=1)
-
- # Find the journal from context or bank account
- journal = journal_obj.browse(self._context.get('journal_id', []))
- if bank_account:
- if journal:
- if bank_account.journal_id and bank_account.journal_id != journal:
- raise UserError(_('The account of this statement is linked to another journal.'))
- if not bank_account.journal_id:
- bank_account.write({'journal_id': journal.id})
- else:
- if bank_account.journal_id:
- journal = bank_account.journal_id
-
- # If importing into an existing journal
+ journal = journal_obj.browse(self.env.context.get('journal_id', []))
+ if account_number:
+ # No bank account on the journal : create one from the account number of the statement
+ if journal and not journal.bank_account_id:
+ journal.set_bank_account(account_number)
+ # Already a bank account on the journal : check it's the same as on the statement
+ elif journal and journal.bank_account_id.sanitized_acc_number != sanitized_account_number:
+ raise UserError(_('The account of this statement (%s) is not the same as the journal (%s).') % (account_number, journal.bank_account_id.acc_number))
+ # No journal passed to the wizard : try to find one using the account number of the statement
+ elif not journal:
+ journal = journal_obj.search([('bank_account_id.sanitized_acc_number', '=', sanitized_account_number)])
+
+ # If importing into an existing journal, its currency must be the same as the bank statement
if journal:
- # The bank account cannot belong to another journal
- if not bank_account and account_number:
- journal_account = self.env['res.partner.bank'].search([('journal_id', '=', journal.id)], limit=1)
- if journal_account:
- raise UserError(_('You are importing a file from account %s while the account of journal %s is %s.') % (account_number, journal.name, journal_account.acc_number))
-
- # Its currency must be the same as the bank statement
journal_currency = journal.currency_id
if currency == None:
currency = journal_currency
@@ -167,19 +158,7 @@ class AccountBankStatementImport(models.TransientModel):
if not journal and not account_number:
raise UserError(_('Cannot find in which journal import this statement. Please manually select a journal.'))
- return currency, journal, bank_account
-
- def _create_bank_account(self, account_number):
- try:
- bank_type = self.env.ref('bank.bank_normal')
- bank_code = bank_type.code
- except ValueError:
- bank_code = 'bank'
- account_number = account_number.replace(' ', '').replace('-', '')
- return self.env['res.partner.bank'].create({
- 'acc_number': account_number,
- 'state': bank_code,
- })
+ return currency, journal
def _complete_stmts_vals(self, stmts_vals, journal, account_number):
for st_vals in stmts_vals:
@@ -188,7 +167,8 @@ class AccountBankStatementImport(models.TransientModel):
for line_vals in st_vals['transactions']:
unique_import_id = line_vals.get('unique_import_id')
if unique_import_id:
- line_vals['unique_import_id'] = (account_number and account_number + '-' or '') + unique_import_id
+ sanitized_account_number = sanitize_account_number(account_number)
+ line_vals['unique_import_id'] = (sanitized_account_number and sanitized_account_number + '-' or '') + unique_import_id
if not line_vals.get('bank_account_id'):
# Find the partner and his bank account or create the bank account. The partner selected during the
@@ -202,9 +182,7 @@ class AccountBankStatementImport(models.TransientModel):
bank_account_id = partner_bank.id
partner_id = partner_bank.partner_id.id
else:
- #do not pass the journal_id in _create_bank_account() because we don't want to link
- #that bank_account to the journal (it belongs to a partner, not to the company)
- bank_account_id = self._create_bank_account(identifying_string).id
+ bank_account_id = self.env['res.partner.bank'].create({'acc_number': line_vals['account_number']}).id
line_vals['partner_id'] = partner_id
line_vals['bank_account_id'] = bank_account_id
@@ -221,7 +199,7 @@ class AccountBankStatementImport(models.TransientModel):
for st_vals in stmts_vals:
filtered_st_lines = []
for line_vals in st_vals['transactions']:
- if not 'unique_import_id' in line_vals \
+ if 'unique_import_id' not in line_vals \
or not line_vals['unique_import_id'] \
or not bool(BankStatementLine.sudo().search([('unique_import_id', '=', line_vals['unique_import_id'])], limit=1)):
filtered_st_lines.append(line_vals)
diff --git a/addons/account_bank_statement_import/account_bank_statement_import_view.xml b/addons/account_bank_statement_import/account_bank_statement_import_view.xml
index ad708d30b63..d529f678028 100644
--- a/addons/account_bank_statement_import/account_bank_statement_import_view.xml
+++ b/addons/account_bank_statement_import/account_bank_statement_import_view.xml
@@ -30,4 +30,22 @@
<field name="view_id" ref="account_bank_statement_import_view"/>
</record>
+ <record id="journal_dashboard_view_inherit" model="ir.ui.view">
+ <field name="name">account.journal.dashboard.kanban.inherit</field>
+ <field name="model">account.journal</field>
+ <field name="inherit_id" ref="account.account_journal_dashboard_kanban_view"/>
+ <field name="arch" type="xml">
+ <xpath expr='//div[@name="bank_journal_default_cta"]/button' position='after'>
+ <br/><button type="object" name="import_statement" class="btn btn-primary btn-sm">Import Statement</button>
+ </xpath>
+ <xpath expr='//div[@name="bank_journal_cta"]' position='inside'>
+ <button t-if="dashboard.bank_statements_source == 'file_import'" type="object" name="import_statement" class="btn btn-primary btn-sm">Import Statement</button>
+ </xpath>
+ <xpath expr='//div[@name="bank_cash_commands"]' position="after">
+ <t t-if="journal_type == 'bank'">
+ <a type="object" name="import_statement">Import Statement</a>
+ </t>
+ </xpath>
+ </field>
+ </record>
</odoo>
diff --git a/addons/account_bank_statement_import/account_journal.py b/addons/account_bank_statement_import/account_journal.py
new file mode 100644
index 00000000000..35267234bc6
--- /dev/null
+++ b/addons/account_bank_statement_import/account_journal.py
@@ -0,0 +1,21 @@
+# -*- coding: utf-8 -*-
+
+from openerp import models, fields, api
+
+class AccountJournal(models.Model):
+ _inherit = "account.journal"
+
+ bank_statements_source = fields.Selection(selection_add=[("file_import", "File Import")])
+
+ @api.multi
+ def import_statement(self):
+ """return action to import bank/cash statements. This button should be called only on journals with type =='bank'"""
+ self.bank_statements_source = 'file_import'
+ model = 'account.bank.statement'
+ action_name = 'action_account_bank_statement_import'
+ ir_model_obj = self.pool['ir.model.data']
+ model, action_id = ir_model_obj.get_object_reference(self._cr, self._uid, 'account_bank_statement_import', action_name)
+ action = self.pool[model].read(self._cr, self._uid, action_id, context=self.env.context)
+ # Note: this drops action['context'], which is a dict stored as a string, which is not easy to update
+ action.update({'context': (u"{'journal_id': " + str(self.id) + u"}")})
+ return action
diff --git a/addons/account_bank_statement_import/demo/partner_bank.xml b/addons/account_bank_statement_import/demo/partner_bank.xml
index 47e8fa76f48..09c14d42308 100644
--- a/addons/account_bank_statement_import/demo/partner_bank.xml
+++ b/addons/account_bank_statement_import/demo/partner_bank.xml
@@ -3,35 +3,31 @@
<data>
<record id="ofx_partner_bank_1" model="res.partner.bank">
- <field name="owner_name">Agrolait</field>
<field name="acc_number">00987654321</field>
<field name="partner_id" ref="base.res_partner_2"></field>
- <field name="state">bank</field>
- <field name="bank" ref="base.res_bank_1"/>
+ <field name="acc_type">bank</field>
+ <field name="bank_id" ref="base.res_bank_1"/>
</record>
<record id="ofx_partner_bank_2" model="res.partner.bank">
- <field name="owner_name">China Export</field>
<field name="acc_number">00987654322</field>
<field name="partner_id" ref="base.res_partner_3"></field>
- <field name="state">bank</field>
- <field name="bank" ref="base.res_bank_1"/>
+ <field name="acc_type">bank</field>
+ <field name="bank_id" ref="base.res_bank_1"/>
</record>
<record id="qif_partner_bank_1" model="res.partner.bank">
- <field name="owner_name">Delta PC</field>
<field name="acc_number">10987654320</field>
<field name="partner_id" ref="base.res_partner_4"></field>
- <field name="state">bank</field>
- <field name="bank" ref="base.res_bank_1"/>
+ <field name="acc_type">bank</field>
+ <field name="bank_id" ref="base.res_bank_1"/>
</record>
<record id="qif_partner_bank_2" model="res.partner.bank">
- <field name="owner_name">Epic Technologies</field>
<field name="acc_number">10987654322</field>
<field name="partner_id" ref="base.res_partner_5"></field>
- <field name="state">bank</field>
- <field name="bank" ref="base.res_bank_1"/>
+ <field name="acc_type">bank</field>
+ <field name="bank_id" ref="base.res_bank_1"/>
</record>
</data>
diff --git a/addons/account_bank_statement_import/wizard/journal_creation.py b/addons/account_bank_statement_import/wizard/journal_creation.py
index 3acd180ac50..82417ecb661 100644
--- a/addons/account_bank_statement_import/wizard/journal_creation.py
+++ b/addons/account_bank_statement_import/wizard/journal_creation.py
@@ -6,37 +6,10 @@ class account_bank_statement_import_journal_creation(models.TransientModel):
_name = 'account.bank.statement.import.journal.creation'
_description = 'Import Bank Statement Journal Creation Wizard'
- name = fields.Char('Journal Name', required=True)
- currency_id = fields.Many2one('res.currency', 'Currency', readonly=True)
- account_number = fields.Char('Account Number', readonly=True)
+ journal_id = fields.Many2one('account.journal', delegate=True, required=True, ondelete='cascade')
@api.multi
def create_journal(self):
- import_wiz_obj = self.env['account.bank.statement.import']
- journal_obj = self.env['account.journal']
- company = self.env.user.company_id
- wiz = self[0]
- currency_id = wiz.currency_id.id
- account_number = wiz.account_number
-
- bank_account_id = self.env.context.get('bank_account_id')
- if bank_account_id:
- vals = {'currency_id': currency_id, 'acc_name': account_number, 'account_type': 'bank'}
- vals_journal = journal_obj._prepare_bank_journal(company, vals)
- journal = journal_obj.create(vals_journal)
- self.env['res.partner.bank'].browse(bank_account_id).write({'journal_id': journal.id})
- else:
- #create the bank account that will trigger the journal and account.account creation
- res_partner_bank_vals = {
- 'acc_number': account_number,
- 'currency_id': currency_id,
- 'company_id': company.id,
- 'owner_name': company.partner_id.name,
- 'partner_id': company.partner_id.id,
- 'footer': True
- }
- self.env['res.partner.bank'].create(res_partner_bank_vals)
-
- # Finish the statement import
- statement_import_transient = import_wiz_obj.browse(self.env.context['statement_import_transient_id'])
- return statement_import_transient.import_file()
+ """ Create the journal (the record is automatically created in the process of calling this method) and reprocess the statement """
+ statement_import_transient = self.env['account.bank.statement.import'].browse(self.env.context['statement_import_transient_id'])
+ return statement_import_transient.with_context(journal_id=self.journal_id.id).import_file()
diff --git a/addons/account_bank_statement_import/wizard/journal_creation.xml b/addons/account_bank_statement_import/wizard/journal_creation.xml
index e64b6db7a60..10c29546bf8 100644
--- a/addons/account_bank_statement_import/wizard/journal_creation.xml
+++ b/addons/account_bank_statement_import/wizard/journal_creation.xml
@@ -7,12 +7,18 @@
<field name="model">account.bank.statement.import.journal.creation</field>
<field name="arch" type="xml">
<form string="Journal Creation">
- <p>The account of the statement you are importing is not yet recorded in Odoo. In order to proceed with the import, you need to create a bank account and journal using this form.</p>
+ <p>The account of the statement you are importing is not yet recorded in Odoo. In order to proceed with the import, you need to create a bank journal for this account.</p>
<p>Just click OK to create the account/journal and finish the import. If this was a mistake, hit cancel to abort the import.</p>
<group>
- <field name="name"/>
- <field name="currency_id" options="{'no_create': True}" attrs="{'invisible': [('currency_id', '=', False)]}"/>
- <field name="account_number"/>
+ <group>
+ <field name="name" string="Bank Journal Name"/>
+ <field name="bank_acc_number" readonly="1"/>
+ <field name="bank_id"/>
+ </group>
+ <group>
+ <field name="currency_id" readonly="1" groups="base.group_multi_currency"/>
+ <field name="company_id" groups="base.group_multi_company"/>
+ </group>
</group>
<footer>
<button name="create_journal" string="OK" type="object" class="btn-primary"/>
diff --git a/addons/base_iban/__openerp__.py b/addons/base_iban/__openerp__.py
index de4b7dfee8a..d384795dc00 100644
--- a/addons/base_iban/__openerp__.py
+++ b/addons/base_iban/__openerp__.py
@@ -13,9 +13,8 @@ with a single statement.
""",
'author': 'OpenERP SA',
'website': 'https://www.odoo.com',
- 'depends': ['base'],
+ 'depends': ['account_accountant'],
'demo': ['demo/iban_demo.xml'],
- 'data': ['base_iban_data.xml' , 'base_iban_view.xml'],
'installable': True,
'auto_install': False,
}
diff --git a/addons/base_iban/base_iban.py b/addons/base_iban/base_iban.py
index ccc6b123daa..ba650a11b72 100644
--- a/addons/base_iban/base_iban.py
+++ b/addons/base_iban/base_iban.py
@@ -2,7 +2,7 @@
import re
-from openerp import models, api, _
+from openerp import api, fields, models, _
from openerp.exceptions import UserError, ValidationError
@@ -40,34 +40,45 @@ def validate_iban(iban):
raise ValidationError(_("This IBAN does not pass the validation check, please verify it."))
-class res_partner_bank(models.Model):
+class ResPartnerBank(models.Model):
_inherit = "res.partner.bank"
+ @api.one
+ @api.depends('acc_type')
+ def _compute_acc_type(self):
+ try:
+ validate_iban(self.acc_number)
+ self.acc_type = 'iban'
+ except ValidationError:
+ super(ResPartnerBank, self)._compute_acc_type()
+
def get_bban(self):
- if self.state != 'iban':
+ if self.acc_type != 'iban':
raise UserError(_("Cannot compute the BBAN because the account number is not an IBAN."))
return get_bban_from_iban(self.acc_number)
- def create(self, cr, uid, vals, context=None):
- if (vals.get('state') == 'iban') and vals.get('acc_number'):
+ @api.model
+ def create(self, vals):
+ if (vals.get('acc_type') == 'iban') and vals.get('acc_number'):
vals['acc_number'] = pretty_iban(normalize_iban(vals['acc_number']))
- return super(res_partner_bank, self).create(cr, uid, vals, context)
+ return super(ResPartnerBank, self).create(vals)
- def write(self, cr, uid, ids, vals, context=None):
- if (vals.get('state') == 'iban') and vals.get('acc_number'):
+ @api.model
+ def write(self, vals):
+ if (vals.get('acc_type') == 'iban') and vals.get('acc_number'):
vals['acc_number'] = pretty_iban(normalize_iban(vals['acc_number']))
- return super(res_partner_bank, self).write(cr, uid, ids, vals, context)
+ return super(ResPartnerBank, self).write(vals)
@api.one
- @api.constrains('state', 'acc_number')
+ @api.constrains('acc_type', 'acc_number')
def _check_iban(self):
- if self.state == 'iban':
+ if self.acc_type == 'iban':
validate_iban(self.acc_number)
@api.one
- @api.constrains('state', 'bank_bic')
+ @api.constrains('acc_type', 'bank_bic')
def _check_bank_bic(self):
- if self.state == 'iban' and not self.bank_bic:
+ if self.acc_type == 'iban' and not self.bank_bic:
raise ValidationError(_("Please define BIC/Swift code on bank for bank type IBAN Account to make valid payments."))
diff --git a/addons/base_iban/base_iban_data.xml b/addons/base_iban/base_iban_data.xml
deleted file mode 100644
index e4f520db4d5..00000000000
--- a/addons/base_iban/base_iban_data.xml
+++ /dev/null
@@ -1,32 +0,0 @@
-<?xml version="1.0" encoding="utf-8"?>
-<openerp>
- <data noupdate="1">
-
- <!--
- Default bank account description
- -->
- <record id="bank_iban" model="res.partner.bank.type">
- <field name="name">IBAN Account</field>
- <field name="code">iban</field>
- <field name="format_layout">%(bank_name)s: IBAN %(acc_number)s - BIC %(bank_bic)s</field>
- </record>
- <record id="bank_swift_field" model="res.partner.bank.type.field">
- <field name="name">bank_bic</field>
- <field name="bank_type_id" ref="bank_iban"/>
- <field eval="False" name="required"/>
- <field eval="False" name="readonly"/>
- </record>
- <record id="bank_country_field" model="res.partner.bank.type.field">
- <field name="name">country_id</field>
- <field name="bank_type_id" ref="bank_iban"/>
- <field eval="False" name="required"/>
- <field eval="False" name="readonly"/>
- </record>
- <record id="bank_zip_field" model="res.partner.bank.type.field">
- <field name="name">zip</field>
- <field name="bank_type_id" ref="bank_iban"/>
- <field eval="False" name="required"/>
- <field eval="False" name="readonly"/>
- </record>
- </data>
-</openerp>
diff --git a/addons/base_iban/base_iban_view.xml b/addons/base_iban/base_iban_view.xml
deleted file mode 100644
index 30816750035..00000000000
--- a/addons/base_iban/base_iban_view.xml
+++ /dev/null
@@ -1,6 +0,0 @@
-<?xml version="1.0" encoding="utf-8"?>
-<openerp>
- <data>
-
- </data>
-</openerp>
diff --git a/addons/base_iban/demo/iban_demo.xml b/addons/base_iban/demo/iban_demo.xml
index 602c2b4163c..4e1e247f410 100644
--- a/addons/base_iban/demo/iban_demo.xml
+++ b/addons/base_iban/demo/iban_demo.xml
@@ -3,26 +3,23 @@
<data noupdate="1">
<record id="bank_iban_asustek" model="res.partner.bank">
- <field name="state">iban</field>
+ <field name="acc_type">iban</field>
<field name="acc_number">BE39103123456719</field>
- <field name="bank_name">Crelan</field>
- <field name="bank_bic">NICABEBB</field>
+ <field name="bank_id" ref="base.bank_crelan" />
<field name="partner_id" ref="base.res_partner_1"/>
</record>
<record id="bank_iban_china_export" model="res.partner.bank">
- <field name="state">iban</field>
+ <field name="acc_type">iban</field>
<field name="acc_number">SI56191000000123438</field>
- <field name="bank_name">CBC</field>
- <field name="bank_bic">CREGBEBB</field>
+ <field name="bank_id" ref="base.bank_cbc" />
<field name="partner_id" ref="base.res_partner_3"/>
</record>
<record id="bank_iban_main_partner" model="res.partner.bank">
- <field name="state">iban</field>
+ <field name="acc_type">iban</field>
<field name="acc_number">BE61310126985517</field>
- <field name="bank_name">ING</field>
- <field name="bank_bic">BBRUBEBB</field>
+ <field name="bank_id" ref="base.bank_ing" />
<field name="partner_id" ref="base.res_partner_4"/>
</record>
diff --git a/addons/crm/security/ir.model.access.csv b/addons/crm/security/ir.model.access.csv
index 8d213a23edd..75dbdcb9268 100644
--- a/addons/crm/security/ir.model.access.csv
+++ b/addons/crm/security/ir.model.access.csv
@@ -11,7 +11,6 @@ access_res_partner,res.partner.crm.user,base.model_res_partner,base.group_sale_s
access_res_partner_category,res.partner.category.crm.user,base.model_res_partner_category,base.group_sale_salesman,1,1,1,0
mail_mailgate_thread,mail.thread,mail.model_mail_thread,base.group_sale_salesman,1,1,1,1
access_base_action_rule_manager,base.action.rule manager,base_action_rule.model_base_action_rule,base.group_sale_manager,1,1,1,1
-access_res_partner_bank_type_crm_user,res.partner.bank.type.crm.user,base.model_res_partner_bank_type,base.group_sale_salesman,1,0,0,0
access_crm_lead_partner_manager,crm.lead.partner.manager,model_crm_lead,base.group_partner_manager,1,0,0,0
access_crm_lead_tag,crm_lead_tag,model_crm_lead_tag,base.group_user,1,0,0,0
access_crm_lead_tag_salesman,crm_lead_tag salesman,model_crm_lead_tag,base.group_sale_salesman,1,1,1,0
diff --git a/addons/hr_payroll_account/test/hr_payroll_account.yml b/addons/hr_payroll_account/test/hr_payroll_account.yml
index 14390d358cc..7a7f73ce826 100644
--- a/addons/hr_payroll_account/test/hr_payroll_account.yml
+++ b/addons/hr_payroll_account/test/hr_payroll_account.yml
@@ -6,8 +6,8 @@
!record {model: res.partner.bank, id: res_partner_bank_0}:
acc_number: '001-9876543-21'
partner_id: base.res_partner_12
- state: bank
- bank: base.res_bank_1
+ acc_type: bank
+ bank_id: base.res_bank_1
-
I create a new employee "John".
-
diff --git a/addons/l10n_in_hr_payroll/l10n_in_hr_payroll.py b/addons/l10n_in_hr_payroll/l10n_in_hr_payroll.py
index b1aa436e5f3..01cda030979 100644
--- a/addons/l10n_in_hr_payroll/l10n_in_hr_payroll.py
+++ b/addons/l10n_in_hr_payroll/l10n_in_hr_payroll.py
@@ -169,7 +169,7 @@ class hr_payslip_run(osv.osv):
'company_id': users[0].company_id.id,
'name': run.name,
'date': run.date_end,
- 'bank_id': users[0].company_id.bank_ids and users[0].company_id.bank_ids[0].id or False
+ 'bank_id': users[0].company_id.partner_id.bank_ids and users[0].company_id.partner_id.bank_ids[0].id or False
}
advice_id = advice_pool.create(cr, uid, advice_data, context=context)
slip_ids = []
diff --git a/addons/l10n_in_hr_payroll/test/payment_advice_batch.yml b/addons/l10n_in_hr_payroll/test/payment_advice_batch.yml
index d1a1436b50b..9f3ec61dda4 100644
--- a/addons/l10n_in_hr_payroll/test/payment_advice_batch.yml
+++ b/addons/l10n_in_hr_payroll/test/payment_advice_batch.yml
@@ -6,8 +6,8 @@
!record {model: res.partner.bank, id: res_partner_bank_0}:
acc_number: '3025632343043'
partner_id: base.res_partner_21
- state: bank
- bank: base.res_bank_1
+ acc_type: bank
+ bank_id: base.res_bank_1
-
I create a new employee “Rahul”
-
diff --git a/addons/l10n_in_hr_payroll/views/report_payrolladvice.xml b/addons/l10n_in_hr_payroll/views/report_payrolladvice.xml
index 03bb91f567d..b242deae70b 100644
--- a/addons/l10n_in_hr_payroll/views/report_payrolladvice.xml
+++ b/addons/l10n_in_hr_payroll/views/report_payrolladvice.xml
@@ -25,7 +25,7 @@
<tr>
<td>
<p class="text-center">
- <strong>Payment Advice from <span t-esc="o.name"/> A/C no. <span t-esc="o.company_id.bank_ids and o.company_id.bank_ids[0].acc_number"/> form period <span t-esc="get_month(o.date)['from_name']"/> to <span t-esc="get_month(o.date)['to_name']"/></strong>
+ <strong>Payment Advice from <span t-esc="o.name"/> A/C no. <span t-esc="o.company_id.partner_id.bank_ids and o.company_id.partner_id.bank_ids[0].acc_number"/> form period <span t-esc="get_month(o.date)['from_name']"/> to <span t-esc="get_month(o.date)['to_name']"/></strong>
</p>
</td>
</tr>
@@ -89,4 +89,4 @@
</t>
</template>
</data>
-</openerp> \ No newline at end of file
+</openerp>
diff --git a/addons/membership/tests/test_membership.py b/addons/membership/tests/test_membership.py
index d4fc16c60dc..717e166a29f 100644
--- a/addons/membership/tests/test_membership.py
+++ b/addons/membership/tests/test_membership.py
@@ -50,8 +50,8 @@ class TestMembership(TestMembershipCommon):
'membership: after opening the invoice, customer should be in invoiced status')
# the invoice is paid -> customer goes to paid status
- bank_journals = self.env['account.journal'].search([('type', '=', 'bank')])
- invoice.pay_and_reconcile(bank_journals[0], invoice.amount_total)
+ bank_journal = self.env['account.journal'].create({'name': 'Bank', 'type': 'bank', 'code': 'BNK67'})
+ invoice.pay_and_reconcile(bank_journal, invoice.amount_total)
self.assertEqual(
self.partner_1.membership_state, 'paid',
'membership: after paying the invoice, customer should be in paid status')
diff --git a/addons/payment_transfer/models/payment_acquirer.py b/addons/payment_transfer/models/payment_acquirer.py
index b55fb055ab7..c691529aeae 100644
--- a/addons/payment_transfer/models/payment_acquirer.py
+++ b/addons/payment_transfer/models/payment_acquirer.py
@@ -23,10 +23,10 @@ class TransferPaymentAcquirer(osv.Model):
return '/payment/transfer/feedback'
def _format_transfer_data(self, cr, uid, context=None):
- bank_ids = [bank.id for bank in self.pool['res.users'].browse(cr, uid, uid, context=context).company_id.bank_ids]
+ company_id = self.pool['res.users'].browse(cr, uid, uid, context=context).company_id.id
# filter only bank accounts marked as visible
- bank_ids = self.pool['res.partner.bank'].search(cr, uid, [('id', 'in', bank_ids), ('footer', '=', True)], context=context)
- accounts = self.pool['res.partner.bank'].name_get(cr, uid, bank_ids, context=context)
+ journal_ids = self.pool['account.journal'].search(cr, uid, [('type', '=', 'bank'), ('display_on_footer', '=', True), ('company_id', '=', company_id)], context=context)
+ accounts = self.pool['account.journal'].browse(cr, uid, journal_ids, context=context).mapped('bank_account_id').name_get()
bank_title = _('Bank Accounts') if len(accounts) > 1 else _('Bank Account')
bank_accounts = ''.join(['<ul>'] + ['<li>%s</li>' % name for id, name in accounts] + ['</ul>'])
post_msg = '''<div>
diff --git a/addons/purchase/tests/test_purchase_to_invoice.py b/addons/purchase/tests/test_purchase_to_invoice.py
index ff19456576d..3478df9c1d5 100644
--- a/addons/purchase/tests/test_purchase_to_invoice.py
+++ b/addons/purchase/tests/test_purchase_to_invoice.py
@@ -21,7 +21,7 @@ class TestPurchase(common.TransactionCase):
self.env['product.product'].browse(product_id).product_tmpl_id.write({'property_account_expense_id': account_exp_id})
# Create Purchase Journal
- self.env['account.journal'].create({'name': 'Purchase Journal - Test', 'code': 'PTPJ', 'type': 'purchase', 'company_id': company_id})
+ self.env['account.journal'].create({'name': 'Purchase Journal - Test', 'code': 'PTPJ', 'type': 'purchase'})
# In order to test, I create new user and applied Invoicing & Payments group.
user = self.env['res.users'].with_context({'no_reset_password': True}).create({
diff --git a/addons/report/views/layouts.xml b/addons/report/views/layouts.xml
index 9aa9444257d..e6ade1e8d4d 100644
--- a/addons/report/views/layouts.xml
+++ b/addons/report/views/layouts.xml
@@ -92,16 +92,8 @@
<li t-if="company.website">Website: <span t-field="company.website"/></li>
</ul>
- <ul t-if="not company.custom_footer" class="list-inline">
+ <ul t-if="not company.custom_footer" class="list-inline" name="financial_infos">
<li t-if="company.vat">TIN: <span t-field="company.vat"/></li>
- <t t-set="is_first" t-value="True"/>
- <t t-foreach="company.bank_ids" t-as="bank">
- <t t-if="bank.footer">
- <li t-if="(is_first and company.vat) or (not is_first)">&amp;bull;</li>
- <li><span t-esc="bank.bank_name"/>: (<span t-esc="bank.bank_bic"/>) <span t-esc="bank.acc_number"/></li>
- <t t-set="is_first" t-value="False"/>
- </t>
- </t>
</ul>
<t t-if="company.custom_footer">
diff --git a/addons/sale/security/ir.model.access.csv b/addons/sale/security/ir.model.access.csv
index bbcf14f53f4..acb83f33223 100644
--- a/addons/sale/security/ir.model.access.csv
+++ b/addons/sale/security/ir.model.access.csv
@@ -21,8 +21,6 @@ access_product_product_sale_user,product.product sale use,product.model_product_
access_account_tax_user,account.tax.user,account.model_account_tax,base.group_sale_salesman,1,0,0,0
access_ir_attachment_sales,ir.attachment.sales,base.model_ir_attachment,base.group_sale_salesman,1,1,1,0
access_ir_attachment_manager,ir.attachment.manager,base.model_ir_attachment,base.group_sale_manager,1,1,1,1
-access_res_partner_bank_type_user,res.partner.bank.type.user,base.model_res_partner_bank_type,base.group_sale_salesman,1,0,0,0
-access_res_partner_bank_type_field_user,res.partner.bank.type.field.user,base.model_res_partner_bank_type_field,base.group_sale_salesman,1,0,0,0
access_product_uom_user,product.uom.user,product.model_product_uom,base.group_sale_salesman,1,0,0,0
access_product_pricelist_sale_user,product.pricelist.sale.user,product.model_product_pricelist,base.group_sale_salesman,1,0,0,0
access_account_account_salesman,account_account salesman,account.model_account_account,base.group_sale_salesman,1,0,0,0
diff --git a/addons/sale/tests/test_sale_to_invoice.py b/addons/sale/tests/test_sale_to_invoice.py
index c914bceeb5e..47b6a7b20bb 100644
--- a/addons/sale/tests/test_sale_to_invoice.py
+++ b/addons/sale/tests/test_sale_to_invoice.py
@@ -22,9 +22,6 @@ class TestSale(TestMail):
group_id = IrModelData.xmlid_to_res_id('account.group_account_invoice') or False
product_id = IrModelData.xmlid_to_res_id('product.product_category_3') or False
company_id = IrModelData.xmlid_to_res_id('base.main_company') or False
- company = self.env['res.company'].browse(company_id)
- journal_vals = journal_obj._prepare_bank_journal(company, {'account_type': 'bank', 'acc_name': 'BNK'})
- journal = journal_obj.create(journal_vals)
# Usefull accounts
user_type_id = IrModelData.xmlid_to_res_id('account.data_account_type_revenue')
diff --git a/addons/stock_dropshipping/tests/test_invoicing.py b/addons/stock_dropshipping/tests/test_invoicing.py
index b93d7346bfb..ffe217b1db4 100644
--- a/addons/stock_dropshipping/tests/test_invoicing.py
+++ b/addons/stock_dropshipping/tests/test_invoicing.py
@@ -18,7 +18,7 @@ class TestCreateInvoice(TransactionCase):
dropship_route = self.env.ref('stock_dropshipping.route_drop_shipping')
# Create Sale Journal
- self.env['account.journal'].create({'name': 'Purchase Journal - Test', 'code': 'DSTPJ', 'type': 'purchase', 'company_id': self.env.ref('base.main_company').id})
+ self.env['account.journal'].create({'name': 'Purchase Journal - Test', 'code': 'DSTPJ', 'type': 'purchase'})
user_type_id = self.env.ref('account.data_account_type_payable')
account_pay_id = self.env['account.account'].create({'code': 'X1012', 'name': 'Purchase - Test Payable Account', 'user_type_id': user_type_id.id, 'reconcile': True})