496 lines
24 KiB
Python
496 lines
24 KiB
Python
|
# -*- coding: utf-8 -*-
|
||
|
|
# Part of Odoo. See LICENSE file for full copyright and licensing details.
|
||
|
|
import unittest
|
||
|
|
from odoo.addons.stock_landed_costs.tests.common import TestStockLandedCostsCommon
|
||
|
|
from odoo.addons.stock_landed_costs.tests.test_stockvaluationlayer import TestStockValuationLCCommon
|
||
|
|
from odoo.addons.stock_account.tests.test_stockvaluation import _create_accounting_data
|
||
|
|
|
||
|
|
from odoo.fields import Date
|
||
|
|
from odoo.tests import tagged, Form
|
||
|
|
|
||
|
|
|
||
|
|
@tagged('post_install', '-at_install')
|
||
|
|
class TestLandedCosts(TestStockLandedCostsCommon):
|
||
|
|
|
||
|
|
@classmethod
|
||
|
|
def setUpClass(cls):
|
||
|
|
super().setUpClass()
|
||
|
|
# Create picking incoming shipment
|
||
|
|
cls.picking_in = cls.Picking.create({
|
||
|
|
'partner_id': cls.supplier_id,
|
||
|
|
'picking_type_id': cls.warehouse.in_type_id.id,
|
||
|
|
'location_id': cls.supplier_location_id,
|
||
|
|
'state': 'draft',
|
||
|
|
'location_dest_id': cls.warehouse.lot_stock_id.id})
|
||
|
|
cls.Move.create({
|
||
|
|
'name': cls.product_refrigerator.name,
|
||
|
|
'product_id': cls.product_refrigerator.id,
|
||
|
|
'product_uom_qty': 5,
|
||
|
|
'product_uom': cls.product_refrigerator.uom_id.id,
|
||
|
|
'picking_id': cls.picking_in.id,
|
||
|
|
'location_id': cls.supplier_location_id,
|
||
|
|
'location_dest_id': cls.warehouse.lot_stock_id.id})
|
||
|
|
cls.Move.create({
|
||
|
|
'name': cls.product_oven.name,
|
||
|
|
'product_id': cls.product_oven.id,
|
||
|
|
'product_uom_qty': 10,
|
||
|
|
'product_uom': cls.product_oven.uom_id.id,
|
||
|
|
'picking_id': cls.picking_in.id,
|
||
|
|
'location_id': cls.supplier_location_id,
|
||
|
|
'location_dest_id': cls.warehouse.lot_stock_id.id})
|
||
|
|
# Create picking outgoing shipment
|
||
|
|
cls.picking_out = cls.Picking.create({
|
||
|
|
'partner_id': cls.customer_id,
|
||
|
|
'picking_type_id': cls.warehouse.out_type_id.id,
|
||
|
|
'location_id': cls.warehouse.lot_stock_id.id,
|
||
|
|
'state': 'draft',
|
||
|
|
'location_dest_id': cls.customer_location_id})
|
||
|
|
cls.Move.create({
|
||
|
|
'name': cls.product_refrigerator.name,
|
||
|
|
'product_id': cls.product_refrigerator.id,
|
||
|
|
'product_uom_qty': 2,
|
||
|
|
'product_uom': cls.product_refrigerator.uom_id.id,
|
||
|
|
'picking_id': cls.picking_out.id,
|
||
|
|
'location_id': cls.warehouse.lot_stock_id.id,
|
||
|
|
'location_dest_id': cls.customer_location_id})
|
||
|
|
|
||
|
|
def test_00_landed_costs_on_incoming_shipment(self):
|
||
|
|
""" Test landed cost on incoming shipment """
|
||
|
|
#
|
||
|
|
# (A) Purchase product
|
||
|
|
|
||
|
|
# Services Quantity Weight Volume
|
||
|
|
# -----------------------------------------------------
|
||
|
|
# 1. Refrigerator 5 10 1
|
||
|
|
# 2. Oven 10 20 1.5
|
||
|
|
|
||
|
|
# (B) Add some costs on purchase
|
||
|
|
|
||
|
|
# Services Amount Split Method
|
||
|
|
# -------------------------------------------
|
||
|
|
# 1.labour 10 By Equal
|
||
|
|
# 2.brokerage 150 By Quantity
|
||
|
|
# 3.transportation 250 By Weight
|
||
|
|
# 4.packaging 20 By Volume
|
||
|
|
|
||
|
|
self.landed_cost.categ_id.property_valuation = 'real_time'
|
||
|
|
|
||
|
|
# Process incoming shipment
|
||
|
|
income_ship = self._process_incoming_shipment()
|
||
|
|
# Create landed costs
|
||
|
|
stock_landed_cost = self._create_landed_costs({
|
||
|
|
'equal_price_unit': 10,
|
||
|
|
'quantity_price_unit': 150,
|
||
|
|
'weight_price_unit': 250,
|
||
|
|
'volume_price_unit': 20}, income_ship)
|
||
|
|
# Compute landed costs
|
||
|
|
stock_landed_cost.compute_landed_cost()
|
||
|
|
|
||
|
|
valid_vals = {
|
||
|
|
'equal': 5.0,
|
||
|
|
'by_quantity_refrigerator': 50.0,
|
||
|
|
'by_quantity_oven': 100.0,
|
||
|
|
'by_weight_refrigerator': 50.0,
|
||
|
|
'by_weight_oven': 200,
|
||
|
|
'by_volume_refrigerator': 5.0,
|
||
|
|
'by_volume_oven': 15.0}
|
||
|
|
|
||
|
|
# Check valuation adjustment line recognized or not
|
||
|
|
self._validate_additional_landed_cost_lines(stock_landed_cost, valid_vals)
|
||
|
|
# Validate the landed cost.
|
||
|
|
stock_landed_cost.button_validate()
|
||
|
|
|
||
|
|
self.assertRecordValues(stock_landed_cost.account_move_id.line_ids, [
|
||
|
|
{'name': 'equal split - Refrigerator', 'balance': 5},
|
||
|
|
{'name': 'equal split - Refrigerator', 'balance': -5},
|
||
|
|
{'name': 'split by quantity - Refrigerator', 'balance': 50},
|
||
|
|
{'name': 'split by quantity - Refrigerator', 'balance': -50},
|
||
|
|
{'name': 'split by weight - Refrigerator', 'balance': 50},
|
||
|
|
{'name': 'split by weight - Refrigerator', 'balance': -50},
|
||
|
|
{'name': 'split by volume - Refrigerator', 'balance': 5},
|
||
|
|
{'name': 'split by volume - Refrigerator', 'balance': -5},
|
||
|
|
{'name': 'equal split - Microwave Oven', 'balance': 5},
|
||
|
|
{'name': 'equal split - Microwave Oven', 'balance': -5},
|
||
|
|
{'name': 'split by quantity - Microwave Oven', 'balance': 100},
|
||
|
|
{'name': 'split by quantity - Microwave Oven', 'balance': -100},
|
||
|
|
{'name': 'split by weight - Microwave Oven', 'balance': 200},
|
||
|
|
{'name': 'split by weight - Microwave Oven', 'balance': -200},
|
||
|
|
{'name': 'split by volume - Microwave Oven', 'balance': 15},
|
||
|
|
{'name': 'split by volume - Microwave Oven', 'balance': -15},
|
||
|
|
])
|
||
|
|
|
||
|
|
def test_00_landed_costs_on_incoming_shipment_without_real_time(self):
|
||
|
|
if self.env.company.chart_template != 'generic_coa':
|
||
|
|
raise unittest.SkipTest('Skip this test as it works only with `generic_coa`')
|
||
|
|
# Test landed cost on incoming shipment
|
||
|
|
#
|
||
|
|
# (A) Purchase product
|
||
|
|
|
||
|
|
# Services Quantity Weight Volume
|
||
|
|
# -----------------------------------------------------
|
||
|
|
# 1. Refrigerator 5 10 1
|
||
|
|
# 2. Oven 10 20 1.5
|
||
|
|
|
||
|
|
# (B) Add some costs on purchase
|
||
|
|
|
||
|
|
# Services Amount Split Method
|
||
|
|
# -------------------------------------------
|
||
|
|
# 1.labour 10 By Equal
|
||
|
|
# 2.brokerage 150 By Quantity
|
||
|
|
# 3.transportation 250 By Weight
|
||
|
|
# 4.packaging 20 By Volume
|
||
|
|
|
||
|
|
self.product_refrigerator.write({"categ_id": self.categ_manual_periodic.id})
|
||
|
|
self.product_oven.write({"categ_id": self.categ_manual_periodic.id})
|
||
|
|
# Process incoming shipment
|
||
|
|
income_ship = self._process_incoming_shipment()
|
||
|
|
# Create landed costs
|
||
|
|
stock_landed_cost = self._create_landed_costs({
|
||
|
|
'equal_price_unit': 10,
|
||
|
|
'quantity_price_unit': 150,
|
||
|
|
'weight_price_unit': 250,
|
||
|
|
'volume_price_unit': 20}, income_ship)
|
||
|
|
# Compute landed costs
|
||
|
|
stock_landed_cost.compute_landed_cost()
|
||
|
|
|
||
|
|
valid_vals = {
|
||
|
|
'equal': 5.0,
|
||
|
|
'by_quantity_refrigerator': 50.0,
|
||
|
|
'by_quantity_oven': 100.0,
|
||
|
|
'by_weight_refrigerator': 50.0,
|
||
|
|
'by_weight_oven': 200,
|
||
|
|
'by_volume_refrigerator': 5.0,
|
||
|
|
'by_volume_oven': 15.0}
|
||
|
|
|
||
|
|
# Check valuation adjustment line recognized or not
|
||
|
|
self._validate_additional_landed_cost_lines(stock_landed_cost, valid_vals)
|
||
|
|
# Validate the landed cost.
|
||
|
|
stock_landed_cost.button_validate()
|
||
|
|
self.assertFalse(stock_landed_cost.account_move_id)
|
||
|
|
|
||
|
|
def test_01_negative_landed_costs_on_incoming_shipment(self):
|
||
|
|
""" Test negative landed cost on incoming shipment """
|
||
|
|
#
|
||
|
|
# (A) Purchase Product
|
||
|
|
|
||
|
|
# Services Quantity Weight Volume
|
||
|
|
# -----------------------------------------------------
|
||
|
|
# 1. Refrigerator 5 10 1
|
||
|
|
# 2. Oven 10 20 1.5
|
||
|
|
|
||
|
|
# (B) Sale refrigerator's part of the quantity
|
||
|
|
|
||
|
|
# (C) Add some costs on purchase
|
||
|
|
|
||
|
|
# Services Amount Split Method
|
||
|
|
# -------------------------------------------
|
||
|
|
# 1.labour 10 By Equal
|
||
|
|
# 2.brokerage 150 By Quantity
|
||
|
|
# 3.transportation 250 By Weight
|
||
|
|
# 4.packaging 20 By Volume
|
||
|
|
|
||
|
|
# (D) Decrease cost that already added on purchase
|
||
|
|
# (apply negative entry)
|
||
|
|
|
||
|
|
# Services Amount Split Method
|
||
|
|
# -------------------------------------------
|
||
|
|
# 1.labour -5 By Equal
|
||
|
|
# 2.brokerage -50 By Quantity
|
||
|
|
# 3.transportation -50 By Weight
|
||
|
|
# 4.packaging -5 By Volume
|
||
|
|
|
||
|
|
self.landed_cost.categ_id.property_valuation = 'real_time'
|
||
|
|
|
||
|
|
# Process incoming shipment
|
||
|
|
income_ship = self._process_incoming_shipment()
|
||
|
|
# Refrigerator outgoing shipment.
|
||
|
|
self._process_outgoing_shipment()
|
||
|
|
# Apply landed cost for incoming shipment.
|
||
|
|
stock_landed_cost = self._create_landed_costs({
|
||
|
|
'equal_price_unit': 10,
|
||
|
|
'quantity_price_unit': 150,
|
||
|
|
'weight_price_unit': 250,
|
||
|
|
'volume_price_unit': 20}, income_ship)
|
||
|
|
# Compute landed costs
|
||
|
|
stock_landed_cost.compute_landed_cost()
|
||
|
|
valid_vals = {
|
||
|
|
'equal': 5.0,
|
||
|
|
'by_quantity_refrigerator': 50.0,
|
||
|
|
'by_quantity_oven': 100.0,
|
||
|
|
'by_weight_refrigerator': 50.0,
|
||
|
|
'by_weight_oven': 200.0,
|
||
|
|
'by_volume_refrigerator': 5.0,
|
||
|
|
'by_volume_oven': 15.0}
|
||
|
|
# Check valuation adjustment line recognized or not
|
||
|
|
self._validate_additional_landed_cost_lines(stock_landed_cost, valid_vals)
|
||
|
|
# Validate the landed cost.
|
||
|
|
stock_landed_cost.button_validate()
|
||
|
|
self.assertTrue(stock_landed_cost.account_move_id, 'Landed costs should be available account move lines')
|
||
|
|
# Create negative landed cost for previously incoming shipment.
|
||
|
|
stock_negative_landed_cost = self._create_landed_costs({
|
||
|
|
'equal_price_unit': -5,
|
||
|
|
'quantity_price_unit': -50,
|
||
|
|
'weight_price_unit': -50,
|
||
|
|
'volume_price_unit': -5}, income_ship)
|
||
|
|
# Compute negative landed costs
|
||
|
|
stock_negative_landed_cost.compute_landed_cost()
|
||
|
|
valid_vals = {
|
||
|
|
'equal': -2.5,
|
||
|
|
'by_quantity_refrigerator': -16.67,
|
||
|
|
'by_quantity_oven': -33.33,
|
||
|
|
'by_weight_refrigerator': -10.00,
|
||
|
|
'by_weight_oven': -40.00,
|
||
|
|
'by_volume_refrigerator': -1.25,
|
||
|
|
'by_volume_oven': -3.75}
|
||
|
|
# Check valuation adjustment line recognized or not
|
||
|
|
self._validate_additional_landed_cost_lines(stock_negative_landed_cost, valid_vals)
|
||
|
|
# Validate the landed cost.
|
||
|
|
stock_negative_landed_cost.button_validate()
|
||
|
|
self.assertEqual(stock_negative_landed_cost.state, 'done', 'Negative landed costs should be in done state')
|
||
|
|
self.assertTrue(stock_negative_landed_cost.account_move_id, 'Landed costs should be available account move lines')
|
||
|
|
[balance] = self.env['account.move.line']._read_group(
|
||
|
|
[('move_id', '=', stock_negative_landed_cost.account_move_id.id)], aggregates=['balance:sum'])[0]
|
||
|
|
self.assertEqual(balance, 0, 'Move is not balanced')
|
||
|
|
move_lines = [
|
||
|
|
{'name': 'split by volume - Microwave Oven', 'debit': 3.75, 'credit': 0.0},
|
||
|
|
{'name': 'split by volume - Microwave Oven', 'debit': 0.0, 'credit': 3.75},
|
||
|
|
{'name': 'split by weight - Microwave Oven', 'debit': 40.0, 'credit': 0.0},
|
||
|
|
{'name': 'split by weight - Microwave Oven', 'debit': 0.0, 'credit': 40.0},
|
||
|
|
{'name': 'split by quantity - Microwave Oven', 'debit': 33.33, 'credit': 0.0},
|
||
|
|
{'name': 'split by quantity - Microwave Oven', 'debit': 0.0, 'credit': 33.33},
|
||
|
|
{'name': 'equal split - Microwave Oven', 'debit': 2.5, 'credit': 0.0},
|
||
|
|
{'name': 'equal split - Microwave Oven', 'debit': 0.0, 'credit': 2.5},
|
||
|
|
{'name': 'split by volume - Refrigerator: 2.0 already out', 'debit': 0.5, 'credit': 0.0},
|
||
|
|
{'name': 'split by volume - Refrigerator: 2.0 already out', 'debit': 0.0, 'credit': 0.5},
|
||
|
|
{'name': 'split by weight - Refrigerator: 2.0 already out', 'debit': 4.0, 'credit': 0.0},
|
||
|
|
{'name': 'split by weight - Refrigerator: 2.0 already out', 'debit': 0.0, 'credit': 4.0},
|
||
|
|
{'name': 'split by weight - Refrigerator', 'debit': 0.0, 'credit': 10.0},
|
||
|
|
{'name': 'split by weight - Refrigerator', 'debit': 10.0, 'credit': 0.0},
|
||
|
|
{'name': 'split by volume - Refrigerator', 'debit': 0.0, 'credit': 1.25},
|
||
|
|
{'name': 'split by volume - Refrigerator', 'debit': 1.25, 'credit': 0.0},
|
||
|
|
{'name': 'split by quantity - Refrigerator: 2.0 already out', 'debit': 6.67, 'credit': 0.0},
|
||
|
|
{'name': 'split by quantity - Refrigerator: 2.0 already out', 'debit': 0.0, 'credit': 6.67},
|
||
|
|
{'name': 'split by quantity - Refrigerator', 'debit': 16.67, 'credit': 0.0},
|
||
|
|
{'name': 'split by quantity - Refrigerator', 'debit': 0.0, 'credit': 16.67},
|
||
|
|
{'name': 'equal split - Refrigerator: 2.0 already out', 'debit': 1.0, 'credit': 0.0},
|
||
|
|
{'name': 'equal split - Refrigerator: 2.0 already out', 'debit': 0.0, 'credit': 1.0},
|
||
|
|
{'name': 'equal split - Refrigerator', 'debit': 2.5, 'credit': 0.0},
|
||
|
|
{'name': 'equal split - Refrigerator', 'debit': 0.0, 'credit': 2.5}
|
||
|
|
]
|
||
|
|
if stock_negative_landed_cost.account_move_id.company_id.anglo_saxon_accounting:
|
||
|
|
move_lines += [
|
||
|
|
{'name': 'split by volume - Refrigerator: 2.0 already out', 'debit': 0.5, 'credit': 0.0},
|
||
|
|
{'name': 'split by volume - Refrigerator: 2.0 already out', 'debit': 0.0, 'credit': 0.5},
|
||
|
|
{'name': 'split by weight - Refrigerator: 2.0 already out', 'debit': 4.0, 'credit': 0.0},
|
||
|
|
{'name': 'split by weight - Refrigerator: 2.0 already out', 'debit': 0.0, 'credit': 4.0},
|
||
|
|
{'name': 'split by quantity - Refrigerator: 2.0 already out', 'debit': 6.67, 'credit': 0.0},
|
||
|
|
{'name': 'split by quantity - Refrigerator: 2.0 already out', 'debit': 0.0, 'credit': 6.67},
|
||
|
|
{'name': 'equal split - Refrigerator: 2.0 already out', 'debit': 1.0, 'credit': 0.0},
|
||
|
|
{'name': 'equal split - Refrigerator: 2.0 already out', 'debit': 0.0, 'credit': 1.0},
|
||
|
|
]
|
||
|
|
self.assertRecordValues(
|
||
|
|
sorted(stock_negative_landed_cost.account_move_id.line_ids, key=lambda d: (d['name'], d['debit'])),
|
||
|
|
sorted(move_lines, key=lambda d: (d['name'], d['debit'])),
|
||
|
|
)
|
||
|
|
|
||
|
|
def _process_incoming_shipment(self):
|
||
|
|
""" Two product incoming shipment. """
|
||
|
|
# Confirm incoming shipment.
|
||
|
|
self.picking_in.action_confirm()
|
||
|
|
# Transfer incoming shipment
|
||
|
|
self.picking_in.button_validate()
|
||
|
|
return self.picking_in
|
||
|
|
|
||
|
|
def _process_outgoing_shipment(self):
|
||
|
|
""" One product Outgoing shipment. """
|
||
|
|
# Confirm outgoing shipment.
|
||
|
|
self.picking_out.action_confirm()
|
||
|
|
# Product assign to outgoing shipments
|
||
|
|
self.picking_out.action_assign()
|
||
|
|
# Transfer picking.
|
||
|
|
|
||
|
|
self.picking_out.button_validate()
|
||
|
|
|
||
|
|
def _create_landed_costs(self, value, picking_in):
|
||
|
|
return self.LandedCost.create(dict(
|
||
|
|
picking_ids=[(6, 0, [picking_in.id])],
|
||
|
|
account_journal_id=self.expenses_journal.id,
|
||
|
|
cost_lines=[
|
||
|
|
(0, 0, {
|
||
|
|
'name': 'equal split',
|
||
|
|
'split_method': 'equal',
|
||
|
|
'price_unit': value['equal_price_unit'],
|
||
|
|
'product_id': self.landed_cost.id}),
|
||
|
|
(0, 0, {
|
||
|
|
'name': 'split by quantity',
|
||
|
|
'split_method': 'by_quantity',
|
||
|
|
'price_unit': value['quantity_price_unit'],
|
||
|
|
'product_id': self.brokerage_quantity.id}),
|
||
|
|
(0, 0, {
|
||
|
|
'name': 'split by weight',
|
||
|
|
'split_method': 'by_weight',
|
||
|
|
'price_unit': value['weight_price_unit'],
|
||
|
|
'product_id': self.transportation_weight.id}),
|
||
|
|
(0, 0, {
|
||
|
|
'name': 'split by volume',
|
||
|
|
'split_method': 'by_volume',
|
||
|
|
'price_unit': value['volume_price_unit'],
|
||
|
|
'product_id': self.packaging_volume.id})
|
||
|
|
],
|
||
|
|
))
|
||
|
|
|
||
|
|
def _validate_additional_landed_cost_lines(self, stock_landed_cost, valid_vals):
|
||
|
|
for valuation in stock_landed_cost.valuation_adjustment_lines:
|
||
|
|
add_cost = valuation.additional_landed_cost
|
||
|
|
split_method = valuation.cost_line_id.split_method
|
||
|
|
product = valuation.move_id.product_id
|
||
|
|
if split_method == 'equal':
|
||
|
|
self.assertEqual(add_cost, valid_vals['equal'], self._error_message(valid_vals['equal'], add_cost))
|
||
|
|
elif split_method == 'by_quantity' and product == self.product_refrigerator:
|
||
|
|
self.assertEqual(add_cost, valid_vals['by_quantity_refrigerator'], self._error_message(valid_vals['by_quantity_refrigerator'], add_cost))
|
||
|
|
elif split_method == 'by_quantity' and product == self.product_oven:
|
||
|
|
self.assertEqual(add_cost, valid_vals['by_quantity_oven'], self._error_message(valid_vals['by_quantity_oven'], add_cost))
|
||
|
|
elif split_method == 'by_weight' and product == self.product_refrigerator:
|
||
|
|
self.assertEqual(add_cost, valid_vals['by_weight_refrigerator'], self._error_message(valid_vals['by_weight_refrigerator'], add_cost))
|
||
|
|
elif split_method == 'by_weight' and product == self.product_oven:
|
||
|
|
self.assertEqual(add_cost, valid_vals['by_weight_oven'], self._error_message(valid_vals['by_weight_oven'], add_cost))
|
||
|
|
elif split_method == 'by_volume' and product == self.product_refrigerator:
|
||
|
|
self.assertEqual(add_cost, valid_vals['by_volume_refrigerator'], self._error_message(valid_vals['by_volume_refrigerator'], add_cost))
|
||
|
|
elif split_method == 'by_volume' and product == self.product_oven:
|
||
|
|
self.assertEqual(add_cost, valid_vals['by_volume_oven'], self._error_message(valid_vals['by_volume_oven'], add_cost))
|
||
|
|
|
||
|
|
def _error_message(self, actucal_cost, computed_cost):
|
||
|
|
return 'Additional Landed Cost should be %s instead of %s' % (actucal_cost, computed_cost)
|
||
|
|
|
||
|
|
|
||
|
|
@tagged('post_install', '-at_install')
|
||
|
|
class TestLandedCostsWithPurchaseAndInv(TestStockValuationLCCommon):
|
||
|
|
def test_invoice_after_lc(self):
|
||
|
|
self.env.company.anglo_saxon_accounting = True
|
||
|
|
self.product1.product_tmpl_id.categ_id.property_cost_method = 'fifo'
|
||
|
|
self.product1.product_tmpl_id.categ_id.property_valuation = 'real_time'
|
||
|
|
stock_valuation_account = self.company_data['default_account_stock_valuation']
|
||
|
|
|
||
|
|
# Create PO
|
||
|
|
po_form = Form(self.env['purchase.order'])
|
||
|
|
po_form.partner_id = self.env['res.partner'].create({'name': 'vendor'})
|
||
|
|
with po_form.order_line.new() as po_line:
|
||
|
|
po_line.product_id = self.product1
|
||
|
|
po_line.product_qty = 1
|
||
|
|
po_line.price_unit = 455.0
|
||
|
|
order = po_form.save()
|
||
|
|
order.button_confirm()
|
||
|
|
|
||
|
|
# Receive the goods
|
||
|
|
receipt = order.picking_ids[0]
|
||
|
|
receipt.move_ids.quantity = 1
|
||
|
|
receipt.button_validate()
|
||
|
|
|
||
|
|
# Check SVL and AML
|
||
|
|
svl = self.env['stock.valuation.layer'].search([('stock_move_id', '=', receipt.move_ids.id)])
|
||
|
|
self.assertAlmostEqual(svl.value, 455)
|
||
|
|
aml = self.env['account.move.line'].search([('account_id', '=', stock_valuation_account.id)])
|
||
|
|
self.assertAlmostEqual(aml.debit, 455)
|
||
|
|
|
||
|
|
# Create and validate LC
|
||
|
|
lc = self.env['stock.landed.cost'].create(dict(
|
||
|
|
picking_ids=[(6, 0, [receipt.id])],
|
||
|
|
account_journal_id=self.stock_journal.id,
|
||
|
|
cost_lines=[
|
||
|
|
(0, 0, {
|
||
|
|
'name': 'equal split',
|
||
|
|
'split_method': 'equal',
|
||
|
|
'price_unit': 99,
|
||
|
|
'product_id': self.productlc1.id,
|
||
|
|
}),
|
||
|
|
],
|
||
|
|
))
|
||
|
|
lc.compute_landed_cost()
|
||
|
|
lc.button_validate()
|
||
|
|
|
||
|
|
# Check LC, SVL and AML
|
||
|
|
self.assertAlmostEqual(lc.valuation_adjustment_lines.final_cost, 554)
|
||
|
|
svl = self.env['stock.valuation.layer'].search([('stock_move_id', '=', receipt.move_ids.id)], order='id desc', limit=1)
|
||
|
|
self.assertAlmostEqual(svl.value, 99)
|
||
|
|
aml = self.env['account.move.line'].search([('account_id', '=', stock_valuation_account.id)], order='id desc', limit=1)
|
||
|
|
self.assertAlmostEqual(aml.debit, 99)
|
||
|
|
|
||
|
|
# Create an invoice with the same price
|
||
|
|
move_form = Form(self.env['account.move'].with_context(default_move_type='in_invoice'))
|
||
|
|
move_form.invoice_date = move_form.date
|
||
|
|
move_form.partner_id = order.partner_id
|
||
|
|
move_form.purchase_vendor_bill_id = self.env['purchase.bill.union'].browse(-order.id)
|
||
|
|
move = move_form.save()
|
||
|
|
move.action_post()
|
||
|
|
|
||
|
|
# Check nothing was posted in the stock valuation account.
|
||
|
|
price_diff_aml = self.env['account.move.line'].search([('account_id', '=', stock_valuation_account.id), ('move_id', '=', move.id)])
|
||
|
|
self.assertEqual(len(price_diff_aml), 0, "No line should have been generated in the stock valuation account about the price difference.")
|
||
|
|
|
||
|
|
def test_invoice_after_lc_amls(self):
|
||
|
|
self.env.company.anglo_saxon_accounting = True
|
||
|
|
self.landed_cost.landed_cost_ok = True
|
||
|
|
self.landed_cost.categ_id.property_cost_method = 'fifo'
|
||
|
|
self.landed_cost.categ_id.property_valuation = 'real_time'
|
||
|
|
|
||
|
|
# Create PO
|
||
|
|
po = self.env['purchase.order'].create({
|
||
|
|
'partner_id': self.partner_a.id,
|
||
|
|
'currency_id': self.company_data['currency'].id,
|
||
|
|
'order_line': [
|
||
|
|
(0, 0, {
|
||
|
|
'name': self.product_a.name,
|
||
|
|
'product_id': self.product_a.id,
|
||
|
|
'product_qty': 1.0,
|
||
|
|
'product_uom': self.product_a.uom_po_id.id,
|
||
|
|
'price_unit': 100.0,
|
||
|
|
'taxes_id': False,
|
||
|
|
}),
|
||
|
|
(0, 0, {
|
||
|
|
'name': self.landed_cost.name,
|
||
|
|
'product_id': self.landed_cost.id,
|
||
|
|
'product_qty': 1.0,
|
||
|
|
'price_unit': 100.0,
|
||
|
|
}),
|
||
|
|
],
|
||
|
|
})
|
||
|
|
po.button_confirm()
|
||
|
|
|
||
|
|
receipt = po.picking_ids
|
||
|
|
receipt.move_ids.quantity = 1
|
||
|
|
receipt.button_validate()
|
||
|
|
po.order_line[1].qty_received = 1
|
||
|
|
|
||
|
|
po.action_create_invoice()
|
||
|
|
bill = po.invoice_ids
|
||
|
|
|
||
|
|
# Create and validate LC
|
||
|
|
lc = self.env['stock.landed.cost'].create(dict(
|
||
|
|
picking_ids=[(6, 0, [receipt.id])],
|
||
|
|
account_journal_id=self.stock_journal.id,
|
||
|
|
cost_lines=[
|
||
|
|
(0, 0, {
|
||
|
|
'name': 'equal split',
|
||
|
|
'split_method': 'equal',
|
||
|
|
'price_unit': 100,
|
||
|
|
'product_id': self.landed_cost.id,
|
||
|
|
}),
|
||
|
|
],
|
||
|
|
))
|
||
|
|
lc.compute_landed_cost()
|
||
|
|
lc.button_validate()
|
||
|
|
|
||
|
|
user = self.env['res.users'].create({
|
||
|
|
'name': 'User h',
|
||
|
|
'login': 'usher',
|
||
|
|
'email': 'usher@yourcompany.com',
|
||
|
|
'groups_id': [(6, 0, [self.env.ref('account.group_account_invoice').id])]
|
||
|
|
})
|
||
|
|
# Post the bill
|
||
|
|
bill.landed_costs_ids = [(6, 0, lc.id)]
|
||
|
|
bill.invoice_date = Date.today()
|
||
|
|
bill.with_user(user)._post()
|
||
|
|
|
||
|
|
landed_cost_aml = bill.invoice_line_ids.filtered(lambda l: l.product_id == self.landed_cost)
|
||
|
|
self.assertTrue(landed_cost_aml.reconciled)
|