- Large Desk from %s to %s
\n' 'Those dates have been updated accordingly on the receipt %s.
' % (today.date(), tomorrow.date(), po.picking_ids.name), activity.note, ) # receive products po.picking_ids.button_validate() # update second line old_date = po.order_line[1].date_planned po._update_date_planned_for_lines([(po.order_line[1], tomorrow)]) self.assertEqual(po.order_line[1].date_planned, old_date) self.assertEqual( 'partner_a modified receipt dates for the following products:
\n' '- Large Desk from %s to %s
\n' '- Conference Chair from %s to %s
\n' 'Those dates couldn’t be modified accordingly on the receipt %s which had already been validated.
' % ( today.date(), tomorrow.date(), today.date(), tomorrow.date(), po.picking_ids.name), activity.note, ) def test_05_multi_company(self): company_a = self.env.user.company_id company_b = self.env['res.company'].create({ "name": "Test Company", "currency_id": self.env['res.currency'].with_context(active_test=False).search([ ('id', '!=', company_a.currency_id.id), ], limit=1).id }) self.env.user.write({ 'company_id': company_b.id, 'company_ids': [(4, company_b.id), (4, company_a.id)], }) po = self.env['purchase.order'].create(dict(company_id=company_a.id, partner_id=self.partner_a.id)) self.assertEqual(po.company_id, company_a) self.assertEqual(po.picking_type_id.warehouse_id.company_id, company_a) self.assertEqual(po.currency_id, po.company_id.currency_id) def test_06_on_time_rate(self): company_a = self.env.user.company_id company_b = self.env['res.company'].create({ "name": "Test Company", "currency_id": self.env['res.currency'].with_context(active_test=False).search([ ('id', '!=', company_a.currency_id.id), ], limit=1).id }) # Create a purchase order with 90% qty received for company A self.env.user.write({ 'company_id': company_a.id, 'company_ids': [(6, 0, [company_a.id])], }) po = self.env['purchase.order'].create(self.po_vals) po.order_line.write({'product_qty': 10}) po.button_confirm() picking = po.picking_ids[0] # Process 9.0 out of the 10.0 ordered qty picking.move_line_ids.write({'quantity': 9.0}) picking.move_ids.picked = True res_dict = picking.button_validate() # No backorder self.env['stock.backorder.confirmation'].with_context(res_dict['context']).process_cancel_backorder() # `on_time_rate` should be equals to the ratio of quantity received against quantity ordered expected_rate = sum(picking.move_line_ids.mapped("quantity")) / sum(po.order_line.mapped("product_qty")) * 100 self.assertEqual(expected_rate, po.on_time_rate) # Create a purchase order with 80% qty received for company B # The On-Time Delivery Rate shouldn't be shared across multiple companies self.env.user.write({ 'company_id': company_b.id, 'company_ids': [(6, 0, [company_b.id])], }) po = self.env['purchase.order'].create(self.po_vals) po.order_line.write({'product_qty': 10}) po.button_confirm() picking = po.picking_ids[0] # Process 8.0 out of the 10.0 ordered qty picking.move_line_ids.write({'quantity': 8.0}) picking.move_ids.picked = True res_dict = picking.button_validate() # No backorder self.env['stock.backorder.confirmation'].with_context(res_dict['context']).process_cancel_backorder() # `on_time_rate` should be equal to the ratio of quantity received against quantity ordered expected_rate = sum(picking.move_line_ids.mapped("quantity")) / sum(po.order_line.mapped("product_qty")) * 100 self.assertEqual(expected_rate, po.on_time_rate) # Tricky corner case # As `purchase.order.on_time_rate` is a related to `partner_id.on_time_rate` # `on_time_rate` on the PO should equals `on_time_rate` on the partner. # Related fields are by default computed as sudo # while non-stored computed fields are not computed as sudo by default # If the computation of the related field (`purchase.order.on_time_rate`) was asked # and `res.partner.on_time_rate` was not yet in the cache # the `sudo` requested for the computation of the related `purchase.order.on_time_rate` # was propagated to the computation of `res.partner.on_time_rate` # and therefore the multi-company record rules were ignored. # 1. Compute `res.partner.on_time_rate` regular non-stored comptued field partner_on_time_rate = po.partner_id.on_time_rate # 2. Invalidate the cache for that record and field, so it's not reused in the next step. po.partner_id.invalidate_recordset(["on_time_rate"]) # 3. Compute the related field `purchase.order.on_time_rate` po_on_time_rate = po.on_time_rate # 4. Check both are equals. self.assertEqual(partner_on_time_rate, po_on_time_rate) def test_04_multi_uom(self): yards_uom = self.env['uom.uom'].create({ 'name': 'Yards', 'relative_factor': 0.91, 'relative_uom_id': self.env.ref('uom.product_uom_meter').id, }) self.product_id_2.write({ 'uom_id': self.env.ref('uom.product_uom_meter').id, 'seller_ids': [Command.create({ 'partner_id': self.partner_a.id, 'min_qty': 1, 'uom_id': yards_uom.id, })] }) po = self.env['purchase.order'].create({ 'partner_id': self.partner_a.id, 'order_line': [ (0, 0, { 'name': self.product_id_2.name, 'product_id': self.product_id_2.id, 'product_qty': 4.0, 'price_unit': 1.0, 'date_planned': datetime.today().strftime(DEFAULT_SERVER_DATETIME_FORMAT), }) ], }) po.button_confirm() picking = po.picking_ids[0] picking.move_line_ids.write({'quantity': 3.64}) picking.move_ids.picked = True picking.button_validate() self.assertEqual(po.order_line.mapped('qty_received'), [4.0], 'Purchase: no conversion error on receipt in different uom"') def test_05_po_update_qty_stock_move_merge(self): """ This test ensures that changing product quantity when unit price has high decimal precision merged with the original instead of creating a new return """ unit_price_precision = self.env['decimal.precision'].search([('name', '=', 'Product Price')]) unit_price_precision.digits = 6 tax = self.env["account.tax"].create({ "name": "Dummy Tax", "amount": "5.00", "type_tax_use": "purchase", }) super_product = self.env['product.product'].create({ 'name': 'Super Product', 'is_storable': True, 'categ_id': self.stock_account_product_categ.id, 'standard_price': 9.876543, }) purchase_order = self.env['purchase.order'].create({ 'partner_id': self.env['res.partner'].create({'name': 'Test Partner'}).id, 'order_line': [(0, 0, { 'name': super_product.name, 'product_id': super_product.id, 'product_qty': 7, 'uom_id': super_product.uom_id.id, 'price_unit': super_product.standard_price, 'tax_ids': [(4, tax.id)], })], }) purchase_order.button_confirm() self.assertEqual(purchase_order.state, 'purchase') self.assertEqual(len(purchase_order.picking_ids), 1) self.assertEqual(len(purchase_order.picking_ids.move_line_ids), 1) self.assertEqual(purchase_order.picking_ids.move_line_ids.quantity_product_uom, 7) # -- Decrease the quantity -- # purchase_order.order_line.product_qty = 4 # updating quantity shouldn't create a separate stock move # the new stock move (-3) should be merged with the previous self.assertEqual(len(purchase_order.picking_ids), 1) self.assertEqual(len(purchase_order.picking_ids.move_line_ids), 1) self.assertEqual(purchase_order.picking_ids.move_line_ids.quantity_product_uom, 4) # -- Increase the quantity -- # purchase_order.order_line.product_qty = 14 self.assertEqual(len(purchase_order.picking_ids), 1) self.assertEqual(len(purchase_order.picking_ids.move_line_ids), 1) self.assertEqual(purchase_order.picking_ids.move_line_ids.quantity_product_uom, 14) def test_message_qty_already_received(self): self.env.user.write({'company_id': self.company_data['company'].id}) _purchase_order = self.env['purchase.order'].create({ 'partner_id': self.partner_a.id, 'order_line': [ (0, 0, { 'name': self.product_id_2.name, 'product_id': self.product_id_2.id, 'product_qty': 25.0, 'price_unit': 250.0, })], }) _purchase_order.button_confirm() first_picking = _purchase_order.picking_ids[0] first_picking.move_ids.quantity = 5 Form.from_action(self.env, first_picking.button_validate()).save().process() second_picking = _purchase_order.picking_ids[1] second_picking.move_ids.quantity = 5 Form.from_action(self.env, second_picking.button_validate()).save().process() third_picking = _purchase_order.picking_ids[2] third_picking.move_ids.quantity = 5 Form.from_action(self.env, third_picking.button_validate()).save().process() _message_content = _purchase_order.message_ids.mapped("body")[0] self.assertIsNotNone(re.search(r"Received Quantity: 5.0 -> 10.0", _message_content), "Already received quantity isn't correctly taken into consideration") def test_pol_description(self): """ Suppose a product with several sellers, all with the same partner. On the purchase order, the product description should be based on the correct seller """ self.env.user.write({'company_id': self.company_data['company'].id}) self.env['stock.route'].search([('name', '=', 'Buy')]).warehouse_ids = self.env['stock.warehouse'].search([]) product = self.env['product.product'].create({ 'name': 'Super Product', 'seller_ids': [(0, 0, { 'partner_id': self.partner_a.id, 'min_qty': 1, 'price': 10, 'product_code': 'C01', 'product_name': 'Name01', 'sequence': 1, }), (0, 0, { 'partner_id': self.partner_a.id, 'min_qty': 20, 'price': 2, 'product_code': 'C02', 'product_name': 'Name02', 'sequence': 2, })] }) orderpoint_form = Form(self.env['stock.warehouse.orderpoint']) orderpoint_form.product_id = product orderpoint_form.product_min_qty = 1 orderpoint_form.product_max_qty = 1.000 orderpoint_form.save() self.env['stock.rule'].run_scheduler() pol = self.env['purchase.order.line'].search([('product_id', '=', product.id)]) self.assertEqual(pol.name, "[C01] Name01") with Form(pol.order_id) as po_form: with po_form.order_line.edit(0) as pol_form: pol_form.product_qty = 25 self.assertEqual(pol.name, "[C02] Name02") def test_duplicated_and_modified_picking(self): """ Test that the purchase order's received quantity is not modified by a duplicated picking whose picking type has been changed. """ po = self.env['purchase.order'].create({ 'partner_id': self.partner_a.id, 'order_line': [ Command.create({ 'name': self.product_a.name, 'product_id': self.product_a.id, 'product_qty': 10.0, })], }) po.button_confirm() po.picking_ids.button_validate() self.assertEqual(po.order_line.qty_received, 10.0) outgoing_picking_type = self.env['stock.picking.type'].search([('code', '=', 'outgoing')]) duplicated_picking = po.picking_ids.copy() duplicated_picking.picking_type_id = outgoing_picking_type[0] duplicated_picking.button_validate() self.assertEqual(po.order_line.qty_received, 10.0) def test_putaway_strategy_in_backorder(self): stock_location = self.company_data['default_warehouse'].lot_stock_id sub_loc_01 = self.env['stock.location'].create([{ 'name': 'Sub Location 1', 'usage': 'internal', 'location_id': stock_location.id, }]) self.env["stock.putaway.rule"].create({ "location_in_id": stock_location.id, "location_out_id": sub_loc_01.id, "product_id": self.product_a.id, }) po = self.env['purchase.order'].create({ 'partner_id': self.partner_a.id, 'order_line': [ (0, 0, { 'product_id': self.product_a.id, 'product_qty': 2.0, })], }) po.button_confirm() picking = po.picking_ids self.assertEqual(po.state, "purchase") self.assertEqual(picking.move_line_ids.location_dest_id.id, sub_loc_01.id) picking.move_line_ids.write({'quantity': 1}) picking.move_ids.write({'picked': True}) res_dict = picking.button_validate() self.env[res_dict['res_model']].with_context(res_dict['context']).process() backorder = picking.backorder_ids self.assertEqual(backorder.move_line_ids.location_dest_id.id, sub_loc_01.id) def test_inventory_adjustments_with_po(self): """ check that the quant created by a PO can be applied in an inventory adjustment correctly """ product = self.env['product.product'].create({ 'name': 'Product A', 'is_storable': True, }) po_form = Form(self.env['purchase.order']) po_form.partner_id = self.partner_a with po_form.order_line.new() as line: line.product_id = product line.product_qty = 5 po = po_form.save() po.button_confirm() po.picking_ids.move_ids.quantity = 5 po.picking_ids.move_ids.picked = True po.picking_ids.button_validate() self.assertEqual(po.picking_ids.state, 'done') quant = self.env['stock.quant'].search([('product_id', '=', product.id), ('location_id.usage', '=', 'internal')]) wizard = self.env['stock.inventory.adjustment.name'].create({'quant_ids': quant}) wizard.action_apply() self.assertEqual(quant.quantity, 5) def test_po_edit_after_receive(self): # Picking types can be detached from any warehouse; ensure PO confirmation still works. self.company_data['default_warehouse'].in_type_id.warehouse_id = False self.po = self.env['purchase.order'].create(self.po_vals) self.po.button_confirm() self.po.picking_ids.move_ids.quantity = 5 self.po.picking_ids.move_ids.picked = True self.po.picking_ids.button_validate() self.assertEqual(self.po.picking_ids.move_ids.mapped('product_uom_qty'), [5.0, 5.0]) self.po.with_context(import_file=True).order_line[0].product_qty = 10 self.assertEqual(self.po.picking_ids.move_ids.mapped('product_uom_qty'), [5.0, 5.0, 5.0]) def test_po_edit_after_receive_2_steps_route(self): self.company_data['default_warehouse'].reception_steps = 'two_steps' self.po = self.env['purchase.order'].create(self.po_vals) self.po.button_confirm() self.po.picking_ids.move_ids.quantity = 1 Form.from_action(self.env, self.po.picking_ids.button_validate()).save().process() self.assertEqual(self.po.picking_ids.move_ids.mapped('product_uom_qty'), [1.0, 1.0, 4.0, 4.0]) self.po.order_line[0].product_qty = 3 self.assertEqual(self.po.picking_ids.move_ids.mapped('product_uom_qty'), [1.0, 1.0, 2.0, 4.0]) def test_receive_returned_product_without_po_update(self): """ Receive again the returned qty, but with the option "Update PO" disabled At the end, the received qty of the POL should be correct """ po = self.env['purchase.order'].create(self.po_vals) po.button_confirm() receipt01 = po.picking_ids receipt01.move_ids.quantity = 5 receipt01.button_validate() wizard = Form(self.env['stock.return.picking'].with_context(active_ids=receipt01.ids, active_id=receipt01.id, active_model='stock.picking')).save() wizard.product_return_moves.quantity = 5 wizard.product_return_moves.to_refund = False res = wizard.action_create_returns() return_pick = self.env['stock.picking'].browse(res['res_id']) return_pick.move_ids.quantity = 5 return_pick.button_validate() wizard = Form(self.env['stock.return.picking'].with_context(active_ids=return_pick.ids, active_id=return_pick.id, active_model='stock.picking')).save() wizard.product_return_moves.quantity = 5 wizard.product_return_moves.to_refund = False res = wizard.action_create_returns() receipt02 = self.env['stock.picking'].browse(res['res_id']) receipt02.move_ids.quantity = 5 receipt02.button_validate() self.assertEqual(po.order_line[0].qty_received, 5) self.assertEqual(po.order_line[1].qty_received, 5) def test_receive_negative_quantity(self): """ Receive a negative quantity, the picking should be a delivery and the quantity received negative and no incoming empty picking should be created. """ self.product_id_2.type = 'consu' po_vals = { 'partner_id': self.partner_a.id, 'order_line': [Command.create({ 'name': self.product_id_2.name, 'product_id': self.product_id_2.id, 'product_qty': -5.0, 'uom_id': self.product_id_2.uom_id.id, 'price_unit': 250.0, })], } po = self.env['purchase.order'].create(po_vals) po.button_confirm() # one delivery, one receipt self.assertEqual(len(po.picking_ids), 1) self.assertEqual(po.picking_ids.picking_type_id.code, 'outgoing') self.assertEqual(po.picking_ids.partner_id, self.partner_a) po.picking_ids.button_validate() self.assertEqual(po.order_line.qty_received, po.order_line.product_qty) self.assertEqual(self.env['stock.picking'].search_count([('origin', '=', po.name), ('picking_type_id.code', '=', 'incoming')]), 0) @skip('Temporary to fast merge new valuation') def test_receive_qty_invoiced_but_no_posted(self): """ Create a purchase order, confirm it, invoice it, but don't post the invoice. Receive the products. """ self.product_id_1.is_storable = True self.product_id_1.categ_id = self.env.ref('product.product_category_goods').id self.product_id_1.categ_id.property_cost_method = 'average' po = self.env['purchase.order'].create(self.po_vals) po.button_confirm() self.assertEqual(po.order_line[0].product_id, self.product_id_1) # Invoice the PO action = po.action_create_invoice() invoice = self.env['account.move'].browse(action['res_id']) self.assertTrue(invoice) # Receive the products receipt01 = po.picking_ids receipt01.button_validate() self.assertEqual(receipt01.state, 'done') self.assertEqual(po.order_line[0].qty_received, 5) self.assertEqual(po.order_line[0].price_unit, 500) layers = self.env['stock.valuation.layer'].search([('product_id', '=', self.product_id_1.id)]) self.assertEqual(len(layers), 1) self.assertEqual(layers.quantity, 5) self.assertEqual(layers.value, 2500) def test_stock_picking_type_for_deliveries_generated_from_po(self): """ Checks that the stock picking type of a PO generated by an orderpoint influence the destination of the delivery, if the stock picking type is more precise than the orderpoint. """ self.env['stock.route'].search([('name', '=', 'Buy')]).warehouse_ids = self.env['stock.warehouse'].search([]) product = self.env['product.product'].create({ 'name': 'Super product', 'is_storable': True, 'seller_ids': [Command.create({ 'partner_id': self.partner_a.id, 'price': 100.0, })] }) stock_location = self.company_data['default_warehouse'].lot_stock_id intermediate_location = self.env['stock.location'].create([{ 'name': 'intermediate Location', 'usage': 'internal', 'location_id': stock_location.id, }]) sub_location = self.env['stock.location'].create([{ 'name': 'Sub Location', 'usage': 'internal', 'location_id': intermediate_location.id, }]) super_receipt = self.env['stock.picking.type'].create({ 'name': 'Super receipt', 'code': 'incoming', 'sequence_code': 'SR', 'default_location_src_id': self.env.ref("stock.stock_location_suppliers").id, 'default_location_dest_id': sub_location.id, }) orderpoint = self.env['stock.warehouse.orderpoint'].create({ 'product_id': product.id, 'qty_to_order': 1.0, 'location_id': stock_location.id, 'trigger': 'manual', }) orderpoint.action_replenish() po = self.env['purchase.order'].search([("product_id", "=", product.id)], limit=1) po.picking_type_id = super_receipt po.button_confirm() picking = po.picking_ids self.assertEqual(picking.location_dest_id, sub_location) stock_move = picking.move_ids self.assertEqual(stock_move.location_dest_id, sub_location) stock_move.quantity = 1.0 picking.button_validate() self.assertEqual(picking.move_ids.location_dest_id, sub_location) def test_foreign_bill_autocomplete_with_payment_term(self): """ Test the bill auto-complete with a PO having a payment term in a foreign currency """ currency = self.env['res.currency'].create({ 'name': "Test", 'symbol': 'T', 'rounding': 0.01, 'rate_ids': [ Command.create({'name': '2021-01-13', 'rate': 1.5}), ], }) po = self.env['purchase.order'].create({ 'partner_id': self.partner_a.id, 'currency_id': currency.id, 'payment_term_id': self.pay_terms_a.id, 'order_line': [Command.create({ 'product_id': self.product_id_1.id, 'price_unit': 100.0, 'tax_ids': [Command.set(self.tax_purchase_a.ids)], })], }) po.button_confirm() picking = po.picking_ids[0] picking.move_line_ids.quantity = 1.0 picking.move_ids.picked = True picking.button_validate() move_form = Form(self.env['account.move'].with_context(default_move_type='in_invoice')) move_form.purchase_vendor_bill_id = self.env['purchase.bill.union'].browse(-po.id) invoice = move_form.save() self.assertEqual(invoice.currency_id, currency) self.assertEqual(invoice.invoice_payment_term_id, self.pay_terms_a) line = invoice.invoice_line_ids[0] self.assertEqual(line.amount_currency, 100.0) self.assertEqual(line.balance, 66.67) def test_bill_on_ordered_qty_correct_converted_amount_on_bill(self): """ Ensure bill line balance is correctly calculated from a purchase order line.""" product1, product2 = self.test_product_order, self.test_product_delivery product1.write({'purchase_method': 'purchase', 'standard_price': 500}) euro = self.env.ref('base.EUR') euro.active = True self.env['res.currency.rate'].create({ 'name': fields.Date.today() - timedelta(days=1), 'company_rate': 1.10, 'currency_id': euro.id, 'company_id': self.env.company.id, }) purchase_order = self.env['purchase.order'].create({ 'partner_id': self.partner_a.id, 'currency_id': euro.id, 'order_line': [Command.create({ 'product_id': product1.id, 'product_qty': 8, }), Command.create({ 'product_id': product2.id, 'product_qty': 8, })], }) purchase_order.button_confirm() purchase_order.action_create_invoice() product1_order_line_price_unit = purchase_order.order_line.filtered( lambda ol: ol.product_id == product1 ).price_unit bill1_line_balance = purchase_order.invoice_ids.invoice_line_ids.filtered('balance').balance self.assertAlmostEqual( bill1_line_balance, purchase_order.currency_id._convert( product1_order_line_price_unit * 8, self.env.company.currency_id, ), places=self.env.company.currency_id.decimal_places, ) purchase_order.picking_ids.button_validate() purchase_order.action_create_invoice() product2_order_line_price_unit = purchase_order.order_line.filtered( lambda ol: ol.product_id == product2 ).price_unit bill2_line_balance = purchase_order.invoice_ids.invoice_line_ids.filtered( lambda bl: bl.product_id == product2 and bl.balance ).balance self.assertAlmostEqual( bill2_line_balance, purchase_order.currency_id._convert( product2_order_line_price_unit * 8, self.env.company.currency_id, ), places=self.env.company.currency_id.decimal_places, ) def test_foreign_bill_tax_included(self): """ Test the bill values with a PO having tax included in price """ currency = self.env['res.currency'].create({ 'name': "Test", 'symbol': 'T', 'rounding': 0.01, 'rate_ids': [ Command.create({'name': '2021-01-13', 'rate': 1.5}), ], }) tax_price_include = self.env['account.tax'].create({ 'name': '10% incl', 'type_tax_use': 'purchase', 'amount_type': 'percent', 'amount': 10, 'price_include_override': 'tax_included', 'include_base_amount': True, }) po = self.env['purchase.order'].create({ 'partner_id': self.partner_a.id, 'currency_id': currency.id, 'payment_term_id': self.pay_terms_a.id, 'order_line': [Command.create({ 'product_id': self.product_id_1.id, 'price_unit': 100.0, 'product_qty': 3, 'tax_ids': [Command.set(tax_price_include.ids)], })], }) po.button_confirm() picking = po.picking_ids[0] picking.move_line_ids.quantity = 3.0 picking.move_ids.picked = True picking.button_validate() po.action_create_invoice() self.assertRecordValues(po.invoice_ids.line_ids.sorted('tax_line_id'), [ { 'amount_currency': 27.27, 'credit': 0.0, 'debit': 18.18, }, { 'amount_currency': 272.73, 'credit': 0.0, 'debit': 181.82, }, { 'amount_currency': -300.0, 'credit': 200.0, 'debit': 0.0, }, ]) def test_log_activity_in_po_with_receipt_without_backorders(self): """ Checks if a warning note is created in a PO in case a transfer is validated with incomplete quantities and without backorders. In multi-step receipts, the note should only be created if the first transfer doesn't have backorders. """ expected_note = """