Skip to Content
Dette spørgsmål er blevet anmeldt
purchasestock_pickingorder
2 Besvarelser
2711 Visninger
Avatar
Panos Anagnostakis

I have a purchase order that contains 100 units of product A. 


The supplier executes the order, but sends 100 units of product B that has the same properties with product A (it's just from another firm, but otherwise has the same properties with product A).


When I receive the products in the order's corresponding stock picking I add another stock move to receive 100 units of product B and 0 units of product A.


What I would like is when I validate the stock picking to automatically update the order and add an extra line in order lines that includes the product B with ordered qty=0 and received qty=100.


In short, I want the order to be updated with the extra lines I add in the corresponding stock picking.

Avatar
Kassér
Avatar
Panos Anagnostakis
Forfatter Bedste svar

I managed to achieve the result by overriding the validate_button script when validating the stock picking: 

def button_validate(self):
        for picking in self:
            if picking.purchase_id:
                picking.purchase_id.state="draft"
                for move in picking.move_ids_without_package:
                    if move.quantity_done > 0:
                    	​po_line = picking.purchase_id.order_line.filtered(lambda l: l.product_id == move.product_id)                                                	​	​	​	​if not po_line:
                       	​	​order_line_id =picking.purchase_id.order_line.create({
	​                	​	​	​'order_id': move.purchase_line_id=order_line_id.id,
	​	​	​	​	​	​	​'product_id': move.product_id.id,                        	​	​	​	​	​		​'name': move.product_id.display_name,                                	​	​	​	     'product_qty_uom': move.quantity_done,                                	​	​	​	​'product_qty':move.quantity_done,                                                           'product_uom': move.product_uom.id,                                                         'date_planned': picking.scheduled_date,})

	​	​	​               picking.purchase_id.state="purchase"        
        
	​	​res=super(StockPickingInherit,self).button_validate() 
		​​return res

before validation I modify the state of the purchase order to draft, I then add purchase order lines with the extra products that are in the stock picking but not in the order and finally I revert the state to purchase. It is important to link the stock picking line with the purchase order line through the stock.move.purchase_line_id field.



Avatar
Kassér
Franck Herzog

Are you still using this solution . V17 or v18 ? i have the same issu with some delivery that have to be modified from PO

Avatar
Lars Aam
Bedste svar

Odoo allows to receive products without any purchase order. In many business cases this is necessary. You would need to update the purchase order before the goods receipt if you want to have it in your purchase order.

If not in you purchase order, you would need to post the vendor invoice without reference to a purchase order.

But if product B have the same properties as product A, why don't you manage them as the same product on your end?  If you need traceability, set up lot number in the Inventory.

Avatar
Kassér
Panos Anagnostakis
Forfatter

Product B has a different barcode, price and other minor differences which are not of importance. I consider it a variant, but nevertheless it is a different product.

Lars Aam

General recommendation for internal logistics is to relabel everything at goods reciept with your own labels. With using Variants or manage as two different producst, you must know at the point where you register sales order to choose the correct. As long as customer can receive either or. Seems to me tricky to manage efficient.

Related Posts Besvarelser Visninger Aktivitet
purchase order report Løst
purchase order
Avatar
Avatar
Avatar
3
sep. 18
10290
Customer on Purchase Order Løst
purchase customer order
Avatar
Avatar
1
dec. 24
2829
Updating a receipt Løst
purchase receipt order
Avatar
Avatar
2
aug. 22
4922
Registering incoming productw with the Purchase Unit of Measure
purchase stock_picking units
Avatar
0
sep. 20
2920
block the account move creation when purchase order receipt is confirmed. Løst
purchase stock stock_picking
Avatar
Avatar
Avatar
2
mar. 19
5248