161 lines
7.5 KiB
Python
161 lines
7.5 KiB
Python
# -*- coding: utf-8 -*-
|
|
from odoo.addons.account.tests.common import AccountTestInvoicingCommon
|
|
from odoo.tests import tagged
|
|
from odoo import fields
|
|
|
|
|
|
@tagged('post_install', '-at_install')
|
|
class TestAccountInvoiceReport(AccountTestInvoicingCommon):
|
|
|
|
@classmethod
|
|
def setUpClass(cls):
|
|
super().setUpClass()
|
|
cls.other_currency = cls.setup_other_currency('EUR')
|
|
cls.company_data_2 = cls.setup_other_company()
|
|
|
|
cls.invoices = cls.env['account.move'].create([
|
|
{
|
|
'move_type': 'out_invoice',
|
|
'partner_id': cls.partner_a.id,
|
|
'invoice_date': fields.Date.from_string('2016-01-01'),
|
|
'currency_id': cls.other_currency.id,
|
|
'invoice_line_ids': [
|
|
(0, None, {
|
|
'product_id': cls.product_a.id,
|
|
'quantity': 3,
|
|
'price_unit': 750,
|
|
}),
|
|
(0, None, {
|
|
'product_id': cls.product_a.id,
|
|
'quantity': 1,
|
|
'price_unit': 3000,
|
|
}),
|
|
]
|
|
},
|
|
{
|
|
'move_type': 'out_receipt',
|
|
'invoice_date': fields.Date.from_string('2016-01-01'),
|
|
'currency_id': cls.other_currency.id,
|
|
'invoice_line_ids': [
|
|
(0, None, {
|
|
'product_id': cls.product_a.id,
|
|
'quantity': 1,
|
|
'price_unit': 6000,
|
|
}),
|
|
]
|
|
},
|
|
{
|
|
'move_type': 'out_refund',
|
|
'partner_id': cls.partner_a.id,
|
|
'invoice_date': fields.Date.from_string('2017-01-01'),
|
|
'currency_id': cls.other_currency.id,
|
|
'invoice_line_ids': [
|
|
(0, None, {
|
|
'product_id': cls.product_a.id,
|
|
'quantity': 1,
|
|
'price_unit': 1200,
|
|
}),
|
|
]
|
|
},
|
|
{
|
|
'move_type': 'in_invoice',
|
|
'partner_id': cls.partner_a.id,
|
|
'invoice_date': fields.Date.from_string('2016-01-01'),
|
|
'currency_id': cls.other_currency.id,
|
|
'invoice_line_ids': [
|
|
(0, None, {
|
|
'product_id': cls.product_a.id,
|
|
'quantity': 1,
|
|
'price_unit': 60,
|
|
}),
|
|
]
|
|
},
|
|
{
|
|
'move_type': 'in_receipt',
|
|
'partner_id': cls.partner_a.id,
|
|
'invoice_date': fields.Date.from_string('2016-01-01'),
|
|
'currency_id': cls.other_currency.id,
|
|
'invoice_line_ids': [
|
|
(0, None, {
|
|
'product_id': cls.product_a.id,
|
|
'quantity': 1,
|
|
'price_unit': 60,
|
|
}),
|
|
]
|
|
},
|
|
{
|
|
'move_type': 'in_refund',
|
|
'partner_id': cls.partner_a.id,
|
|
'invoice_date': fields.Date.from_string('2017-01-01'),
|
|
'currency_id': cls.other_currency.id,
|
|
'invoice_line_ids': [
|
|
(0, None, {
|
|
'product_id': cls.product_a.id,
|
|
'quantity': 1,
|
|
'price_unit': 12,
|
|
}),
|
|
]
|
|
},
|
|
{
|
|
'move_type': 'out_refund',
|
|
'partner_id': cls.partner_a.id,
|
|
'invoice_date': fields.Date.from_string('2017-01-01'),
|
|
'currency_id': cls.other_currency.id,
|
|
'invoice_line_ids': [
|
|
(0, None, {
|
|
'product_id': cls.product_a.id,
|
|
'quantity': 1,
|
|
'price_unit': 2400,
|
|
}),
|
|
]
|
|
},
|
|
])
|
|
|
|
def assertInvoiceReportValues(self, expected_values_list):
|
|
reports = self.env['account.invoice.report'].search([('company_id', '=', self.company_data['company'].id)], order='price_subtotal DESC, quantity ASC')
|
|
expected_values_dict = [{
|
|
'price_average': vals[0],
|
|
'price_subtotal': vals[1],
|
|
'quantity': vals[2],
|
|
'price_margin': vals[3],
|
|
'inventory_value': vals[4],
|
|
} for vals in expected_values_list]
|
|
|
|
self.assertRecordValues(reports, expected_values_dict)
|
|
|
|
def test_invoice_report_multiple_types(self):
|
|
self.assertInvoiceReportValues([
|
|
# pylint: disable=bad-whitespace
|
|
# price_average, price_subtotal, quantity, price_margin, inventory_value
|
|
[ 2000, 2000, 1, 1200, -800], # price_unit = 6000, currency.rate = 3.0
|
|
[ 1000, 1000, 1, 200, -800], # price_unit = 3000, currency.rate = 3.0
|
|
[ 250, 750, 3, -1650, -2400], # price_unit = 750, currency.rate = 2.0
|
|
[ 6, 6, 1, 0, -800], # price_unit = 12, currency.rate = 2.0
|
|
[ 20, -20, -1, 0, 800], # price_unit = 60, currency.rate = 3.0
|
|
[ 20, -20, -1, 0, 800], # price_unit = 60, currency.rate = 3.0
|
|
[ 600, -600, -1, 200, 800], # price_unit = 1200, currency.rate = 2.0
|
|
[ 1200, -1200, -1, -400, 800], # price_unit = 2400, currency.rate = 2.0
|
|
])
|
|
|
|
def test_invoice_report_multicompany_product_cost(self):
|
|
"""
|
|
In a multicompany environment, if you define one product with different standard price per company
|
|
the invoice analysis report should only display the product from the company
|
|
Standard Price in Company A: 800 (default setup)
|
|
Standard Price in Company B: 700
|
|
-> invoice report for Company A should remain the same
|
|
"""
|
|
self.product_a.with_company(self.company_data_2.get('company')).write({'standard_price': 700.0})
|
|
self.assertInvoiceReportValues([
|
|
# pylint: disable=bad-whitespace
|
|
# price_average, price_subtotal, quantity, price_margin, inventory_value
|
|
[ 2000, 2000, 1, 1200, -800], # price_unit = 6000, currency.rate = 3.0
|
|
[ 1000, 1000, 1, 200, -800], # price_unit = 3000, currency.rate = 3.0
|
|
[ 250, 750, 3, -1650, -2400], # price_unit = 750, currency.rate = 2.0
|
|
[ 6, 6, 1, 0, -800], # price_unit = 12, currency.rate = 2.0
|
|
[ 20, -20, -1, 0, 800], # price_unit = 60, currency.rate = 3.0
|
|
[ 20, -20, -1, 0, 800], # price_unit = 60, currency.rate = 3.0
|
|
[ 600, -600, -1, 200, 800], # price_unit = 1200, currency.rate = 2.0
|
|
[ 1200, -1200, -1, -400, 800], # price_unit = 2400, currency.rate = 2.0
|
|
])
|