diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2022-05-10 21:51:50 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2022-05-10 21:51:50 +0700 |
| commit | 3751379f1e9a4c215fb6eb898b4ccc67659b9ace (patch) | |
| tree | a44932296ef4a9b71d5f010906253d8c53727726 /addons/point_of_sale/tests/test_pos_stock_account.py | |
| parent | 0a15094050bfde69a06d6eff798e9a8ddf2b8c21 (diff) | |
initial commit 2
Diffstat (limited to 'addons/point_of_sale/tests/test_pos_stock_account.py')
| -rw-r--r-- | addons/point_of_sale/tests/test_pos_stock_account.py | 249 |
1 files changed, 249 insertions, 0 deletions
diff --git a/addons/point_of_sale/tests/test_pos_stock_account.py b/addons/point_of_sale/tests/test_pos_stock_account.py new file mode 100644 index 00000000..287b4430 --- /dev/null +++ b/addons/point_of_sale/tests/test_pos_stock_account.py @@ -0,0 +1,249 @@ +# -*- coding: utf-8 -*- +# Part of Odoo. See LICENSE file for full copyright and licensing details. + +from odoo import tools +import odoo +from odoo.addons.point_of_sale.tests.common import TestPoSCommon + +@odoo.tests.tagged('post_install', '-at_install') +class TestPoSStock(TestPoSCommon): + """ Tests for anglo saxon accounting scenario. + """ + def setUp(self): + super(TestPoSStock, self).setUp() + + self.config = self.basic_config + self.product1 = self.create_product('Product 1', self.categ_anglo, 10.0, 5.0) + self.product2 = self.create_product('Product 2', self.categ_anglo, 20.0, 10.0) + self.product3 = self.create_product('Product 3', self.categ_basic, 30.0, 15.0) + # start inventory with 10 items for each product + self.adjust_inventory([self.product1, self.product2, self.product3], [10, 10, 10]) + + # change cost(standard_price) of anglo products + # then set inventory from 10 -> 15 + self.product1.write({'standard_price': 6.0}) + self.product2.write({'standard_price': 6.0}) + self.adjust_inventory([self.product1, self.product2, self.product3], [15, 15, 15]) + + # change cost(standard_price) of anglo products + # then set inventory from 15 -> 25 + self.product1.write({'standard_price': 13.0}) + self.product2.write({'standard_price': 13.0}) + self.adjust_inventory([self.product1, self.product2, self.product3], [25, 25, 25]) + + self.output_account = self.categ_anglo.property_stock_account_output_categ_id + self.expense_account = self.categ_anglo.property_account_expense_categ_id + self.valuation_account = self.categ_anglo.property_stock_valuation_account_id + + def test_01_orders_no_invoiced(self): + """ + + Orders + ====== + +---------+----------+-----+-------------+------------+ + | order | product | qty | total price | total cost | + +---------+----------+-----+-------------+------------+ + | order 1 | product1 | 10 | 100.0 | 50.0 | -> 10 items at cost of 5.0 is consumed, remains 5 items at 6.0 and 10 items at 13.0 + | | product2 | 10 | 200.0 | 100.0 | -> 10 items at cost of 10.0 is consumed, remains 5 items at 6.0 and 10 items at 13.0 + +---------+----------+-----+-------------+------------+ + | order 2 | product2 | 7 | 140.0 | 56.0 | -> 5 items at cost of 6.0 and 2 items at cost of 13.0, remains 8 items at cost of 13.0 + | | product3 | 7 | 210.0 | 0.0 | + +---------+----------+-----+-------------+------------+ + | order 3 | product1 | 6 | 60.0 | 43.0 | -> 5 items at cost of 6.0 and 1 item at cost of 13.0, remains 9 items at cost of 13.0 + | | product2 | 6 | 120.0 | 78.0 | -> 6 items at cost of 13.0, remains 2 items at cost of 13.0 + | | product3 | 6 | 180.0 | 0.0 | + +---------+----------+-----+-------------+------------+ + + Expected Result + =============== + +---------------------+---------+ + | account | balance | + +---------------------+---------+ + | sale_account | -1010.0 | + | pos_receivable-cash | 1010.0 | + | expense_account | 327.0 | + | output_account | -327.0 | + +---------------------+---------+ + | Total balance | 0.00 | + +---------------------+---------+ + """ + self.open_new_session() + + # create orders + orders = [] + orders.append(self.create_ui_order_data([(self.product1, 10), (self.product2, 10)])) + orders.append(self.create_ui_order_data([(self.product2, 7), (self.product3, 7)])) + orders.append(self.create_ui_order_data([(self.product1, 6), (self.product2, 6), (self.product3, 6)])) + + # sync orders + order = self.env['pos.order'].create_from_ui(orders) + + # check values before closing the session + self.assertEqual(3, self.pos_session.order_count) + orders_total = sum(order.amount_total for order in self.pos_session.order_ids) + self.assertAlmostEqual(orders_total, self.pos_session.total_payments_amount, msg='Total order amount should be equal to the total payment amount.') + self.assertAlmostEqual(orders_total, 1010.0, msg='The orders\'s total amount should equal the computed.') + + # check product qty_available after syncing the order + self.assertEqual(self.product1.qty_available, 9) + self.assertEqual(self.product2.qty_available, 2) + self.assertEqual(self.product3.qty_available, 12) + + # picking and stock moves should be in done state + for order in self.pos_session.order_ids: + self.assertEqual(order.picking_ids[0].state, 'done', 'Picking should be in done state.') + self.assertTrue(all(state == 'done' for state in order.picking_ids[0].move_lines.mapped('state')), 'Move Lines should be in done state.' ) + + # close the session + self.pos_session.action_pos_session_validate() + + # check values after the session is closed + account_move = self.pos_session.move_id + + sales_line = account_move.line_ids.filtered(lambda line: line.account_id == self.sale_account) + self.assertAlmostEqual(sales_line.balance, -orders_total, msg='Sales line balance should be equal to total orders amount.') + + receivable_line_cash = account_move.line_ids.filtered(lambda line: line.account_id in self.pos_receivable_account + self.env['account.account'].search([('name', '=', 'Account Receivable (PoS)')]) and self.cash_pm.name in line.name) + self.assertAlmostEqual(receivable_line_cash.balance, 1010.0, msg='Cash receivable should be equal to the total cash payments.') + + expense_line = account_move.line_ids.filtered(lambda line: line.account_id == self.expense_account) + self.assertAlmostEqual(expense_line.balance, 327.0) + + output_line = account_move.line_ids.filtered(lambda line: line.account_id == self.output_account) + self.assertAlmostEqual(output_line.balance, -327.0) + + self.assertTrue(receivable_line_cash.full_reconcile_id, msg='Cash receivable line should be fully-reconciled.') + self.assertTrue(output_line.full_reconcile_id, msg='The stock output account line should be fully-reconciled.') + + def test_02_orders_with_invoice(self): + """ + + Orders + ====== + Same with test_01 but order 3 is invoiced. + + Expected Result + =============== + +---------------------+---------+ + | account | balance | + +---------------------+---------+ + | sale_account | -650.0 | + | pos_receivable-cash | 1010.0 | + | receivable | -360.0 | + | expense_account | 206.0 | + | output_account | -206.0 | + +---------------------+---------+ + | Total balance | 0.00 | + +---------------------+---------+ + """ + self.open_new_session() + + # create orders + orders = [] + orders.append(self.create_ui_order_data([(self.product1, 10), (self.product2, 10)])) + orders.append(self.create_ui_order_data([(self.product2, 7), (self.product3, 7)])) + invoiced_uid = self.create_random_uid() + orders.append(self.create_ui_order_data( + [(self.product1, 6), (self.product2, 6), (self.product3, 6)], + is_invoiced=True, + customer=self.customer, + uid=invoiced_uid, + )) + + # sync orders + order = self.env['pos.order'].create_from_ui(orders) + + # check values before closing the session + self.assertEqual(3, self.pos_session.order_count) + orders_total = sum(order.amount_total for order in self.pos_session.order_ids) + self.assertAlmostEqual(orders_total, self.pos_session.total_payments_amount, msg='Total order amount should be equal to the total payment amount.') + self.assertAlmostEqual(orders_total, 1010.0, msg='The orders\'s total amount should equal the computed.') + + # check product qty_available after syncing the order + self.assertEqual(self.product1.qty_available, 9) + self.assertEqual(self.product2.qty_available, 2) + self.assertEqual(self.product3.qty_available, 12) + + # picking and stock moves should be in done state + for order in self.pos_session.order_ids: + self.assertEqual(order.picking_ids[0].state, 'done', 'Picking should be in done state.') + self.assertTrue(all(state == 'done' for state in order.picking_ids[0].move_lines.mapped('state')), 'Move Lines should be in done state.' ) + + # close the session + self.pos_session.action_pos_session_validate() + + # check values after the session is closed + account_move = self.pos_session.move_id + + sales_line = account_move.line_ids.filtered(lambda line: line.account_id == self.sale_account) + self.assertAlmostEqual(sales_line.balance, -650.0) + + receivable_line = account_move.line_ids.filtered(lambda line: line.account_id == self.receivable_account) + self.assertAlmostEqual(receivable_line.balance, -360.0, msg='Receivable line balance should equal the negative of total amount of invoiced orders.') + + receivable_line_cash = account_move.line_ids.filtered(lambda line: line.account_id in self.pos_receivable_account + self.env['account.account'].search([('name', '=', 'Account Receivable (PoS)')]) and self.cash_pm.name in line.name) + self.assertAlmostEqual(receivable_line_cash.balance, 1010.0, msg='Cash receivable should be equal to the total cash payments.') + + expense_line = account_move.line_ids.filtered(lambda line: line.account_id == self.expense_account) + self.assertAlmostEqual(expense_line.balance, 206.0) + + output_line = account_move.line_ids.filtered(lambda line: line.account_id == self.output_account) + self.assertAlmostEqual(output_line.balance, -206.0) + + # check order journal entry + invoiced_order = self.pos_session.order_ids.filtered(lambda order: invoiced_uid in order.pos_reference) + invoiced_output_account_lines = invoiced_order.account_move.line_ids.filtered(lambda line: line.account_id == self.output_account) + self.assertAlmostEqual(sum(invoiced_output_account_lines.mapped('balance')), -121.0) + + # The stock output account move lines of the invoiced order should be properly reconciled + for move_line in invoiced_order.account_move.line_ids.filtered(lambda line: line.account_id == self.output_account): + self.assertTrue(move_line.full_reconcile_id) + + self.assertTrue(receivable_line_cash.full_reconcile_id, msg='Cash receivable line should be fully-reconciled.') + self.assertTrue(output_line.full_reconcile_id, msg='The stock output account line should be fully-reconciled.') + + def test_03_order_product_w_owner(self): + """ + Test order via POS a product having stock owner. + """ + + group_owner = self.env.ref('stock.group_tracking_owner') + self.env.user.write({'groups_id': [(4, group_owner.id)]}) + self.product4 = self.create_product('Product 3', self.categ_basic, 30.0, 15.0) + inventory = self.env['stock.inventory'].create({ + 'name': 'Inventory adjustment' + }) + self.env['stock.inventory.line'].create({ + 'product_id': self.product4.id, + 'product_uom_id': self.env.ref('uom.product_uom_unit').id, + 'inventory_id': inventory.id, + 'product_qty': 10, + 'partner_id': self.partner_a.id, + 'location_id': self.stock_location_components.id, + }) + inventory._action_start() + inventory.action_validate() + + self.open_new_session() + + # create orders + orders = [] + orders.append(self.create_ui_order_data([(self.product4, 1)])) + + # sync orders + order = self.env['pos.order'].create_from_ui(orders) + + # check values before closing the session + self.assertEqual(1, self.pos_session.order_count) + + # check product qty_available after syncing the order + self.assertEqual(self.product4.qty_available, 9) + + # picking and stock moves should be in done state + for order in self.pos_session.order_ids: + self.assertEqual(order.picking_ids[0].state, 'done', 'Picking should be in done state.') + self.assertTrue(all(state == 'done' for state in order.picking_ids[0].move_lines.mapped('state')), 'Move Lines should be in done state.' ) + self.assertTrue(self.partner_a == order.picking_ids[0].move_lines[0].move_line_ids[0].owner_id, 'Move Lines Owner should be taken into account.' ) + + # close the session + self.pos_session.action_pos_session_validate() |
