initial commit 2

1 files changed, 132 insertions, 0 deletions

diff --git a/addons/purchase_stock/tests/test_average_price.py b/addons/purchase_stock/tests/test_average_price.py
new file mode 100644
index 00000000..031fe0d2
--- /dev/null
+++ b/addons/purchase_stock/tests/test_average_price.py
@@ -0,0 +1,132 @@
+# -*- coding: utf-8 -*-
+# Part of Odoo. See LICENSE file for full copyright and licensing details.
+from odoo.addons.stock_account.tests.test_anglo_saxon_valuation_reconciliation_common import ValuationReconciliationTestCommon
+from odoo.tests import tagged, Form
+
+import time
+
+
+@tagged('-at_install', 'post_install')
+class TestAveragePrice(ValuationReconciliationTestCommon):
+
+    def test_00_average_price(self):
+        """ Testcase for average price computation"""
+
+        res_partner_3 = self.env['res.partner'].create({
+            'name': 'Gemini Partner',
+        })
+
+        # Set a product as using average price.
+        product_cable_management_box = self.env['product.product'].create({
+            'default_code': 'AVG',
+            'name': 'Average Ice Cream',
+            'type': 'product',
+            'categ_id': self.stock_account_product_categ.id,
+            'list_price': 100.0,
+            'standard_price': 60.0,
+            'uom_id': self.env.ref('uom.product_uom_kgm').id,
+            'uom_po_id': self.env.ref('uom.product_uom_kgm').id,
+            'supplier_taxes_id': [],
+            'description': 'FIFO Ice Cream',
+        })
+        product_cable_management_box.categ_id.property_cost_method = 'average'
+
+        # I create a draft Purchase Order for first incoming shipment for 10 pieces at 60€
+        purchase_order_1 = self.env['purchase.order'].create({
+            'partner_id': res_partner_3.id,
+            'order_line': [(0, 0, {
+                'name': 'Average Ice Cream',
+                'product_id': product_cable_management_box.id,
+                'product_qty': 10.0,
+                'product_uom': self.env.ref('uom.product_uom_kgm').id,
+                'price_unit': 60.0,
+                'date_planned': time.strftime('%Y-%m-%d'),
+            })]
+        })
+
+        # Confirm the first purchase order
+        purchase_order_1.button_confirm()
+
+        # Check the "Approved" status of purchase order 1
+        self.assertEqual(purchase_order_1.state, 'purchase', "Wrong state of purchase order!")
+
+        # Process the reception of purchase order 1
+        picking = purchase_order_1.picking_ids[0]
+        res = picking.button_validate()
+        Form(self.env[res['res_model']].with_context(res['context'])).save().process()
+
+        # Check the average_price of the product (average icecream).
+        self.assertEqual(product_cable_management_box.qty_available, 10.0, 'Wrong quantity in stock after first reception')
+        self.assertEqual(product_cable_management_box.standard_price, 60.0, 'Standard price should be the price of the first reception!')
+
+        # I create a draft Purchase Order for second incoming shipment for 30 pieces at 80€
+        purchase_order_2 = self.env['purchase.order'].create({
+            'partner_id': res_partner_3.id,
+            'order_line': [(0, 0, {
+                'name': product_cable_management_box.name,
+                'product_id': product_cable_management_box.id,
+                'product_qty': 30.0,
+                'product_uom': self.env.ref('uom.product_uom_kgm').id,
+                'price_unit': 80.0,
+                'date_planned': time.strftime('%Y-%m-%d'),
+            })]
+        })
+
+        # Confirm the second purchase order
+        purchase_order_2.button_confirm()
+        # Process the reception of purchase order 2
+        picking = purchase_order_2.picking_ids[0]
+        res = picking.button_validate()
+        Form(self.env['stock.immediate.transfer'].with_context(res['context'])).save().process()
+
+        # Check the standard price
+        self.assertEqual(product_cable_management_box.standard_price, 75.0, 'After second reception, we should have an average price of 75.0 on the product')
+
+        # Create picking to send some goods
+        outgoing_shipment = self.env['stock.picking'].create({
+            'picking_type_id': self.company_data['default_warehouse'].out_type_id.id,
+            'location_id': self.company_data['default_warehouse'].lot_stock_id.id,
+            'location_dest_id': self.env.ref('stock.stock_location_customers').id,
+            'move_lines': [(0, 0, {
+                'name': 'outgoing_shipment_avg_move',
+                'product_id': product_cable_management_box.id,
+                'product_uom_qty': 20.0,
+                'product_uom': self.env.ref('uom.product_uom_kgm').id,
+                'location_id':  self.company_data['default_warehouse'].lot_stock_id.id,
+                'location_dest_id': self.env.ref('stock.stock_location_customers').id})]
+            })
+
+        # Assign this outgoing shipment and process the delivery
+        outgoing_shipment.action_assign()
+        res = outgoing_shipment.button_validate()
+        Form(self.env['stock.immediate.transfer'].with_context(res['context'])).save().process()
+
+        # Check the average price (60 * 10 + 30 * 80) / 40 = 75.0€ did not change
+        self.assertEqual(product_cable_management_box.standard_price, 75.0, 'Average price should not have changed with outgoing picking!')
+        self.assertEqual(product_cable_management_box.qty_available, 20.0, 'Pieces were not picked correctly as the quantity on hand is wrong')
+
+        # Make a new purchase order with 500 g Average Ice Cream at a price of 0.2€/g
+        purchase_order_3 = self.env['purchase.order'].create({
+            'partner_id': res_partner_3.id,
+            'order_line': [(0, 0, {
+                'name': product_cable_management_box.name,
+                'product_id': product_cable_management_box.id,
+                'product_qty': 500.0,
+                'product_uom': self.ref('uom.product_uom_gram'),
+                'price_unit': 0.2,
+                'date_planned': time.strftime('%Y-%m-%d'),
+            })]
+        })
+
+        # Confirm the first purchase order
+        purchase_order_3.button_confirm()
+        # Process the reception of purchase order 3 in grams
+
+        picking = purchase_order_3.picking_ids[0]
+        res = picking.button_validate()
+        Form(self.env[res['res_model']].with_context(res['context'])).save().process()
+
+        # Check price is (75.0 * 20 + 200*0.5) / 20.5 = 78.04878€
+        self.assertEqual(product_cable_management_box.qty_available, 20.5, 'Reception of purchase order in grams leads to wrong quantity in stock')
+        self.assertEqual(round(product_cable_management_box.standard_price, 2), 78.05,
+            'Standard price as average price of third reception with other UoM incorrect! Got %s instead of 78.05' % (round(product_cable_management_box.standard_price, 2)))