# Part of Odoo. See LICENSE file for full copyright and licensing details.
from odoo import Command, fields
from odoo.addons.hr_expense.tests.common import TestExpenseCommon
from odoo.addons.sale.tests.common import TestSaleCommon
from odoo.tests import tagged
@tagged('post_install', '-at_install')
class TestSaleExpense(TestExpenseCommon, TestSaleCommon):
def test_sale_expense(self):
""" Test the behaviour of sales orders when managing expenses """
# create a so with a product invoiced on delivery
so = self.env['sale.order'].create({
'partner_id': self.partner_a.id,
'partner_invoice_id': self.partner_a.id,
'partner_shipping_id': self.partner_a.id,
'order_line': [Command.create({
'name': self.company_data['product_delivery_no'].name,
'product_id': self.company_data['product_delivery_no'].id,
'product_uom_qty': 2,
'product_uom': self.company_data['product_delivery_no'].uom_id.id,
'price_unit': self.company_data['product_delivery_no'].list_price,
})],
})
so.action_confirm()
analytic_account = self.env['account.analytic.account'].create(so._prepare_analytic_account_data())
init_price = so.amount_total
# create some expense and validate it (expense at cost)
# Submit to Manager
sheet = self.env['hr.expense.sheet'].create({
'name': 'Expense for John Smith 1',
'employee_id': self.expense_employee.id,
'journal_id': self.company_data['default_journal_purchase'].id,
})
exp = self.env['hr.expense'].create({
'name': 'Air Travel',
'product_id': self.company_data['product_delivery_cost'].id,
'analytic_distribution': {analytic_account.id: 100},
'quantity': 11.30,
'employee_id': self.expense_employee.id,
'sheet_id': sheet.id,
'sale_order_id': so.id,
})
sheet.action_submit_sheet()
# Approve
sheet.action_approve_expense_sheets()
# Post Expense Entries
sheet.action_sheet_move_post()
# expense should now be in sales order
self.assertIn(self.company_data['product_delivery_cost'], so.mapped('order_line.product_id'), 'Sale Expense: expense product should be in so')
sol = so.order_line.filtered(lambda sol: sol.product_id.id == self.company_data['product_delivery_cost'].id)
self.assertEqual((sol.price_unit, sol.qty_delivered), (55.0, 11.3), 'Sale Expense: error when invoicing an expense at cost')
self.assertEqual(so.amount_total, init_price + exp.total_amount, 'Sale Expense: price of so should be updated after adding expense')
# create some expense and validate it (expense at sale price)
init_price = so.amount_total
prod_exp_2 = self.env['product.product'].create({
'name': 'Car Travel',
'expense_policy': 'sales_price',
'type': 'service',
'can_be_expensed': True,
'invoice_policy': 'delivery',
'list_price': 0.50,
'uom_id': self.env.ref('uom.product_uom_km').id,
'uom_po_id': self.env.ref('uom.product_uom_km').id,
'standard_price': 0.15,
})
# Submit to Manager
sheet = self.env['hr.expense.sheet'].create({
'name': 'Expense for John Smith 2',
'employee_id': self.expense_employee.id,
'journal_id': self.company_data['default_journal_purchase'].id,
})
exp = self.env['hr.expense'].create({
'name': 'Car Travel',
'product_id': prod_exp_2.id,
'analytic_distribution': {analytic_account.id: 100},
'product_uom_id': self.env.ref('uom.product_uom_km').id,
'quantity': 100,
'employee_id': self.expense_employee.id,
'sheet_id': sheet.id,
'sale_order_id': so.id,
})
sheet.action_submit_sheet()
# Approve
sheet.action_approve_expense_sheets()
# Post Expense Entries
sheet.action_sheet_move_post()
# expense should now be in sales order
self.assertIn(prod_exp_2, so.mapped('order_line.product_id'), 'Sale Expense: expense product should be in so')
sol = so.order_line.filtered(lambda sol: sol.product_id.id == prod_exp_2.id)
self.assertEqual((sol.price_unit, sol.qty_delivered), (prod_exp_2.list_price, 100.0), 'Sale Expense: error when invoicing an expense at cost')
self.assertEqual(so.amount_untaxed, init_price + (prod_exp_2.list_price * 100.0), 'Sale Expense: price of so should be updated after adding expense')
# self.assertTrue(so.invoice_status, 'no', 'Sale Expense: expenses should not impact the invoice_status of the so')
# both expenses should be invoiced
inv = so._create_invoices()
self.assertEqual(inv.amount_untaxed, 621.5 + (prod_exp_2.list_price * 100.0), 'Sale Expense: invoicing of expense is wrong')
def test_expense_multi_id_analytic_distribution(self):
"""
Test conversion of analytic_distribution dict into account numbers when a hr.expense.sheet containing
a hr.expense with an analytic_distribution having 2+ account ids
"""
expensed_product = self.env['product.product'].create({
'name': 'test product',
'can_be_expensed': True,
'type': 'service',
'invoice_policy': 'order',
'standard_price': 100,
'expense_policy': 'cost',
})
sale_order = self.env['sale.order'].create({
'partner_id': self.partner_a.id,
'partner_invoice_id': self.partner_a.id,
'partner_shipping_id': self.partner_a.id,
'order_line': [Command.create({'product_id': self.product_b.id})],
})
sale_order.action_confirm()
sale_order._create_invoices()
analytic_account_3 = self.env['account.analytic.account'].create({
'name': 'analytic_account_3',
'plan_id': self.analytic_plan.id,
})
expense_sheet = self.env['hr.expense.sheet'].create({
'name': 'Test Expense Report',
'employee_id': self.expense_employee.id,
'company_id': self.company_data['company'].id,
'expense_line_ids': [Command.create({
'employee_id': self.expense_employee.id,
'product_id': expensed_product.id,
'quantity': 1000.00,
'date': fields.Date.today(),
'company_id': self.company_data['company'].id,
'currency_id': self.company_data['currency'].id,
'analytic_distribution': {
f'{self.analytic_account_1.id},{self.analytic_account_2.id}': 60,
f'{analytic_account_3.id}': 40,
},
'sale_order_id': sale_order.id,
})],
})
expense_sheet.action_submit_sheet()
expense_sheet.action_approve_expense_sheets()
expense_sheet.action_sheet_move_post()
self.assertTrue(self.env['account.move'].search([('expense_sheet_id', '=', expense_sheet.id)], limit=1))