Skip to Content
This question has been flagged
1 Reply
2111 Views
Avatar
Remya

I want to calculate the landed cost for a particular shipment. 

In PO
item 1 => Qty-2 => 1000 * 2 = 2000
item 2 => Qty-10 => 200 * 10 = 2000
 
But we only receiving
item 1 => Qty-1 => 1000 * 1 = 1000
item 2 => Qty-4  => 200 * 4 = 800

So in the incoming shipment it only contains product_id, quantity delivered not the product price mentioned in the purchase order.

I need to calculate the total amount of products based on shipment ie, below
Total PO amount for the partial receiving = 1000*1 + 200*4 = 1000 + 800 = 1800

How I get the 1800 amount in my landed cost module?

 I need to take the product price from that particular purchase order, not from the product master.

How can I achieve this?
 


First, I select incoming shipment ie, picking_ids. 


Avatar
Discard
Avatar
Sudhir Arya (ERP Harbor Consulting Services)
Best Answer

Hi Remya,

In Stock Move, you have the reference of the Purchase Order Line (purchase_line_id). Using this field you can get the price from the purchase order line for the related stock move.

Ex:

move.purchase_line_id.price_unit * move.product_uom_qty


Avatar
Discard