Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
purchasestock_pickingorder
2 Vastaukset
2716 Näkymät
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
Hylkää
Avatar
Panos Anagnostakis
Tekijä Paras vastaus

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
Hylkää
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
Paras vastaus

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
Hylkää
Panos Anagnostakis
Tekijä

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.

Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
purchase order report Ratkaistu
purchase order
Avatar
Avatar
Avatar
3
syysk. 18
10296
Customer on Purchase Order Ratkaistu
purchase customer order
Avatar
Avatar
1
jouluk. 24
2831
Updating a receipt Ratkaistu
purchase receipt order
Avatar
Avatar
2
elok. 22
4928
Registering incoming productw with the Purchase Unit of Measure
purchase stock_picking units
Avatar
0
syysk. 20
2921
block the account move creation when purchase order receipt is confirmed. Ratkaistu
purchase stock stock_picking
Avatar
Avatar
Avatar
2
maalisk. 19
5255